Who's On?

	Membership:
	Latest: Brady
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5274

	People Online:
	Visitors: 309
	Members: 0
	Total: 309

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

Addins Query no pulling all data

3 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

JonA

Veteran Member Send Private Message

Posts: 1163

5/4/2011 7:33 PM

Trying to query POVAGRMTLN and I'm not getting all the lines for a particular agreement. Even when I specify the VEN-AGRMT-REF in the index the query gives me only 227 lines when I can see 371 in PO25.6. Any ideas why this is happening?

John Henley

Posts: 3351

5/4/2011 8:21 PM

What version of LSF and what version of the addins?

Are the ones not being displayed at the end (i.e. are you seeing first 227?)

Using the addins you can see the underlying DME/Data query. Try running it from the browser with &OUT=CSV and see if it returns all records. =

Ragu Raghavan

Veteran Member Send Private Message

Posts: 477

5/5/2011 12:56 AM

Which Index are you using ? Maybe, you have unintentionally selected an index that has a condition associated with it .

JonA

Veteran Member Send Private Message

Posts: 1163

5/5/2011 11:17 AM

Well this is embarrassing. It works fine. The query wizard was pointed at our test box which hasn't been updated since February. Thanks for your suggestions anyway!