Force AOT Query range criteria of one field to bring records in accord with another range criteria

(1) Share

Report

Posted on by Mohamed Fares BEN M...

Hello everyone,

I wanted to query ProdTable while setting the range value of ProdStatus on an aot query I created to the value released, when I click on filter to select records the prodId I get records that belong to all the status and not just to ProdStatus::Released

[
    DataMemberAttribute,
    AifQueryTypeAttribute('_packedQuery', querystr(PordTableQuery)),
    SysOperationDisplayOrderAttribute('1')
]
public str parmQuery(str _packedQuery = packedQuery)
{
    packedQuery = _packedQuery;
    return packedQuery;
}

Is this even possible to lookup on the criteria column depending on Status?

Thanks in advance.

Categories:

Microsoft Dynamics AX

I have the same question (0)

All responses (7)

Answers (1)

Bharani Preetham Pe... 3,634 Moderator on at

Like (1)

Report

As far I know, it doesn't work that way. The range works on when the query is running. Not on the criteria column.

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

This is a generic purpose´form for filtering any data in any table; it knows nothing about your particular scenario. You could extend the form, but it's not obvious how you'd identify that it's your specific case.

Unfortunately, you didn't mention the business scenario, but the method you've shared shows that you're using a data contract class. Then a better solution may be using data members for the status and the order number and override the lookup of the latter.

Was this reply helpful? Yes No
Mohamed Fares BEN M... 65 on at

Like (0)

Report

Thank you Martin and Bharani for your insights.

Martin I thought of the same thing but the user wants the dynamics query filtering and also lookup to ease his work by filtering ProdId with the status picked in the filter to fill up a temporary table with the ProdIds Raw materials.
Is it possible to do both like in the screenshot below:

The Production Id lookup bring the ProdIds with the range predefined in the AOT query, I tried to change the status (or do other filters) in the Records to include segment but it doesn't affect the production Id lookup, is it possible to make the Production Id lookup bring dynamically data using the same query filters set below in Records to include segment?

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

Like (1)

Report

Yes, you could use the query in the lookup.

Was this reply helpful? Yes No
Mohamed Fares BEN M... 65 on at

Like (0)

Report

Thank you Martin for the promt reply.

I declared the lookup in the uibuilder class using the predefined Aot query.

I tried to change the query in that form but it doesn't affect the lookup.

Can you give me a code snippet on how to make that lookup filter dynamically according to the values of the query set in the "Records to include segment" ?

Thank you again for your guidance.

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

Like (1)

Report

It will help if you tell us more about what you already know and what you need from us. Just saying that you tried unknown code change and it didn't work isn't sufficient.

If you tried to use the query in the lookup, it must mean that you already know (or believe so) how to get the query. But do you really have the right query? You see that you have no idea what's wrong if you don't test components of your solution, therefore let's change the approach.

You need to check whether the query is correct, e.g. by looking at the variable in debugger. If it's correct, you know that this part of your code works and the problem is how you're using the query in the lookup. If it's wrong, there is no point in using this query in the lookup; you already know that it can't work. You'll need to review/debug your code for getting the query. You may also find that your code isn't called at all, therefore you need to fix that before you can even start testing.

Was this reply helpful? Yes No
Verified answer

Mohamed Fares BEN M... 65 on at

Like (0)

Report

It was like you said Martin, that I am working with the same AOT query but with different instances.

I used get query method from the contract class as my query in the uibuilder and it solved my problem.

Thank you again for your help.

PS: for some reason when I check "does this answer your question" for your answer it doesn't save it, maybe a mod can intervene and check your answer.

Was this reply helpful? Yes No