Skip to Content
0
Former Member
Jul 15, 2011 at 11:11 AM

Filter Table data on Query Result

229 Views

Dear All

When I execute the following query (in Query Generator) I got 6411 records. But when I want to filer this table, in the drop down list in 'ITEM' column I found only 500 records (i.e. up to the recods starting with 'K' though there are records starting with 'W' in 'ITEM' field).

I am using SAP B1, PL 14.

Can any one suggest how to get all the records in the drop down list of filter window?

My query is as follows:

SELECT distinct D.ITEMCODE + ' - ' + D.DSCRIPTION 'ITEM',

DATENAME(M,H.DOCDATE) + ' - ' + DATENAME(YYYY,H.DOCDATE) 'MONTH',

D.PRICE

FROM PCH1 D INNER JOIN OPCH H ON H.DOCENTRY= D.DOCENTRY

WHERE H.DOCTYPE='I' AND D.ITEMCODE + ' - ' + D.DSCRIPTION IS NOT NULL

ORDER BY 1, 2

Thnaks & with regards

Aloke

Edited by: ALOKE BANDYOPADHYAY on Jul 15, 2011 4:51 PM