Search result unionPosted: November 20, 2012
Many Highrise and WLH users have asked us for a solution for filtering with “OR” logic. For example, when you want to see the “Corp.” OR “Limited” named companies in the same result list. Then you can add tags to them by a single click. We tested many ways, but this isn’t as easy as it looks. Many hidden logical traps and slow queries.
Then we decided to use search result union. This means you can append the new search result to the previous search result and so on – without duplicates.
Filtering “test 6” named contacts by clicking Search button.
Then filtering “test 5” named contacts by clicking Search and union button, the previous and the new search result were merged.
Next, filtering all the “test” named contacts with Search and union button you can see no duplicates. (Test 03 is duplicated, but the one is company and the other is a contact.)
(Specially thanks to Gordon Jackson)