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
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
    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*'