Prev
Next
Forums User Experience Lawson Design Studio

Max number of keys in Data Query?

 1 Replies
 0 Subscribed to this topic
 12 Subscribed to this forum
Sort:
Author
Messages
Jonathan
Basic Member
Posts: 9
Basic Member
10/27/2011 2:28 PM
    I'm getting this message from a Data Query on a inbasket page: "Number of keys (169) exceeds max (100)."  Is there a way to change the max number of keys allowed in the SELECT portion of the query?  I know you can set the max number of records returned.
    If I can't change the max number, what is the best way to rewrite the query to compensate for the 100 key max?

    Here is the current query:
    /servlet/Router/Data/Erp?PROD=PROD9&FILE=AMASSET&FIELD=TAG-NBR;ASSET;DESCRIPTION;&MAX=200&OUT=XML
    David Williams
    Veteran Member
    Posts: 1127
    Veteran Member
    10/27/2011 6:40 PM
      I didn't realize there was a limit on the number of items you could use in a select criteria statement.
      David Williams