Hello, all
I have been requested to use the record picker component and use the selected records in the picker to filter out the records (by identifier) in a read only grid. The record picker returns a list of variant and I need a list of integer in order to use the filter in the grid, otherwise it will return an incompatible type error.
Is there any way this can be done ?
the local!selectedApprovalID does return the values I am looking for, but I am getting an error :
" Cannot apply operator [IN] to field [approvalId] when comparing to value [TypedValue[it=197,v={TypedValue[it=1,v=12],TypedValue[it=1,v=23]}]]."
There was an answered question in this forum to use the index() function, but that also returns the same error.
Please help,
been stuck with this issue for some hours now.
Thanks.
Discussion posts and replies are publicly visible
Did you try to use the tointeger() function to turn that list into numbers?
Hi carlosg.r929912
In the value parameter of a query filter, include array to the local variable i.e., { local!selectedApprovalId }, try it once
Hi carlosg.r929912 , Try to do like this
no, that did not work.
thanks gayatria0439, this may have worked. but instead I solved using a cast function, which in principle can do the same thing.
Thanks for the suggestions to all.