Hi everyone,
I am working on a task where I want to compare values in a read-only grid. The data in the field consists of text-type values, for example: k(100), k(101), SH(300).
While applying filters in the read-only grid, I want data whose values are greater than 100. Here, we should check only the number in the text.
is there any possibility to achieve this functionality
Discussion posts and replies are publicly visible
Create a custom record field, choose expression, and use the tointeger() function to extract the number. Then you can use this new field for sorting and filtering.
Stefan Helzle Thank you for the reply, I tried this approach, but I am getting this error when i used tointeger(recordtype!fieldName)error:Test currently unavailable due to an error There was an error with the custom record field "Custom Record Field". Expression evaluation error at function 'tointeger': Could not cast from Record Field to Number (Integer). Details: CastInvalid
You have to reference the field value, not the field.
tointeger(rv!record[recordtype!YOUR_RECORD.FIELD])
Stefan Helzle
it is working when i select sync time evaluation and not working when i select realtime evaluation
Yes. That's correct.
Thank you Stefan Helzle