Dynamic View as Search Record

Hi All,

We have a requirement where we need to use a dynamic view as the search record. The view SQL is a set of unions of three select statements.

At the runtime the system puts brackets at the start of WHERE of first select and at the end of the whole SQL -- therefore failing the SQL due to mismatch of parentheses.

Is there any workaround?

The reason of using a dynamic view is to filter returned dataset based on security roles of the users.

Thanks,

Nabarun