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?
Thanks in advance.
