I am working a bug and during project creation if the user selects a Large Sto

sudhirp804 over 10 years ago

I am working a bug and during project creation if the user selects a Large Store, Convenience Retail or Drug Value originating channel the selection of project subtype should be an optional (not required) selection. The dropdown selection should not be removed.

Could anyone let me know what could be the logic which I should use so that" Project Subtype"should be optional for Large Store, Convenience Retail or Drug Value originating channel . We are using expression rule "prmOrigChanHasProjectSubType"

=if(contains({cons!PRM_ORIG_CHAN_REGION, cons!PRM_ORIG_CHAN_STORE_LG, cons!PRM_ORIG_CHAN_CONV_RETAIL, cons!PRM_ORIG_CHAN_DRUG_VALUE, cons!PRM_ORIG_CHAN_CANADA, cons!PRM_ORIG_CHAN_OTHER}, ri!origChannel), true(), false())

Also , we have used this expression rule to List of originating channel subtypes for Large Store.

={null(), cons!PRM_ORIG_CHAN_TYPE_REG_CPI, cons!PRM_ORIG_CHAN_TYPE_REG_NONCPI}

Please note the attached screenshot.....

Discussion posts and replies are publicly visible

Parents

0 sudhirp804 over 10 years ago

I have tried the choose function in the expression rule "prmListOrigChanSubTypeByOrigChan" but it is geting an error "expression evaluation error at function 'choose'; Choose index cannot be null"

choose (ri!origChannel, cons!PRM_ORIG_CHAN_REGION, rule!prmListOrigChanSubTypeRegion(),
cons!PRM_ORIG_CHAN_STORE_LG, rule!prmListOrigChanSubTypeStoreLG(),
cons!PRM_ORIG_CHAN_CONV_RETAIL, rule!prmListOrigChanSubTypeConvRetail(),
cons!PRM_ORIG_CHAN_DRUG_VALUE, rule!prmListOrigChanSubTypeDrugValue(),
cons!PRM_ORIG_CHAN_CANADA, rule!prmListOrigChanSubTypeCanada(),
origChannel=cons!PRM_ORIG_CHAN_OTHER, rule!prmListOrigChanSubTypeOther(), ri!origChannelSubTypes)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sudhirp804 over 10 years ago

I have tried the choose function in the expression rule "prmListOrigChanSubTypeByOrigChan" but it is geting an error "expression evaluation error at function 'choose'; Choose index cannot be null"

choose (ri!origChannel, cons!PRM_ORIG_CHAN_REGION, rule!prmListOrigChanSubTypeRegion(),
cons!PRM_ORIG_CHAN_STORE_LG, rule!prmListOrigChanSubTypeStoreLG(),
cons!PRM_ORIG_CHAN_CONV_RETAIL, rule!prmListOrigChanSubTypeConvRetail(),
cons!PRM_ORIG_CHAN_DRUG_VALUE, rule!prmListOrigChanSubTypeDrugValue(),
cons!PRM_ORIG_CHAN_CANADA, rule!prmListOrigChanSubTypeCanada(),
origChannel=cons!PRM_ORIG_CHAN_OTHER, rule!prmListOrigChanSubTypeOther(), ri!origChannelSubTypes)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data