Monday, July 8, 2013

DEFAULT WHERE Forms Personalization

At times custom query has to be executed at run time to limit the data visible to users. It can be achieved  by forms personalization.

In forms personalization

Under the condition tab

Trigger-Event : WHEN-NEW-BLOCK-INSTANCE
Trigger-Object: Block name where condition has to be executed.
Processing Mode: Not in Enter-Query Mode

You can limit personalization to site/resp/user.

Under Actions

Type: Propery
Object Type: Block
Target Object: Block you selected for  Trigger-Object
Property Name: DEFAULT_WHERE
Value: Enter your custom query.
Sample Value: customer_trx_id IN  (select customer_trx_id FROM temp_table WHERE customer_trx_id=:GLOBAL.XX_CUST_TRX_ID).

No need for quotes. Probably you might have to enter a value in double quotes if you have a string value to compare like --> valid_flag = ''Y''