Forum | Message

Wed, January, 12th 2022

1
BC:

Forum Question/Topic:

Article:

Conditional Security Rule Guidance

Categorized as:

Looking for assistance when writing a Conditional Security rule with getDBField or getDBFieldByIdx, have tried both without success.
Security
Looking for assistance when writing a Conditional Security rule with getDBField or getDBFieldByIdx, have tried both without success.
Delivered Read
1
Eric Lopez likes this.
We are trying to write a conditional rule on PO25.6 where changes can only be made if the Agreement Type (PO25.1) equals 'T'. Tried using

getDBFieldByIdx('POVAGRMTHD','AGMT_TYPE','PVHSET5',form.PVN_PROCURE_GROUP,'AGMT_TYPE',form.PVN_VEN_AGRMT_REF) == 'T'
and
trim(getDBField('POVAGRMTHD','AGMT_TYPE',form.PVN_PROCURE_GROUP,form.PVN_VEN_AGRMT_REF)) == 'T'

but neither provides the desired result although the syntax seems correct.
We are trying to write a conditional rule on PO25.6 where changes can only be made if the Agreement Type (PO25.1) equals 'T'. Tried using getDBFieldByIdx('POVAGRMTHD','AGMT_TYPE','PVHSET5',form.PVN_PROCURE_GROUP,'AGMT_TYPE',form.PVN_VEN_AGRMT_REF) == 'T' and trim(getDBField('POVAGRMTHD','AGMT_TYPE',form.PVN_PROCURE_GROUP,form.PVN_VEN_AGRMT_REF)) == 'T' but neither provides the desired result although the syntax seems correct.

Online