NF7.1 Virtual Search Column
Feature: Virtual Search Column
Goal: Technical
Developer: Diego Ruiz
Sponsor : BX Service GmbH
Description:
The goal of the ticket is to allow the configuration of virtual search columns.
To add a virtual search column, the user must define a SQL Column as a regular virtual column but starting with “@SQLFIND=(*QUERY*)”.
For example:
@SQLFIND=(SELECT b.so_creditlimit FROM C_BPartner b WHERE C_Order.c_bpartner_id = b.c_bpartner_id) -> Creates a search column for business partner credit limit
@SQLFIND=(SELECT l.postal
FROM C_BPartner_Location bp
JOIN c_location l ON (bp.c_location_id = l.c_location_id)
WHERE (C_Order.bill_location_id = bp.c_bpartner_location_id)
AND bp.isshipto = 'Y'
AND l.isactive = 'Y'
AND bp.isactive = 'Y'
AND bp.c_location_ID = l.c_location_ID
AND C_Order.C_BPartner_ID = bp.C_BPartner_ID
AND bp.C_BPartner_Location_ID = (SELECT MAX(bp1.C_BPartner_Location_id)
FROM C_BPartner_Location bp1
WHERE bp1.C_BPartner_ID = C_Order.C_BPartner_ID))
-> Creates a search column that allows the user to search by zip code in the orders window
The user must create the Column and the Field as normally (after saving the field, isDisplayed will be set to ‘N’ automatically)
The users will be able to search through that column in simple and advanced searches
See also NF6.2 Virtual UI Column, NF8.2 Override Virtual Column In Field
Technical Info: IDEMPIERE-4087
