Hi,
I am trying to build a grid with Group By. It works well as long as I add
features: [{ name: "GroupBy", type: "local", columnSettings: [{ columnKey: "ExpenseTypeID", isGroupBy: true }] } ]
If I do not add group by feature my grid displays data. After adding GroupBy Feature, the grid actually stops displaying data.
Hello Rocky,
The versions that you use are supported.
I am attaching a small sample using the latest SR of v12.1
Let me know if you have further questions.
I'm using JQuery API jquery-1.7.2.js. Is this OK?
Now I am getting (IndexOf) issue,. See attached
Thanks for your reply.
I am using jQuery UI 1.8.21. In console, I came to I was missing the reference of jquery.ui.droppable.js. Still some issue, I am working on this. Will post my results.
Thanks
Thank you for using our forums.
Can you please share if you receive any JS error in the console?
Which version of jQuery components, jQuery library , jQuiery UI library do you use?
Hope hearing from you.
Complete code following. It stops working for Group By feature, otherwise it shows data and works well
<script type="text/javascript" src="~/Scripts/IG/infragistics.loader.js"></script>@(Html.Infragistics().Loader() .ScriptPath(Url.Content("~/Scripts/IG/")) .CssPath(Url.Content("~/Content/IG/")) .Resources("igShared,igGrid.*,igCombo") .Render() )<script type="text/javascript">$('#gridExpenseTypeReviewerMatrix').igGrid( { dataSource: getExpenseTypeReviewer(), dataSourceType: 'json', autoGenerateColumns: false, autoGenerateLayouts: false, generateCompactJSONResponse: false, virtualization: false, width: '95%', columns: [ { key: 'ExpenseTypeID', dataType: 'number', headerText: 'Expense Type Name', width: '20%', formatter: lookupExpenseTypeName }, { key: 'ReviewerID', dataType: 'number', headerText: 'Reviewer Name', width: '20%', formatter: lookupExpenseReviewerName }, { key: 'MinimumAmount', dataType: 'number', headerText: 'Minimum Amount', width: '20%' }, { key: 'MaximumAmount', dataType: 'number', headerText: 'Maximum Amount', width: '20%' } ], features: [ { name: "Updating", enableAddRow: true, addRowLabel: "Add new Expense Type Reviewer", editMode: "row", enableDeleteRow: true, columnSettings: [ { columnKey: "ExpenseTypeID", editorType: "combo", required: true, validatorOptions: { keepFocus: true }, editorOptions: { dataSource: getExpenseTypeList(), valueKey: "ExpenseTypeID", textKey: "ExpenseTypeName" } }, { columnKey: "ReviewerID", editorType: "combo", required: true, validatorOptions: { keepFocus: true }, editorOptions: { dataSource: getReviewerList(), valueKey: "ReviewerID", textKey: "ReviewerName" } }, { columnKey: 'MinimumAmount', editorType: 'currency', editorOptions: { button: 'spin', symbol: '', minValue: 0, maxValue: 1000000000, validatorOptions: {} } }, { columnKey: 'MaximumAmount', editorType: 'currency', editorOptions: { button: 'spin', symbol: '', minValue: 0, maxValue: 1000000000, validatorOptions: {} } }] }, { name: "GroupBy", type: "local", columnSettings: [ { columnKey: "ExpenseTypeID", allowGrouping: false }, { columnKey: "ReviewerID", isGroupBy: true }, { columnKey: "MinimumAmount", allowGrouping: false }, { columnKey: "MaximumAmount", allowGrouping: false }, ] } ] });</script>
<table id="gridExpenseTypeReviewerMatrix"></table>