Filter grid-Queryrange

(0) Share

Report

Posted on by NDingankar22

515

Hi,

I have a form with grid example-InventSerial in AX 2012- It iis customized.

The invent serial has customized field as Status-values are registered, available,scrap,not avaible,machine deployed etc

The user wanted me to filter the invent serial form where he should see all the values except Status -------Registered

So I went to execute query and wrote a range --

inventserial_ds.query().dataSourceTable(tablenum(InventSerial)).addRange(fieldnum(InventSerial, Status1cust)).value(strfmt('!%1', Status1cust::registered));

My query is filtered but it shows as below(image attaced)

Since I dont want user to change the filter, i applied Statusrange=Locked & hidden. As a result the field on form is not available for fileteration(it is greyed out and cant filter)

but the user want the field to be filter to be filterable.

Is there a trick or workaround where I can filter the form with status (!=registered) but also make that field fileterable

There can be some workaround to achieve this

please help

I have the same question (0)

All responses (8)

Answers (1)

Sort by

André Arnaud de Cal... 305,797 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi NDingankar22,

You can create a view where you exclude the registered status. Then use this view as data source on the form. In that case, the filtering on the status field will be available.

Was this reply helpful? Yes No
Suggested answer

Pedro Tornich 955 on at

Like (0)

Report
Copy link

Link copied!
Hi,

In AX2012 after hiding or locking the range the user can no longer edit it, but there is a workaround in the query level to solve this.

You can use a query range expression to bypass the range status behavior.

Here is a sample code used on the CustInvoiceJournal form to hide a specific sales order, but still allowing the user to filter on the sales order field:

range = CustInvoiceJour_ds.queryBuildDataSource().addRange(fieldNum(CustInvoiceJour, DataAreaId)); range.value(strFmt('(%1.%2 != "000002")', tableStr(CustInvoiceJour), fieldStr(CustInvoiceJour, SalesId))); range.status(RangeStatus::Locked);

You can find more information on query range expressions in the following link:

http://www.axaptapedia.com/Expressions_in_query_ranges

Was this reply helpful? Yes No
NDingankar22 515 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thank you for the reply

I couildnt filter with above code of dataareaid-I m writing it in execute query method before super

May you highlight more please?

thank you

Was this reply helpful? Yes No
Suggested answer

Pedro Tornich 955 on at

Like (0)

Report
Copy link

Link copied!

Try placing your code at the end of the form init() method.

Was this reply helpful? Yes No
NDingankar22 515 on at

Like (0)

Report
Copy link

Link copied!

I tried but no luck. The form is based on InventSerial datasource

So, putting the below code in init SHOWS the registered value on form

range = inventserial_ds.queryBuildDataSource().addRange(fieldNum(InventSerial, DataAreaId));

range.value(strFmt('(%1.%2 != "Registered")',tableStr(InventSerial),fieldStr(InventSerial, SerialItemStatus)));

range.status(RangeStatus::Locked);

Am i doing anything wrong here? Please suggest

Was this reply helpful? Yes No
Verified answer

Pedro Tornich 955 on at

Like (0)

Report
Copy link

Link copied!

Your range value is wrong.

Since the field you are trying to add the range to is a BaseEnum you need to compare it to an integer value (without quotes), like the following:

range.value(strFmt('(%1.%2 != %3)', tableStr(InventSerial), fieldStr(InventSerial, SerialItemStatus), enum2int(SerialItemStatus::Registered));

There is a complete example about filtering by enum fields on the link I shared before.

Was this reply helpful? Yes No
NDingankar22 515 on at

Like (0)

Report
Copy link

Link copied!

Hey Pedro

thank you so much for your assistance

yes it works..thanks again for your help

Was this reply helpful? Yes No
Pedro Tornich 955 on at

Like (0)

Report
Copy link

Link copied!

I'm glad it worked :)

If you don't have any more questions about this, please mark the answer as verified, to help other members in the community.

Was this reply helpful? Yes No