Friday, May 19, 2006

Ho to use Dual?

If you select anything from dual within a rule, it will automatically return their value to the results eg:
If you want to copy the value of one field with token PROJECT_MANAGER to another field which is an out of the box field eg: KNTA_PROJECT_MANAGER then do the following:
SELECT '[REQ.P.PROJECT_MANAGER]', '[REQ.VP.PROJECT_MANAGER]'from dual
where the results are:[REQ.P.KNTA_PROJECT_MANAGER] and [REQ.VP.KNTA_PROJECT_MANAGER]
The effect will be to take the values of [REQ.P.PROJECT_MANAGER], [REQ.VP.PROJECT_MANAGER] and enter them into the values in the results fields.
Finally, you can choose to not display KNTA_PROJECT_MANAGER, however the field will contain a value if you need to enable it as some point in the future.

0 Comments:

Post a Comment

<< Home