Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
Hi ,
In my grid some of the fields are doing sorting by clicking on up n down arrow button , but for one text fields its not working.
We have not specified anything for this sorting for other fields. How we can enable to particular column where this issue is coming.
Discussion posts and replies are publicly visible
Hi saurak,
You have to define field attribute in a!gridTextColumn() to make that field sort as shown bellow.
a!gridTextColumn( label: "Text Column", data: {}, field:"firstName" )
its declared already. I am able to click on column header but its not sorting.
What data your mapping that also causes error, because the data should be always primitive data type, so type cast that field value to primitive data type and try , it may works.
its text only.
Can you share your code and error that your getting, that might helps us to better understand .
a!gridTextColumn( label: "Test By", field: "createBy", data: if( rule!APN_isBlank( ri!testSet.data ), {}, a!forEach( items: index( ri!testSet.data, "testBy", null ), expression: rule!HELLO_getUserName( fv!item ) ) ) ),
Error is: Nothing is happening after clicking on column header.
I think data your mapping is "testBy" and doing sorting by "createBy" is both same data type ? and try to give index instead dot(.) in data.
yes both are same data type. Plz update where you are saying. Then will try again
Try This,
{ with( local!gridValues: todatasubset( index( ri!testSet, "data", null ), ri!paggingInfo ), a!gridField( label: "Paging Grid", labelPosition: "ABOVE", totalCount: 0, columns: { a!gridTextColumn( label: "Test By", field: "createBy", data: if( rule!APN_isBlank( local!gridValues.data ), {}, a!forEach( items: index( index( local!gridValues, "data", {} ), "createBy", null ), expression: rule!HELLO_getUserName( fv!item ) ) ) ) }, value: ri!paggingInfo, saveInto: ri!paggingInfo, validations: {}, shadeAlternateRows: true ) )}
getting below error.
Error Evaluating UI ExpressionExpression evaluation error in rule 'grid rule' (called by rule 'interface name') at function a!gridField: A grid component [label=“Hello to all”] has an invalid value for “columns” and “value”. All “data” arrays must not contain more items than the specified “batchSize”, but “batchSize” was 10 and the largest column data array had 500 items
Make changes to total count :
totalCount: index(local!gridValues,"totalCount",null),