Hi Everyone,
I have a read only grid which is connected to Pie chart. When I open the report it should show all the rows with the selected filter but it is empty as below.
When I click on any slice in pie chart, the grid is displaying the respective rows
These are filter options I have used in my grid configuration
Please help me how to all the rows with selected filter (isresigned) in the read-only grid when opening the report.
Discussion posts and replies are publicly visible
a!isNotNullOrEmpty evaluates to true for a list of null values. That is one of the issues with that function. You will have to check each value individually and use and() or or() to combine them.
appian.rocks/.../
Hi Stefan,
Thanks for the reply. Could you please be more clear about checking each value individually.
HI p2005 , Is it possible to share your code ? Its difficult to understand and provide you the solution. Ans Stefan is saying you can not pass list of variables into function "a!isnullorEmpty" . So try passing one local variable at a time and use AND or OR to combine .
a!gridField( label: "", labelPosition: "ABOVE", data: a!recordData( recordType: 'recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member', filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{b3cd4fda-8b2e-4217-879b-0a6f2660b51c}lastworkingdate', operator: "between", value: { local!fromDate, local!toDate }, applyWhen: a!isNotNullOrEmpty({ local!fromDate, local!toDate }) ), a!queryFilter( field: 'recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{4b996852-040f-4353-a317-fe30da06ea1e}isresigned', operator: "=", value: true ) } ) ), columns: { a!gridColumn( label: "Id", sortField: 'recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{291130ee-5eae-4930-8fab-ebec63cb2d57}id', value: fv!row['recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{291130ee-5eae-4930-8fab-ebec63cb2d57}id'], align: "END" ), a!gridColumn( label: "First Name", sortField: 'recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{6b393e95-1843-4a26-835e-551c49e77244}firstname', value: a!linkField( links: { a!recordLink( label: fv!row['recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{6b393e95-1843-4a26-835e-551c49e77244}firstname'], recordType: 'recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member', identifier: fv!identifier ) } ) ), a!gridColumn( label: "Last Name", sortField: 'recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{4def6bb6-ead9-402b-af99-0b0aae015eeb}lastname', value: fv!row['recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{4def6bb6-ead9-402b-af99-0b0aae015eeb}lastname'] ), a!gridColumn( label: "Email Id", sortField: 'recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{0e27e35c-031e-4b17-a1dd-810f6e55ec5a}enterpriseid', value: fv!row['recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{0e27e35c-031e-4b17-a1dd-810f6e55ec5a}enterpriseid'] ), a!gridColumn( label: "Resource level", sortField: 'recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{75698e2e-f3d7-4a6a-a9f7-94f7efb1fcc1}resourcelevelid', value: index( rule!APN_resource_Data_getNameById( fv!row['recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{75698e2e-f3d7-4a6a-a9f7-94f7efb1fcc1}resourcelevelid'] ), "name" ), showWhen: false ), a!gridColumn( label: "Project", sortField: 'recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{8b2879f1-afde-44cc-a9e7-7f96d60e05ed}projectid', value: index( rule!APN_projectData_GetNameByID( id: fv!row['recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{8b2879f1-afde-44cc-a9e7-7f96d60e05ed}projectid'] ), "name" ) ), a!gridColumn( label: "Comments", sortField: 'recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{c31ee845-8f51-4ce7-be45-b8ab13eb55e2}comments', value: fv!row['recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{c31ee845-8f51-4ce7-be45-b8ab13eb55e2}comments'] ), a!gridColumn( label: "Total Exp", sortField: 'recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{7b4569a5-9b20-4c20-ad75-95410f0149ab}totalexp', value: fv!row['recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{7b4569a5-9b20-4c20-ad75-95410f0149ab}totalexp'] ), a!gridColumn( label: "Relevant Exp", sortField: 'recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{9499dd93-9ba0-4313-bdc7-0f5eff385e4f}relevantexp', value: fv!row['recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{9499dd93-9ba0-4313-bdc7-0f5eff385e4f}relevantexp'] ), a!gridColumn( label: "Wbse", sortField: 'recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{9ac6327b-70c2-4c32-a18e-1354a74d03e3}wbse', value: fv!row['recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{9ac6327b-70c2-4c32-a18e-1354a74d03e3}wbse'] ), a!gridColumn( label: "Is Resigned", sortField: 'recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{4b996852-040f-4353-a317-fe30da06ea1e}isresigned', value: a!richTextDisplayField( value: { a!richTextIcon( icon: if( fv!row['recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{4b996852-040f-4353-a317-fe30da06ea1e}isresigned'], "check-circle", "times-circle" ), color: if( fv!row['recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{4b996852-040f-4353-a317-fe30da06ea1e}isresigned'], "POSITIVE", "NEGATIVE" ), size: "MEDIUM" ), " ", a!richTextItem( text: if( fv!row['recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{4b996852-040f-4353-a317-fe30da06ea1e}isresigned'], "Yes", "No" ) ) } ) ), a!gridColumn( label: "Last Working Date", value: fv!row['recordType!{b470e02c-91b4-4a66-82ce-b39215d4869e}APN Team Member.fields.{b3cd4fda-8b2e-4217-879b-0a6f2660b51c}lastworkingdate'] ) }, pageSize: 100 )
This is my code the read only grid
Hi GopalK Could you please help me in this