• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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