35
hi..
how can i add item name method as a selected field in query
for example i want the name of the item to be add to the query as a field
Share
ReportqueryBuildSource = query1.addDatasource(tableNum(InventTable));
queryBuildSource.addSelectionField(fieldNum(InventTable,ItemId)); 
Queries are used to get data from database. You can't ask SQL server to filter by X++ display method, but they're not defined in database at all and SQL Server knows nothing about their existance. Display method are defined in AX.
What you can do in this case is opening the method, looking at which database objects are used there and then construct a corresponding database query.
#1
André Arnaud de Cal...
294,145
Super User 2025 Season 1
#2
Martin Dráb
232,896
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
All responses (
Answers (
