Add a view to a query object in X++

(0) Share

Report

Posted on by brianmaric

Hi, I'm trying to filter the Customer Statement based on the Financial Dimension. One simple way is to create a view like tihs:

https://www.axazure.com/en/show-dimensions-in-a-form-without-adding-table-fields

Well, I have this view and I want to use it to filter the records returned on the customer statement.

I'm trying to modify the query in the report classes.

One simple way would be if I could add the view to the query and then filter on it, but this does seem possible as the query.addDataSource() method wants a tableID.

Can anyone help?

Thanks

I have the same question (0)

All responses (19)

Answers (2)

brianmaric on at

Like (0)

Report

RE: Add a view to a query object in X++

hmm...so I only need it for my toString() get the right output but not for the code to correctly apply the filter to the report...but I wonder why Gunjan could see the SQL output without needing to call toString().

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

Like (0)

Report

RE: Add a view to a query object in X++

You need to set it if you want to get the right output from toString() and you have several child tables joined to a single parent (e.g. A<-B and A<-C, but not if you have A<-B<-C).

Was this reply helpful? Yes No
brianmaric on at

Like (0)

Report

RE: Add a view to a query object in X++

That did the trick.

Do we need to set the fetch mode every time there are multiple tables per level or is this just a matter of display?

Thank You!

Was this reply helpful? Yes No
Verified answer

Martin Dráb 235,961 Most Valuable Professional on at

Like (0)

Report

RE: Add a view to a query object in X++

I believe that toString() will display the query string correctly if you set FetchMode of child data source to QueryFetchMode::One2One.

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Add a view to a query object in X++

Let us know if you are able to get it working in the environment. Hopefully that answers your original question regarding adding a view to a query object :)

Was this reply helpful? Yes No
brianmaric on at

Like (0)

Report

RE: Add a view to a query object in X++

The only thing that I know we changed is that we moved all objects from one model into another, I wonder if that had an impact. I think I'll test it in a different environment if I get the same behavior

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Add a view to a query object in X++

The code should work fine I think. Not sure why the query is not showing the correct value in the watch window. Did you try running the report to see if the query ranges set for dimensions had any effect on the data?

Was this reply helpful? Yes No
brianmaric on at

Like (0)

Report

RE: Add a view to a query object in X++

Yeah..same behavior..

Was this reply helpful? Yes No
brianmaric on at

Like (0)

Report
RE: Add a view to a query object in X++

Thanks

I'm trying that now...

Interestingly, what did work in the createBaseCustTransQuery method was this..

DimensionProvider.addAttributeRangeToQuery(q, qbds.name(), identifierStr(DefaultDimension), DimensionComponent::DimensionAttribute, "Value", "AttributeName");

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Add a view to a query object in X++

That's odd.

Could you try the same code in CoC of createCustTransQueryForStatementCust method and see if you see similar behavior?

Was this reply helpful? Yes No