Tuesday, June 27, 2006

Routing Rules

Field = change type which has 3 values (new project, enhancement and bug)

We want to enforce any one of 5 values:
  • Proj Plan
  • Req Spec
  • Biz Justification
  • Int PID
  • Sup PID

So 3 separate rules are set up as follows:

change type field = new project

Sql query is:

select 'Y', 'Y',

'Y', 'Y',

'Y', 'Y',

'Y', 'Y'

'Y', 'Y'

from dual

This populates all of these values into the specific results which are:
Proj Plan
Req Spec
Biz Justification
Int PID
Sup PID

For a different rule, the values will be set to 'N', if not required.

To summarise:

If an end user selects the "change type" field = "new project", then the resulting document fields will all automatically be set to "Y". This result will be used in the workflow at various check steps which route based on value of the radio buttons.

0 Comments:

Post a Comment

<< Home