This content has been marked as final. Show 3 replies
What about using dependent value set?
Just have a look over these two statements if it solves your problem1 person found this helpful
one time where clause
Set_Block_Property('BLOCK_NAME',ONETIME_WHERE,your form item);
dynamic where clause
set_block_property('BLOCK_NAME'default_where, your form itme)
you can where clause at run time from any procedure or some triggers
Actually I want to set the where clause in the value set itself, when we edit the information of the value set in front end it allows us to put a where clause over there.
Can the field value be used over there? Or would I have to put it in the backend only.