Microsoft Dynamics AX (Archived)

Filtering Form by View Field AX2012

(0) Share

Report

Posted on by lukbel

282

Hi all, running AX2012 R3 CU8.

Follow-up to: https://community.dynamics.com/ax/f/33/t/170411

After filtering by a table field using the following instructions, http://dynamics-ax-live.blogspot.co.uk/2010/03/how-to-filter-records-in-form-by-code.html I was able to get the desired result. However, in a later example I tried to do the same thing with a View field and it didn’t work

Is the code instruction different for this? It specifically falls over when adding the range.

(the example used: CurrencyQBR = this.query().dataSourceName('CustTable').addRange(fieldnum(CustTable,Currency));)

I suspect “fieldNum” needs to be something else.

Thanks in advance for any help :)

*This post is locked for comments

I have the same question (0)

All responses (21)

Answers (1)

jasman 1,413 on at

Like (0)

Report

RE: Filtering Form by View Field AX2012

What is the view you are trying to apply the range on ?

Was this reply helpful? Yes No
5400 7,162 on at

Like (0)

Report

RE: Filtering Form by View Field AX2012

what is your view.. are you adding view in data source. can send some screen shot with requirement.

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

Like (0)

Report

RE: Filtering Form by View Field AX2012

It's done in the same way, including fieldNum().

By the way, I would rewrite the code to this.queryBuildDataSource().addRange(...); hard-coding datasource name is bad because the code stops working if anybody renames the datasource.

Was this reply helpful? Yes No
lukbel 282 on at

Like (0)

Report

RE: Filtering Form by View Field AX2012

Hi all, thanks for your interest

It's basically a separate custom view that I created, which I linked to the SalesLine table through an inner join, and displays information related to that sales line.

This is displayed on the form, which queries mainly the SalesLine table, plus this one field. It displays and filters alongside it in the grid and everything works fine.

I've actually retried it and this time I'm not getting an error, however, when I open the form, the range hasn't been applied. Screenshots to follow:

Was this reply helpful? Yes No
lukbel 282 on at

Like (0)

Report

RE: Filtering Form by View Field AX2012

The data sources used in my form (linked by InnerJoin)

The three methods edited to attempt to add the filter:

The actual form itself (does not attempt to filter)

(for some reason someone decided it was a good idea to return the value as a string not an integer, this is why I phrase queryvalue as '0' and not just 0)

Was this reply helpful? Yes No
lukbel 282 on at

Like (0)

Report

RE: Filtering Form by View Field AX2012

Hi, thanks Martin that's sound advice, I'll do that now - can you see an error in the screenshots provided that would be causing it not to filter?

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

Like (0)

Report

RE: Filtering Form by View Field AX2012

Look at the query used when you get wrong result to understand what's wrong. One option is the Query tab in Personalization form. Another is calling toString() on the root QueryBuildDataSource.

Debugging queries without looking at them is difficult - and unnecessary.

Was this reply helpful? Yes No
lukbel 282 on at

Like (0)

Report

RE: Filtering Form by View Field AX2012

Of course, I forgot that the changes would actually show up regardless

In the Query Used window under Ctrl+F3 the filter range shows up, but the criteria is blank. This happens regardless of what is entered in queryvalue, I tested it with various strings and formats. Have I put my value in the wrong place?

Was this reply helpful? Yes No
5400 7,162 on at

Like (0)

Report

RE: Filtering Form by View Field AX2012

If your range is static why not creating query and add the range in query level after that you can add query into view.

so you have inner relation already in data source level, please create the relation in saleline and check.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: Filtering Form by View Field AX2012

Does the Debugger stop where you add the value to the range? Mind you, if you connect the datasources with inner join it only goes through executeQuery() of the main data source.

Was this reply helpful? Yes No