Add search criteria and SQL statements to search dialogs and/or result lists (similar to task lists)
Some of our clients have changed their company names over time.
When this happens, a new CustomerNumber is given in our database to them. It is required very often to search all the documents from one customer, including those indexed with the previous names (linked now by the Original Customer Number only).
Users should find all of the required documents by typing the current or any Company name the customer has had.
This could be done by doing 2 things:
1. adding somewhere the SQL statements capability and
2. allowing those statements to take the values from the search dialog fields.
i.e.
WHERE clause
ORIGINALCUSTOMERNUMBER IN
(SELECT DISTINCT ORIGINALCUSTOMERNUMBER
FROM myfilecabinet
WHERE CUSTOMERNAME LIKE "CUSTOMERNAMESEARCHDIALOG_FIELD");
Thanks in advance
David Mendoza
shared this idea
Vielen Dank für Ihre Idee. Im Augenblick konzentrieren wir uns auf andere Themen, deshalb planen wir diese Idee nicht für zukünftige Veröffentlichungen. Wenn die Nachfrage nach diesem Thema steigt, werden wir diese Idee eventuell wieder aufgreifen.