Expression evaluation error at function a!gridField : A grid component has an invalid value for "userFilters". "userFilters" and "showSearchBox" may only be specified when the when "data" is sourced from record type

Question

I am getting above error, I have a doubt for now I am using record data function to get the data and using it as a source for grid component. i tried changing source to result to queryrecordtype instead of recorddata also . so as this message suggest Do I need to directly reference the recordtype in the data field of grid component?

Shubham Aware · Answer

Your rule might returns null when conditions aren't met. The grid's data parameter must always have record-sourced data when using userFilters/showSearchBox.
Never return null from your rule. Always return a!recordData(), even if it's filtered to return zero records when conditions aren't met.

Shubham Aware · Answer

Yes, But Make sure, It will return ALL records (or records matching remaining filters) when values are empty. Test the rule properly to ensure it returns recordData instead of null.

Harsha Sharma · Answer

In the 'data' of the grid you should configure the a!recordData() code directly. You can remove the local!data as well as the rule having a!recordData. Whatever filters you need to apply you can configure all that in the a!recordData() corresponding to 'data' of grid. The filter/logical expressions should have ignoreFIltersWithEmpty values so that a!recordData() returns data when filters are empty.

Mike Schmitt · Answer

To confirm, you can only use the built-in search functions when the grid itself does the querying. If you want to filter outside the grid's built-in controls (which I usually just do anyway, thanks to added flexibility etc), you need to build your own filtering fields and make sure they're reflected in the data query.