Question

Read Only Grid filter data

Forum|Forum|1 year ago
June 20, 2025
4 replies
0 views

I have a read only grid with a record type as source, I have three columns that has dynamic values. Meaning, I am using 4 or 5 record fields and get average these are custom fields.

value: recordType!field1+recordType!field3+recordType!field3 / 3 --Its a numeric field lets say field name is "Avg value"

then I have one drop down that suppose to filter the values in readonly grid based on slection.

If I select the value ">1" from drop down readonly grid should filtered and show only records have "Avg value" column >=1

I am not able to use queryFilter as I don't have appropriate value for "Field"

stefanhelzle0001

This will not work. The filter applies to the record data, but not to the calculated value in the UI. Did you consider to use a custom record field for this average?

madhusudant8411Author

Yes, actually this average is also dynamic, its based on Months values, for standard values like three,Six, I have custom field but there is option where user can select any no of months, for that I have problem.

stefanhelzle0001

OK. Then, this will just not work. You cannot sort data by an unknown dynamic value.

shubhama926776

You cannot directly apply filters on custom fields in a record-source grid.
Instead, you need to switch to a manual grid source using a custom expression. In this expression, fetch the required fields, calculate the dynamic average, apply your filter logic, and then pass the filtered list to the grid. This approach allows full control over filtering based on user selections, even for dynamically calculated values.

Give it a try...

Sign up

Login with SSO

Login to the community

Login with SSO