SQL Sysntax in BODS under where cause

dataservices job design
1

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)

2

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 :india: (BOB member since 2009-04-30)