Generic Sirt & Filter action block in Logic editor

[Former Member]

Hi all,

I want to filter Dates based on specified range ( FROM some Date TO some date).

Generic Sirt & Filter action block does not allow datatype other than text or number. If i set datatype as text then i am not able to apply criteria < , > ,<= ,>=

only = and != are working fine.

If i set it to number it is not working fine.

Please let me know how to filter dates using Logic editor.

Regards,

Shalaka

[Former Member]

The GenericSortFilter action depends on XPath, and XPath does not support comparison of strings (other than equality/non-equality).

Solutions are to:

1) Do it in SQL or in the call to your back-end system if you can

2) If not, you have to use a calculated column action to convert the date(s) to number(s), and use the Generic Sort/Filter action on those calculated column(s)

Rick