Finance | Project Operations, Human Resources, ...

Search Item Looup By Item Name

(0) Share

Report

Posted on by Community Member

Hi All,

In standard the item lookup , filter the records based on item id.

But i need to change it.

When the user search by Product Name it should be filtered in the item lookup.

How to achieve this.

Thanks.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

huijij 19,811 on at

Like (0)

Report

Hi john,

Do you need to search both the id and the name in the lookup?

Or If just filter based on name, you can create lookup in D365FO using X++ following the link:

community.dynamics.com/.../how-to-create-lookup-in-d365fo-using-x-2133197305

regards

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Judy,

Thanks for the reply.

I need to filter the records based on product name in the ItemLookup.

User enter product name the lookup should be filtered.

Was this reply helpful? Yes No
huijij 19,811 on at

Like (0)

Report

Hi john,

You field is item id and not Item Name, if you need Item Name, you can also change the item id to Item Name field to display.

Best regards

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Judy,

The grid should contain the item id only.

Itemid field has this lookup control.

User can't remember all itemid.

So its better if the user enter product name in the grid, and the itemid lookup filter records based on the value entered by the user and return itemid in the grid.

Was this reply helpful? Yes No
Suggested answer

ergun sahin 8,826 Moderator on at

Like (0)

Report

You can create a lookup and use the value as a range. (SysQuery::ValueLike)

Was this reply helpful? Yes No
Suggested answer

huijij 19,811 on at

Like (0)

Report
Hi john,

You can check the lookup method of the itemid field in your datasource of the form to modify lookup filter like this in your method:

queryBuildDataSourceInventTable.addRange(fieldNum(InventTable, ItemName)).value(strFmt(#ItemName,_filterStr));

Just refer to the method lookupItemsFromSourceId() of class named Catalog:

regards

Was this reply helpful? Yes No