# SearchFunctions List Lookup does not return UD fields on UDTable?

**URL:** <https://www.epiusers.help/t/searchfunctions-list-lookup-does-not-return-ud-fields-on-udtable/44122>\
**Category:** Epicor ERP 10\
**Created:** [April 19, 2018, 9:27pm UTC](https://www.epiusers.help/t/searchfunctions-list-lookup-does-not-return-ud-fields-on-udtable/44122 "2018-04-19T21:27:47Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![hkeric.wci](https://www.epiusers.help/user_avatar/www.epiusers.help/hkeric.wci/32/52019_2.png) [@hkeric.wci](https://www.epiusers.help/u/hkeric.wci)\
**Post date:** [April 22, 2018, 2:30pm UTC](https://www.epiusers.help/t/searchfunctions-list-lookup-does-not-return-ud-fields-on-udtable/44122/4 "2018-04-22T14:30:19Z")

</div>

In a Nutshell,

**In Epicor 9:**  
`System.Data.DataSet dsPartRevSearchAdapter = Ice.UI.FormFunctions.SearchFunctions.listLookup(this.oTrans, "PartRevSearchAdapter", out recSelected, false, whereClause);`

**In Epicor 10:**  
listLookup only gets the “core columns” it no longer gets the UD Columns by design.

So you have a few options… I use the **BOReader** instead of listLookup when doing simple reads… but there is also a catch.

GetList: WORKS! - BRINGS IN THE PART REV INFO WITH MY UD FIELDS POPULATED!  
`System.Data.DataSet dsPartRevSearchAdapter = _bor.GetList("Erp:BO:PartRevSearch", whereClause, "PartNum, RevisionNum, Character10, CheckBox02, CheckBox03, CheckBox04, Date01, Date02");`

GetList: DOES NOT WORK - BRINGS IN THE PART REV INFO BUT MY UD FIELDS REMAIN BLANK  
`System.Data.DataSet dsPartRevSearchAdapter = _bor.GetList("Erp:BO:PartRevSearch", whereClause, "");`

GetRows: Works gets my UD Fields etc…  
`System.Data.DataSet dsPartRevSearchAdapter = _bor.GetRows("Erp:BO:PartRevSearch", whereClause, "Character10, CheckBox02, CheckBox03, CheckBox04, Date01, Date02");`

When using the **BOReader.GetList** you “must” specify the columns you want. When doing **BOReader.GetRows** you can leave the columns “” and get all.

You are probably going to end up using either the AD/BO GetRows or CreateRuntimeSearch:

```
SearchOptions searchOptions = SearchOptions.CreateRuntimeSearch(whereClauses, DataSetMode.RowsDataSet);
adapterUD05.InvokeSearch(searchOptions);

```

**3 Examples:**

 ![Examples_3](https://epiusers.help/uploads/default/original/2X/9/9caaac400a73b8fab38f1ed2bd0408a640e881c8.jpg)

BOReader Gotchas!

 ![GetListGotchaMUSTSpecifyColumns](https://epiusers.help/uploads/default/original/2X/e/e260c58057b4bfa6ec3bfb74a98c572f974a0674.png)

---

_[View the full topic](https://www.epiusers.help/t/searchfunctions-list-lookup-does-not-return-ud-fields-on-udtable/44122)._