Filter input node for Export Data Store Entity to Excel Smart Service is not working for multiple filters and is unable to handle null.

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.

Regards,

Bhanu Prakash

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.

Regards,

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())"

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