In-Database filter Macro

[KB]

Hi,

I am trying to build macro for In-Database filter to change dates. I would like to have macro built filter which can be then used for different Connect In-DB data inputs. Ideally I am looking for something as simple as the screenshot attached. Unfortunately it does not work. Is it something which can be done?  

Cheers,

Karol

[ddiesel]

I have an application that has a similar configuration:

Action Tool Configuration:

The SQL Query ends with:

...Date Between '1-august-2017' And '15-august-2017'

Hope this helps! If not, please post more details.

[KB]

Hi ddiesel,

Thank you for sharing. However our workflow looks more like this (see attached) there are multiple connect In_Db connections and some of them require date change so ideal situation would be that the there is one date change which updates all date filters present in the query. Correct me if I am wrong but your app allows only date change for this specific In-Db connection / query. So if I have another query pointing to another table this app would not work, right?

[ddiesel]

@KB You can have two (or more) action tools connected to one interface tool.

Will a setup similar to this do the trick?

[KB]

Yes it would. 

How can I get this to work?

Option 1) I have tried as per your original suggestion and it worked however when I have added second action tool it did not. I cannot get second action tool to pass the date into the query.

Option 2) For filters my action tool does not work at all. Does not matter whether one action tool or two.  

Am I missing something?

[ddiesel · Accepted solution]

Can you share how your action are tools configured?

In the example I first provided, I use the "Replace a specific string" option. If both tools are configured as such with both variables in the Connect In-DB query, I don't know why it wouldn't work.

[ddiesel]

Also, I noticed that you are using Text Box Interface tool. What worked for me is the Date Interface tool.

[KB]

I figured it out! Thank you. It was all set up correctly, only thing I was missing was the tick box in the configuration properties window where you select which brows tools results to show. Since I did not tick second brows tool when I was testing I could not see the results. Since I could not see them I was thinking it does not produce any. Anyway Thanks for your help.

BTW the text tool does work also. 

[MichalK]

Hi,

The solution I often use to create parameterized DB queries is using 'Dynamic Input In-DB' tool:

In this example, I pass my parameters to a text input, then use Formula to write a SQL query, and finally pass that query as an input to 'Dynamic Input In-DB' tool.

[tochoa]

This helped me a lot, thanks very much for posting this way back in 2018.  👍