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*'
sorry - realized I didn't include all the keys for the 2nd part of the phrase: updated version