Rule that refers to DT0 area of a form

 1 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Carla Branda
Basic Member Send Private Message
Posts: 8
Basic Member

I have a ticket open with Infor.

I am finding it is not documented anywhere how to view the data loaded into the DT0 area of a form

I still don't know how I get to the row of data in the DT0 or ACGLACCT table after hours of research and reading.


Our situation:

User goes to AC07
User enters the Activity number only
User hits Inquire

I am trying to secure on the BEG-VAL where ACCT-FIELD = '1-company' or "1*"

Rule:
If the BEG-VAL is in the user's company control list, they can view the Activity via AC07


The keys for ACGLACCT are Activity Group, Activity, Acct Category and Sequence.....what is Sequence?

I put in 1 since I need the data from the first row of the DTO, but I don't know what Sequence is or how to look at it to know what to put in the getdbfield


Here's one of the many iterations I have tried:

user.attributeContains(lztrim('CompanyControl'),getDBField('ACGLACCT',lztrim('BEG-VAL'),trim(form.AGA_ACTIVITY_GRP),trim(form.AGA_ACTIVITY),trim(form.AGA_ACCT_CATEGORY),1))
&&
getDBField('ACGLACCT',lztrim('ACCT-FIELD'),trim(form.AGA_ACTIVITY))=='1*'


Carla Branda
Basic Member Send Private Message
Posts: 8
Basic Member

sorry - realized I didn't include all the keys for the 2nd part of the phrase: updated version

user.attributeContains(lztrim('CompanyControl'),getDBField('ACGLACCT',lztrim('BEG-VAL'),trim(form.AGA_ACTIVITY_GRP),trim(form.AGA_ACTIVITY),trim(form.AGA_ACCT_CATEGORY),1))
&&
getDBField('ACGLACCT',lztrim('ACCT-FIELD'),trim(form.AGA_ACTIVITY_GRP),trim(form.AGA_ACTIVITY),trim(form.AGA_ACCT_CATEGORY),1)=='1*'