View Single Post
  #6  
Old 10-10-2010, 10:02 PM
ashwken ashwken is offline
Registered User
 
Join Date: 10-16-2005
Location: Blairsville, GA USA
Posts: 431
Quote:
Originally posted by $bill
tfjern, I think I see the database concept that is giving you some trouble in your database design. Seems you have empirically figured this out but maybe this explaination will help you avoid some future frustration.


Code:
Item       Attribute         Value

Item1          TAG          Important
Item2          TAG          Followup
Item3          TAG          Important; Followup
Item4          TAG          Important Followup
Item5          TAG          Important  Followup  (note the 2 spaces)
...Search- UR will parse the Value of TAG into keywords. So a search of "TAG contains keyword Followup" will return items 2,3,4,5.

A search of "TAG contains keyword Important AND TAG contains keyword Followup" will return items 3,4,5.
Thanks, for filling in the blanks.

Exploring the Search function:
if you standardized on the value shown for Item-3, then a search of "TAG equals Important" should only return Item-1.

if you wanted ALL the Items that have the same value as Item-3 (or any compound value), then the EQUALS comparator and the drop-down list should make it easy to search for any compound value.

Last edited by ashwken; 10-11-2010 at 08:41 AM.
Reply With Quote