topic Passing variable in SQL query while extracting data in App Development

Passing variable in SQL query while extracting data

bsharma_velcro — Wed, 30 Oct 2024 12:43:22 GMT

Hi,

I am using an SQL query to fetch previous day's data from an Oracle database. This query gives me data for just previous day. I need last 45 days worth of data on a daily basis.

Is there a way I can pass a variable for the highlighted section of the query snippet below so that I can run a loop and extract data for all the past 45 days... something like sysdate - $(vDateCount) in place of the highlighted section.

Regards,

Bhaskar

Re: Passing variable in SQL query while extracting data

Or — Wed, 30 Oct 2024 12:56:46 GMT

Sure.

https://community.qlik.com/t5/QlikView-App-Dev/Load-data-day-by-day-using-loop/td-p/1799763

Plenty of other threads about similar requirements, so a search should help you if that one isn't precisely what you want.

Re: Passing variable in SQL query while extracting data

bsharma_velcro — Wed, 30 Oct 2024 15:12:11 GMT

My variable doesn't go in the where clause, but in the body of the query and subqueries within, where my variable declared in Qlik are not identified.

Regards,

Bhaskar

Re: Passing variable in SQL query while extracting data

Or — Wed, 30 Oct 2024 16:21:59 GMT

What makes you say that they are not identified.,?

Re: Passing variable in SQL query while extracting data

bsharma_velcro — Wed, 30 Oct 2024 17:04:11 GMT

Because it's throwing error.

Re: Passing variable in SQL query while extracting data

Or — Wed, 30 Oct 2024 20:04:00 GMT

Sounds like you have a syntax issue, then. You may want to share your actual code...

Re: Passing variable in SQL query while extracting data

bsharma_velcro — Thu, 14 Nov 2024 06:49:48 GMT

You are right. I had syntax and date format issue. It's working fine now.

Regards,

Bhaskar