how to filter grid based data in different data source

(0) Share

Report

Posted on by Community Member

Hi brothers,

I'm just confused about this, how to filter the data in grid by in different datasource ranges, i would like to give example

In form using more than one datasources, in one datasource i did set range by date(from_date and to_date), it's good working and i got filtered data in grid super.

Now i want to use another filter, that filter want to do filter the already filtered data by date in grid, but that field not in same table. i did attached the some pic about my question. 3107.form3.PNG

In this form first i will give from_date and to_date so the data filtered in grid it's working properly, than when i select site and warehouse(it's optional) ,again filter the data from grid. how to do this brothers.

I have the same question (0)

All responses (6)

Answers (4)

Verified answer

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

If InventDim is joined with outerJoin then queryRange won't work, try queryFIlter instead. Here is documentation with examples docs.microsoft.com/.../how-to-use-the-queryfilter-class-with-outer-joins

Was this reply helpful? Yes No
Verified answer

Hariharans87 36 on at

Like (0)

Report
Copy link

Link copied!

I guess you already having code for date range filter. So adding site and warehouse filter would be same. Share us your code.

Please refer into this link simple filter example, dynamicsaxhari.blogspot.com/.../filtering-records_15.html

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank for your response brother,

i attached the code in this below, i wrote code in inventjournaltrans (table) executequery for from and to date filter.

Now i again i want filter already filtered record by site and warehouse this fields are here in inventdim (table) this two table already relation with "inventdimid" .

i wrote code inventjournaltrans table executequery for date filter and inventdim table executequery for site and ware house.

-----------------------------------------------code-------------------------------------------------------------------------------------------------------

public void executequery()   //inventjournaltrans(table)        it's working
{
   querybuilddatasource   qbds1,qbds2;

   qbds1   =   this.query().datasourcetable(tablenum(InventJournalTrans));
   qbds1.addRange(fieldNum(InventJournalTrans,Transdate)).value(queryRange
                               (Fromdate.dateValue(),ToDate.dateValue()));

}

public void executequery()   //invedntdim             it's not working
{

   qbds2   =   qbds1.adddatasource(tablenum(Inventdim));
   qbds2.Addlink(fieldnum(InventJournalTrans,inventdimid),fieldNum(invedntdim,inventdimid));
   qbds2.Addrange(fieldname(Inventdim,wmssiteid)).value(strcontrol_name1.value());
   qbds2.Addrange(fieldNum(Inventdim,wmslocationid)).value(strcontrol_name2.value());
}

""i'm not sure fieldname correct, now labtop not here so you just skip validate fieldname(i wrote correct fieldname in my labtop)""

Was this reply helpful? Yes No
Verified answer

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Do you completely ignored my previous post, instead addRange try addQueryFilter when you filter inventdim.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Sorry brother i'm not ignore your post , i will try and also i have another one doubt in a inventable module, how to get unit id by itemid i did try by this code, in this code info get correct matched unit id displayed but form displayed value is wrong like what stored in table order how to display correct item id's unitid, i already try display method

Was this reply helpful? Yes No
Verified answer

Hariharans87 36 on at

Like (0)

Report
Copy link

Link copied!

You have not shared your code fully. Anyway try to call the main datasource execute query method. Try to call InventTable_ds.executequery() or InventJournalTrans_ds.executequery() in the control value change method.

Was this reply helpful? Yes No