Advanced Search - Allow select column from window tabs

Description

problem: window advanced search doesn't allow select other then main tab.
solution: new column Table where user can select available tables from actual window (e.g Sales Order has c_order and c_orderline etc.

Use Case
1. user open sales order
2. click to search icon>navigate to advanced
3. select Order Line eg. product field => enter product

Other improvements:
1. 2 new operator types: AND Not, Or Not
2. allow search in attribute set instances - eg. color red (select all sales order lines where product is read in attributes)

Environment

None

Activity

Show:
Heng Sin Low
August 7, 2020, 1:42 AM
Carlos Ruiz
August 7, 2020, 9:21 AM

This is about point h) on the list:

I guess tablename doesn’t work probably because the query for detail tab needs to combine with the where clause from the specific detail tab.

I didn't see that in the code, and probably is not necessary, the query from a children tab looks like:

for example a query in order with a product:
bring the orders where ..... conditions on order tab
and exists (select orderline where product ... conditions on orderline tab)

I'm not sure if is necessary to filter the exists query - can it disclose private information? like finding relationships that we don't want the user to know?
IMHO doesn't sound like a big deal.

So, if the query is just using the tablename+columnname there is no need to save the tab id, even if there are multiple children tabs with same table.

But, if you need to add the condition of the children tab (which I think is not in core at this moment) - then tab_uu would be preferable.

Heng Sin Low
September 21, 2020, 6:44 AM

I notice this is stall for sometime and the pull request is close. It would be a shame if this is not part of the next release as it is one of the most frequently request feature.

Norbert Bede
September 21, 2020, 6:54 AM

agree. I will create today tickets as suggested, then we split code and make PR.

norbert

Norbert Bede
September 22, 2020, 7:05 PM

Dear

according to @carlosruiz suggestion from matter most chat - xref: https://mattermost.idempiere.org/idempiere/pl/6etg4kpkz7fz7j9p86xibdaj9e I split this issue/PR to 3 new features targeting release 8.0

feel free to clarify I catch the decision and suggestions properly, then we start to convert declined PR with considering new scope.

This ticket was started meanwhile, conflict can be would be better to resolve it first if possible

Norbert



Assignee

Norbert Bede

Reporter

Norbert Bede

Labels

Tested By

None

Priority

Major
Configure