Skip to main content
Y
yongsungk0001
Known Participant
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
  • 10 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
danny.verbAnswer
Employee
May 11, 2021

Try replacing tostring() with touniformstring()

    Y
    yongsungk0001Author
    Known Participant
    May 11, 2021

    thank you!

    It works well !!!

    mikes0011
    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
      Y
      yongsungk0001Author
      Known Participant
      May 11, 2021

      thank you!

      It works great !!!

      Terms & ConditionsAccessibility statement