Advanced search

This Wiki is read-only for reference purposes to avoid broken links.

This enhancement improves the advanced search functionality in Adempiere as follows:

1. Allow to search for null values by using the = or != operator and leaving the Query Value blank
2. Choose whether to join two search conditions with AND or OR
3. Group search conditions using brackets

In the screenshot below the search (on the Table and Column window) is for Active tables which either contain the word Order or the word Invoice in their Name.

.

To Delete a Saved Advanced Search:

1. Choose the saved adv. search you would like to delete
2. Delete all the lines by clicking the recycle bin
3. Once there are no more lines (criteria) visible, click the save button.