Personalization on custom form
Hello All,
I am using forms 10g on R12 database.
I have a custom form that I want to limit the data returned based on a responsibility and item value. The underlying view for the form identifies the records that need to be excluded in a field called restrict.
It seems that the default_where property would work perfectly but I cannot get it to work.
Goal: I want to prevent only those records where the item value of RESTRICT = 'Yes' from displaying
Here is where I'm at:
Conditions
Trigger Event = When-New-block-instance
Trigger Object = xxprk_shipments_sales_v
Condition = :xxprk_shipments_sales_v.restrict = 'Yes'
I am using forms 10g on R12 database.
I have a custom form that I want to limit the data returned based on a responsibility and item value. The underlying view for the form identifies the records that need to be excluded in a field called restrict.
It seems that the default_where property would work perfectly but I cannot get it to work.
Goal: I want to prevent only those records where the item value of RESTRICT = 'Yes' from displaying
Here is where I'm at:
Conditions
Trigger Event = When-New-block-instance
Trigger Object = xxprk_shipments_sales_v
Condition = :xxprk_shipments_sales_v.restrict = 'Yes'
0