Microsoft Dynamics AX (Archived)

AOT Query and View for store Name

(0) Share

Report

Posted on by rohit1900

439

Hi All,

I have a lookup which is coming from EDT and I want to filter That value in the lookup.

I have added a stringEDIT field and added a EDT as RetailStoreId

I want to filter the data based on the enum value

I have override the lookup method and wrote this code:

lookup.txt

Any Idea can we filter the value of EDT some how???

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report

You can use addRange() method to add a filter to your query. Like this:

qbds.addRange(fieldNum(SON_RetailNotOpen, MyField)).value(queryValue(MyEnum::MyEnumValue));

Was this reply helpful? Yes No
rohit1900 439 on at

Like (0)

Report

Hi Martin thanks for the reply, I believe my Question heading and question description was misleading. I was able to apply range on the query but thre is a problem I was not able to bring the store name in the Query.

Was this reply helpful? Yes No
rohit1900 439 on at

Like (0)

Report

Here I have created a query to get the storeName

and then I have created a view from the query in order to fetch the StoreName but it is giving the error

Was this reply helpful? Yes No
Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report

Yes, your question "Any Idea can we filter the value of EDT some how?" was indeed misleading, if your actual problem is something else.

The compilation error says: "For views relation fields in query can not come from base or derived tables". I see your relation is between OMOperatingUnitID field and DirPartyTable - shouldn't you use OMOperatingUnit table instead of DirPartyTable?

Was this reply helpful? Yes No
rohit1900 439 on at

Like (0)

Report

I tried with that also it gave the same error and then I switch to dirpartyTable .

Was this reply helpful? Yes No
Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report

Both cases compile correctly in my AX7 environment (I don't have any AX2012 on hand).

Don't you have any additional datasources in your view?

Can you show us a screenshot with properties of your relation?

Was this reply helpful? Yes No
rohit1900 439 on at

Like (0)

Report

above mentioned screenshot

Was this reply helpful? Yes No
rohit1900 439 on at

Like (0)

Report

2425.lookup.txt

Issue is resolved I have used sysTableLookup.addLookupMethod(tableMethodStr(RAXRetailStoreStatusTable, storeName));

Thank you for the help.

Was this reply helpful? Yes No
Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report

I think you again forgot to tell you a few things. A lookup method surely couldn't fix the compilation error in your view, so I guess you gave up the view and solve the business requirement (which you never explained to us, so we couldn't help with it) in a different way. Am I right?

It would help if you start by explaining your actual requirement, instead of just showing a piece of code of your various attempts to solve it.

Was this reply helpful? Yes No
rohit1900 439 on at

Like (0)

Report

Yes the error in the view and the new query are no way related and due to time constraint i gave up the view approach and still wondering what could have done to make view works as it was throwing the error message in the screenshot.

Was this reply helpful? Yes No