Skip to main content
May 11, 2021
Solved

Having problem with the query-filter for read-only-grid. How do I solve the problem?

  • May 11, 2021
  • 4 replies
  • 2 views

- trying to add a query-filter to the read-only-grid

- error message:

- the field "PJ_ID" is type TEXT,

- the value of the local!selectedRows:

- it works fine when working like below: 

-field "id" is type INTEGER

Best answer by danny.verb

Try replacing tostring() with touniformstring()

4 replies

danny.verb
May 11, 2021

Try replacing tostring() with touniformstring()

May 11, 2021

thank you!

It works well !!!

mikes0011
Brainy
May 11, 2021

tostring() converts anything you pass in, to a single string.  toInteger() works differently on an array, and will typecast the entries of the array to integer but keeping the array format.

You might want to try the function "toUniformString()" instead.

The Expression Guru
May 11, 2021

thank you!

It works great !!!