# EP LookUps

**URL:** <https://www.dynamicsuser.net/t/ep-lookups/40487>\
**Category:** User Forum\
**Created:** [September 26, 2012, 10:28am UTC](https://www.dynamicsuser.net/t/ep-lookups/40487 "2012-09-26T10:28:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![abhisekjani](https://avatars.discourse-cdn.com/v4/letter/a/fbc32d/32.png) [@abhisekjani](https://www.dynamicsuser.net/u/abhisekjani)\
**Post date:** [September 26, 2012, 10:28am UTC](https://www.dynamicsuser.net/t/ep-lookups/40487/1 "2012-09-26T10:28:25Z")

</div>

Hi,

In lookup where to give condition or where write to write query

act i want to show a lookup from one table but it shows all the record,i want that some specific record should only show

means basing on some condition record should come,so for that where r how to write query

Proxy.SysDataSetBuilder sysdatasetbuilder = Proxy.SysDataSetBuilder.constructLookupDataSet(this.AxSession.AxaptaAdapter, TableMetadata.TableNum(this.AxSession, “InventTable”));

lookup.LookupDataSet = new DataSet(this.AxSession, sysdatasetbuilder.toDataSet());

its shows all the record but i want give certain condition so how to write

plz help

---

<div class="post-metadata">

**Author:** ![suvarna\_kumar](https://avatars.discourse-cdn.com/v4/letter/s/82dd89/32.png) [@suvarna\_kumar](https://www.dynamicsuser.net/u/suvarna_kumar)\
**Post date:** [August 23, 2013, 1:24pm UTC](https://www.dynamicsuser.net/t/ep-lookups/40487/2 "2013-08-23T13:24:19Z")

</div>

Please check with below code.

Proxy.SysDataSetBuilder sysdatasetbuilder = Proxy.SysDataSetBuilder.constructLookupDataSet(this.AxSession.AxaptaAdapter, TableMetadata.TableNum(this.AxSession, “InventTable”));

lookup.LookupDataSet = new DataSet(this.AxSession, sysdatasetbuilder.toDataSet());

lookup.LookupDataSet.Init();

Proxy.Query query = lookup.LookupDataSet.DataSetViews[0].MasterDataSource.query())  
Proxy.QueryBuildDataSource dataSource = query.dataSourceName(“InventTable”))

Proxy.QueryBuildRange range = dataSource.addRange(“Field id to filter”))

range.status = (int)Proxy.RangeStatus.Open;  
range.value = Convert.ToString(“value for filter”);

Hope this will help.