jQWidgets Forums
Forum Replies Created
-
Author
-
November 25, 2020 at 6:52 am in reply to: PivotGrid: Load JSON Data PivotGrid: Load JSON Data #113689
Hi Peter,1 more comment on the Pivot Designer: The injection of the classes for the Designer-Object has an error:
class="jqx-rc-all jqx-widget jqx-pivotgrid <strong>jqx-designer-hostjqx-widget-content</strong>"
jqx-designer-host and jqx-widget-content have no space in between and are not active.
I have tried to position the Pivot Designer relative to a table cell, which didn’t work as expected:<table id'someTable><tr><td>Some Conetent</td></tr></table> <table class='pivotTable' id='pivotTable' width='100%' border='0'> <TR> <td><div id='divPivotGridDesigner' class='pivotDesigner'></div> </td> <td><div id='divPivotGrid' class='pivotGrid'></div> </td></TR> </table>
The Designer Object is placed always outside of the table cell.
Best Regards
MichaelNovember 23, 2020 at 4:44 pm in reply to: PivotGrid: Load JSON Data PivotGrid: Load JSON Data #113672Thank you Peter, this was the solution – it works just great!
Best Regards
MichaelAugust 5, 2016 at 10:53 am in reply to: How to get the Value of the first item in the viewport? How to get the Value of the first item in the viewport? #86354Thank you for the reply, but the example shows only the identification of a selected item. Perhaps my explanation was not detailed enough: The Listbox has 1000 items with the values 1 – 1000. The items itself are displayed as an image through custom rendering, the value-members are the numbers. I would like to use the mobile wiping action which makes the listbox scrolling through the images without selecting any. This works fine, but in addition I have to show the current number of the image in the viewport (which is not selected, but comes into the viewport through the wiping action). How can I identify the item occurring in the viewport?
November 15, 2015 at 9:32 am in reply to: 3 jqxgrid in jqxtab with remote data – don't stop loading 3 jqxgrid in jqxtab with remote data – don't stop loading #78156Hello,
thank you for this helpful hint – I inserted “initTabContent: initWidgets” like the demo and everything works fine,
best regards
MikeNovember 14, 2015 at 4:43 pm in reply to: 3 jqxgrid in jqxtab with remote data – don't stop loading 3 jqxgrid in jqxtab with remote data – don't stop loading #78144Hello,
a few more findings:
Grid on page 1 is loading always correct – if I change the order of the pages all three Grids are loaded correctly if they are on page 1. The grids on page 2 and 3 fire the “beforeLoad” event, but then raise the error “Uncaught TypeError: Cannot read property ‘length’ of undefined”.June 2, 2015 at 9:12 am in reply to: updateBoundData with local Array is not working updateBoundData with local Array is not working #71897Thank you Dimitar
it works perfect in the application!
May 29, 2015 at 6:46 am in reply to: updateBoundData with local Array is not working updateBoundData with local Array is not working #71765I have build my own fiddle – hopefully it works
for you: http://jsfiddle.net/drmikegross/rf0rwjLs/
Best Regards
MichaelMay 29, 2015 at 6:14 am in reply to: updateBoundData with local Array is not working updateBoundData with local Array is not working #71764Hello Dimitar,
sorry, the code:
The datatable shows the data correctly after staring the app, after pressing one of the buttons, the localdata are changed. The timer fired the event correctly, but the datatable does no update:<!DOCTYPE html>
<html lang=”en”>
<head>
<title id=’Description’>Mobile Notification Viewer</title>
<link rel=”stylesheet” href=”/gw/stylesheets/jqx.base.css” type=”text/css” />
<script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/scripts/jquery-1.11.1.min.js”></script>
<script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxcore.js”></script>
<script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxvalidator.js”></script>
<script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxexpander.js”></script>
<script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxcheckbox.js”></script>
<script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxbuttons.js”></script>
<script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxmaskedinput.js”></script>
<script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxinput.js”></script>
<script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxtooltip.js”></script>
<script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxdata.js”></script>
<script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxscrollbar.js”></script>
<script type=”text/javascript” src=”/js/jqwidgets-ver3.8.0/jqwidgets/jqxdatatable.js”></script><script type=”text/javascript”>
var gettimer = 0;
var localdata = new Array();
$(document).ready(function () {
localStorage.actual = ‘{“msgid”:400,”feld1″:”05:33″,”feld2″:”20:40″,”feld3″:”18″}’;
localdata = getlocaldata();
var localsource =
{
datatype: “array”,
localdata: localdata,
datafields: [
{ name: ‘nr’, type: ‘num’ },
{ name: ‘bez’, type: ‘string’ },
{ name: ‘inhalt’, type: ‘string’ }
]
};
var localAdapter = new $.jqx.dataAdapter(localsource);
$(“#dataTable”).jqxDataTable(
{
autoShowLoadElement: true,
showHeader: false,
columnsHeight: 20,
width: 300,
source: localAdapter,
altRows: true,
pageable: false,
pageSize: 3,
scrollBarSize: 0,
columns: [
{ text: ”, dataField: ‘bez’, width: 100 },
{ text: ”, dataField: ‘inhalt’, width: 200 }
]
});
if (gettimer == 0) {
gettimer = setInterval(function () {
localdata = getlocaldata();
localAdapter.dataBind();
$(“#dataTable”).jqxDataTable(‘updateBoundData’);
alert(‘Update done’);
}, 10000);
};
$(‘#Button1’).on(‘click’, function () {
localStorage.actual = ‘{“msgid”:401,”feld1″:”10:14″,”feld2″:”19:30″,”feld3″:”44″}’;
});
$(‘#Button2’).on(‘click’, function () {
localStorage.actual = ‘{“msgid”:402,”feld1″:”10:19″,”feld2″:”19:40″,”feld3″:”60″}’;
});
$(‘#Button3’).on(‘click’, function () {
localStorage.actual = ‘{“msgid”:403,”feld1″:”10:45″,”feld2″:”19:50″,”feld3″:”89″}’;
});});
function getlocaldata() {
var records = {};
records = JSON.parse(localStorage.actual);
if (records !== undefined) {
var data = new Array();
var row = {};
row[‘nr’] = 0;
row[‘bez’] = ‘Feld 1’;
row[‘inhalt’] = records[‘feld1’];
data[0] = row;
row = {};
row[‘nr’] = 1;
row[‘bez’] = ‘Feld 2’;
row[‘inhalt’] = records[‘feld2’];
data[1] = row;
row = {};
row[‘nr’] = 2;
row[‘bez’] = ‘Feld 3’;
row[‘inhalt’] = records[‘feld3′];
data[2] = row;
};
return (data);
};</script>
</head>
<body><table bgcolor=’#FFFFFF’ border=’1′>
<tr><td height=’380′ valign=’bottom’>
<div id=”dataTable”>
</div></td></tr>
<tr><td height=’30’ style=”text-align: center;”>
<input type=”button” value=”Update1″ id=”Button1″ />
<input type=”button” value=”Update2″ id=”Button2″ />
<input type=”button” value=”Update3″ id=”Button3″ /></td>
</tr></table>
</body>Hi Dimitar,
the server call sends all 6963 records as can be verfied by calling the url directly in the browser.I have identified the problem: the grid in virtual mode does not care about unique values in the ‘id’ column – the grid with virtualmode = false does. After setting the ‘id’ column to the unique current number, all records where loaded and displayed in the grid.
Thank you for your help,
MichaelHello Dimitar,
thank you, but the real problem is, that the grid does not load all data out of the dataadapter if virtual mode is set to false. The same code with virtual mode = true loads all dataThe code is:
....<script type="text/javascript"> $(document).ready(function () { var source = { datatype: "json", datafields: [ { name: 'lfdnr', type: 'int' }, { name: 'sc', type: 'string' }, { name: 'dep-id', type: 'int' }, { name: 'active', type: 'string' }, { name: 'code', type: 'string' }, { name: 'costcenter', type: 'string' }, { name: 'org-chart-desc', type: 'string' } ], url: "http://85.214.117.215/portal/wa6tst.slag/getorgunitcost.p", id: 'dep-id', sortcolumn: 'dep-id', sortdirection: 'asc', data: { typ: 'JSON', code: '', name: '', sc: '' } }; var columns = [ { text: 'RecID', dataField: 'lfdnr', width: 50, editable: false }, { text: 'Country', dataField: 'code', editable: false, width: 100 }, { text: 'Cost Center', dataField: 'costcenter', width: 100, editable: false }, { text: 'Code', dataField: 'sc', editable: false, width: 100 }, { text: 'Org-Unit ID', dataField: 'dep-id', editable: false, width: 100 }, { text: 'Hierarchie Level', dataField: 'org-chart-desc', editable: false, width: 200 }, { text: 'Active', editable: false, dataField: 'active', editable: false, checkbox: true, columntype: 'checkbox', width: 50 }, ]; var dataAdapter = new $.jqx.dataAdapter(source, { }); $("#grid").jqxGrid( { theme: 'marlin', width: '800', autoheight: true, columnsresize: true, columnsreorder: true, source: dataAdapter, selectionmode: 'singlecell', sortable: true, filterable: true, filtermode: 'default', autorowheight: true, editable: false, autoshowcolumnsmenubutton: true, enablemousewheel: false, altrows: true, pageable: true, pagermode: 'default', columns: columns }); }); </script> </head> <body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <form name="selectform" action="grid_virtualmode.htm" method="POST"> <div id='jqxWidget' style='margin-top: 0px; margin-left: 0px; float: left;'> <div id="grid"> </div> </div> </form> </body>
Kind regards
Michael -
AuthorPosts