Simple query form reset ranges

(2) Share

Report

Posted on by Jesús García

621

Hi all, I am doing the development of this simple query so that, when entering the SalesLineOpenOrder form it contains those filters. However, this form already has a number of filters predefined, which are maintained even though I add these. Is there any way to reset them at code level from the simple query by doing an override of some method?

All responses (3)

Answers (1)

Sort by

Layan Jwei 8,329 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Jesus,

Do you mean the form has this query as datasource?

Can you please take screenshots and shows us the form?

and show us the code you added if there is any?
Jesús García 621 on at

Like (0)

Report
Copy link

Link copied!

No, it isn't. The SalesLineOpenOrder form use SalesLine like main DataSource and by default it has 3 ranges: SalesType = Subscription (TIPO = SUSCRIPCION) ,SalesType = Sales (TIPO = PEDIDO DE VENTAS)and SalesType = Returned order (TIPO = PEDIDO DEVUELTO). SalesType = Sales it not a problem, cause is the case im going to use like main range, but the others need to be reseted.

I think that i've found a way to do it but i need to try it. I tought to override the init method of Simple Query, get the actual query (the query that the form is using), then call clearRanges method and finally, add the same ranges i did in the image of the first post, but this time by code.
Verified answer

Jesús García 621 on at

Like (0)

Report
Copy link

Link copied!

Hi, I finally took the following solution: the ranges that I used in the simple query I added them in the clicked method of the Tile, so that when entering the form it would add the filters. Previously, I call the clearRanges method to remove the predefined filters from the form. The idea would be like this:

This way, I don't have to use the simple queries and I can add the filters I need to the Tile.