Database view need some help in join condition

[srinivasd]

Hi Friends,

I am trying to fetch a report in Order guide and Rule base, below is the db view created, but unable to find proper where clause, can you please help?

og.<?> = rl.guide

[Kalaiarasan Pus]

? can be sys_id

[sneelapu]

Hi Druga Srinivas,

If your question is to use how you can use where clause in joins, here is the full list of javascript operators that support where clause in the joins:       (=, !=, <, <=, >, >=, &&, || ).   Ensure you use the form field left join to extend the capability of your join which may not appear by default (you need to add it from the form list selected fields to available fields).

Thanks & Regards

Srinivasa Reddy Neelapu