Hello ,
Iam working on chained aap where values of posting date from and to entered in Analytic aap .
But the aap is not recognising the value that was entered .
Below is the workflow and command entered . Any help would be appreciated .
Solved! Go to Solution.
You need to update the "Expression" in the Action tool.
It seems you're updating the Mode - value= "Custom". Change that to the option below.
Also, don't forget to use "Replace a specific string" and point to the dates you're replacing.
Cheers,
Hi @praneshsapmm,
This will be because your action tools are not configured correctly, the aim of the action tool is to allow the interface tool (in your case a date tool) to understand which part of your main workflow you want to be updated.
In this example i'm going to use a standard filter tool with a custom filter, but the same will apply to your in-db version:
Filter tool configuration: I'm looking for dates between a start date "2021-06-02" and an end date "2021-08-04"
I have two date interface tools, connected to the main workflow by two (automatically created) action tools:
In order to define how these date interface tools interact and affect the filter tool we need to amend the action tool to highlight the Expression, and below tick "Replace a specific string" For the action tool of our first date (i.e. start date) we want to replace JUST 2021-06-02
For the second action tool we want to replace JUST 2021-08-04
Start Date Action Tool:
End Date action tool:
This will allow the interface tools to update the particular elements of the filter function we've selected.
I've attached my workflow for you to download if needed!
Kind regards,
Jonathan
Hi @Jonathan-Sherman ,
This works . Thankyou very much .
Can you also let me know how to feed more than one value for list box condition mentioned below .
Thanks.
See two examples attached.
If it's a string value, you need to put the values in between quotes. So you need to use this config
And replace what's inside the IN clause
If they are numeric values, then you need just use comma as a separator (,). And replace the values inside the IN clause the same way.
Cheers,