When quering records and displaying in grid field with filters, no data is retrieved.

Question

While Im using the grid field to display the record data and applying filters to it, I couldnt get any data. The grid is displayed as empty. 
 Please find the screen shot of my code. 
 
 I have used 2 queryFilters inside the filters section of gridField. Can we use two filters? I have the scenario to dropdown and dynamically filter more than 2 columns from the record. 
 Also I get the warnings from line 99 for rest of the gridField parameters.

Konduru Chaitanya · Answer

Hello pavithradevir9178 You can add multiple filters. You need to write those inside a!queryLogicalExpression() under the filters parameter. 
 a!recordData(
 recordType:"Your RecordType",
 filters: a!queryLogicalExpression(
 operator: "AND",
 filters: {
 a!queryFilter(),
 a!queryFilter()
 },
 ignoreFiltersWithEmptyValues: true
 )
 ) 
 
 Coming to the warning, you can hover over the icon and read the message. Its mostly because you have mixed up the parameters inside the recordData instead of the gridField

Stefan Helzle · Answer

Seems like you wrote the highlighted parameters inside a!recordData() instead of inside a!gridField().

Mike Schmitt · Answer

Unknown said: You can add multiple filters. You need to write those inside a!queryLogicalExpression() 
 a!recordData can be passed multiple filters though, without needing a QueryLogical Expression (as long as you need AND grouping logic). I believe Stefan's answer below is correct - there is a missing close-parenthesis to finish out the a!recordData call, before the user has started giving other parameters inherent to the Grid. Hence all the bad-syntax underlines and warning signs present in the screenshot.

When quering records and displaying in grid field with filters, no data is retrieved.

Top Replies