Filter input node for Export Data Store Entity to Excel Smart Service is not working for multiple filters and is unable to handle null.
Discussion posts and replies are publicly visible
Hi Mohit,AFAIK, this will work for single filter only, Filters(Any Type) Single value type though it is mentioned in document as multiple.Please refer: https://docs.appian.com/suite/help/18.3/Export_To_Excel_Smart_Service.html
and also refer smart service input field properties.
Thanks
Hi Mohit,
Multiple filters can be handled via this smart service.
You can create an expression rule with a logical expression and that rule can be called in the screenshot for filter value.
Regards,
Vadivelan
Hi Vadivelan,
Can you help me, it is not working for date filter between operator
eg like : a!queryFilter( field: "requestreceived", operator: "between", value: { todatetime( ri!dateAsc ), todatetime( ri!dateDesc ) }, applyWhen: if( or( rule!APN_isEmpty( ri!dateAsc ), rule!APN_isEmpty( ri!dateDesc ) ), false(), true() ) ),
I got belpw error while runing on filter "
please help on this how to achieve.
Bhanu Prakash
Please post a screenshot of the expression configuration (i.e. where you have the above code) in your smart service node, as other than the extra comma at the end, that looks like a valid queryFilter.
did you able to figure out the issue ?
You could try to use a cast on the date variables as specified in https://docs.appian.com/suite/help/18.2/Export_To_CSV_Smart_Service.html. for the date functions.
"cast('type!{www.appian.com/.../2009}Date', today())
or cast('type!{www.appian.com/.../2009}Datetime', now())"
cast('type!{www.appian.com/.../2009}Datetime', now())"
I had a similar error and solved it by making a cast.
This solved it for me!
No idea why though, this looks like a bug