Dynamics Community Forum Thread Details

Grid filtered? It doesn't show any results

Hello,

I am working with PdsApprovedVendorList form, where I see vendor approved items.

The grid is filtered by article, through args.

Well, I'm trying to add another grid to the side, where I want it to show me providers filtered by a field created in the VendTable table, that is, a query independent of the form and args.

If I execute the form from the AOT (it doesn't have an ítem filter) then I see results in my new grid, but if I execute it normally on an item, I never see anything (and the search criteria is correct).

I have done it in the following way:

- I add a new DataSource called VendTable2
- I add the grid with the DataSource property= VendTable2

- DataSource VendTable2 init method

public void init()

{

super();

this.queryBuildDataSource().addRange(fieldNum(VendTable, VendGroup)).value('INT'));

}

If I get query text just after the super in executeQuery(), I see this:

SELECT FIRSTFAST * FROM VendTable(VendTable2) USING INDEX AccountIdx WHERE ((VendGroup='INT'))

but the VendTable2.RecId = 0

Any ideas?