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

Addins Query no pulling all data

3 Replies

0 Subscribed to this topic

2 Subscribed to this forum

Sort:

Author

Messages

JonA

Veteran Member

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: 3366

New Poster

Engaged Reader

Avid Reader

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

Posts: 477

New Poster

Engaged Poster

Avid Poster

Engaged Reader

Avid Reader

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

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!