Who's On?

	Membership:
	Latest: Jeffin Joy
	Past 24 Hours: 1
	Prev. 24 Hours: 0
	Overall: 4988

	People Online:
	Visitors: 43
	Members: 0
	Total: 43

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Max number of keys in Data Query?

1 Replies

0 Subscribed to this topic

13 Subscribed to this forum

Sort:

Author

Messages

Jonathan

Basic Member

Posts: 9

New Poster

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

New Poster

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.