• Search Forums
    Advanced Search
Prev
Next
Forums Infor / Lawson Platforms S3 Security

getDBField Syntax

 3 Replies
 1 Subscribed to this topic
 19 Subscribed to this forum
Sort:
Author
Messages
Garry Ferwerda
New Member
Posts: 0
New Member
8/25/2009 6:03 PM
Hi:   Maybe someone can tell what I am doing wrong with this statement written against the GLMASTER table:

user.isMemberOf('RSS-SHOPPING-IT') && trim(getDBField('GLACCMXVAL','MX-VALUE',getDBField('GLCHARTDTL','OBJ-ID',table.CHART_NAME,table.ACCOUNT,table.SUB_ACCOUNT),'RSS-ACCOUNT')) == 'Y'

I am trying to limit access to accounts based on an attribute value.  I have tried numerous combinations of trim, lztrim and no matter what I have tried no acccounts are ever accessible.

Thanks,
John Henley
Posts: 3366
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
8/26/2009 7:43 PM
I do have some examples of how to do this (and I do feel your pain), and will post them next week.
Thanks for using the LawsonGuru.com forums!
John
0
liked by Members
Garry Ferwerda
New Member
Posts: 0
New Member
8/27/2009 5:41 PM
Thanks John. I did figure out what the problem was. I needed to specifiy the index to use when accessing the GLCHARTDTL table. Here is the working version:

user.isMemberOf('RSS-SHOPPING') && trim(getDBField('GLACCMXVAL','MX-VALUE',getDBFieldByIdx('GLCHARTDTL','OBJ-ID','GDTSET2',table.CHART_NAME,table.ACCOUNT,table.SUB_ACCOUNT),'RSS-ACCOUNT'))== 'Y'

I am not trying to understand how the isElementGrpAccessible works.
Garry Ferwerda
New Member
Posts: 0
New Member
8/27/2009 5:42 PM
Typo in previous post.

meant to say I am now trying to understand how the isElementGrpAccessible works.