Page 1 of 1

Add data filtre by Forms Perso

Posted: Mon Oct 29, 2007 9:21 am
by imad
Hello,

I want to hide some lines in a form based on END-DATE criteria (Only Enabled data have to be displayed in the form).

I tried to do this by forms personalization using a "Property" action on the "Block" with "Property Name" = "DEFAULT_WHERE".
I putted my condition in the value field (nvl(:ASSIGNMENTS.END_DATE,sysdate+1)>sysdate)

The filter did not work. Disabled lines are still there !!

Someone has an idea to make this customization?

Thank you in advance.

Imad - Paris

Posted: Tue Oct 30, 2007 6:43 am
by Kashif
Please post the details.
Which trigger u use.
Which statments u use.....

after that any one able to tell the solution.