Select Date Range in Analytic App and filter using the In-DB tool

[dcsramya]

I am using then analytic app that allows the user to select a date range and would want to filter that out using the in-db tool. Snapshot of my workflow is attached and i am not sure if i am doing anything wrong as i don't see any output after the selection process. 

I want to use the in-db filter tool as i am trying to pull directly from the database and the data goes back until 2017 to current. I even tried to use the filter tool after the data stream out to specify my date range; but when i run the workflow it throws an error saying Internal error-Deadlock detected. So that'z why trying to filter my date range using in-db tool and not the regular filter 

[alexnajm]

What are your Action tools doing? I don't see any placeholder values in your Filter In-DB for the interface tools to replace - you typically set up your workflow to work first, then you can have the action tools replace the placeholder values that you have. If there is nothing to replace though, where are the interface values going?

Debugging is useful here too: Debug Workflow

[dcsramya]

My IN-DB filter tool has the below condition DATE(LGDATE) BETWEEN '[#1]' AND '[#2]'

[dcsramya]

My In-DB filter tool has the below condition mentioned DATE(LGDATE) BETWEEN '[#1]' AND '[#2]' for the selection criteria 

[alexnajm]

Now it does 😊 the original screenshot did not have this!

Look at your "Replace a specific string" - you are saying to replace something that doesn't exist anymore in the Filter In-DB tool!

Using #1 and #2 apply if you aren't using that Action tool (for example, when using a normal Filter tool you can connect without the Action tool). put in placeholder dates in your Filter in-db, and replace those strings with your action tools

[dcsramya]

Alex - I tried replacing the string with the actual dates., but when selecting the range i don't get any output data. The workflow runs without any error. 

Action tool [#2] replace a specific string has "LGDATE" >= '20250201' and Action tool [#3]  replace a specific string has  "LGDATE" <= '20250305' 

[alexnajm]

the Date tool produces actual dates - the way you have formatted your "dates" are not dates. You have it as YYYYmmdd whereas the Date tool produces YYYY-mm-dd

Also why are you replacing the LGDATE" >= part of the string? You are only trying to replace the date value - get it in the right format for your data using the Update Value with Formula

This is enough information to get it working - if you need more help, you can provide the actual app. good luck!