In-Database filter Macro

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

macroIn_DB.jpg

Tips and Tricks

Macros

Date Time

Preparation

Interface Tools

Accepted answers

ddiesel

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.

All comments

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.

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?

workflow_dates_filter.jpg

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703