cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic filter using apply_filter throws an error?

JGT
Discoverer
0 Kudos
121

Am trying to write a simple Table function that accepts 1 parameter as character with length 500 for dynamic filter using APPLY_FILTER

JGT_0-1731141160293.png

Script looks like below

JGT_1-1731141254389.png

table to be queried contains 2 lines

JGT_2-1731141342070.png

If I execute the table function with 25000 as input, I get the error below saying invalid number? The underlying data type of this column is character 10

 

JGT_4-1731141546309.png

Any ideas? thanks

 

 

 

 

View Entire Topic
JGT
Discoverer
0 Kudos

Fixed by passing the values in single quote