SQL Sysntax in BODS under where cause

system · March 10, 2020, 2:00pm

I want to restrict the data based on ERSDA date filed and to extract only three months data how can I write the condition in wherecause. Can you please reply. Thank You in advance.

muszia910 (BOB member since 2015-03-15)

system · March 15, 2020, 6:03am

HI,

You can use query transform where clause write your condition.

If you are using SQL transform then then you can copy SQL query in the transform.

Thanks & Regards,
Ramana

Ramana (BOB member since 2009-04-30)