About EasyMorph Tutorials & Examples Web-help

Apply Between filters on Strings


#1

Hello,
I have a table where one of the fields is an alphanumeric string, something like the list below. Each character can have any value [0-9][A-Z].

1210I00358
1210I00359
1210I00360
1210I00361
1210I00362
1210I00363
1210I00364
1210I14200
1210J00000
121NFVR000
121NFVRB00
HS000D0000
HS00T40000
99HSNREC09
HS00L31102
HS00NNREC9

These values can be sort and in other tools I am able to apply a between two strings (SQL accepts this notation):
In SAP BO
image
image

However, in easymorph it isn’t possible to apply a between condition to text fields. There is any workaround that we can do in EM to manage these situations?

Thank you!


#2

Hello @sousas,

you can switch the filtering pane in the Condition Builder to the custom SQL mode and write the filtering condition using SQL.


#3

Thank you very much for your answer. I would like something inside the visual query, but it is something, Thanks!