Saved Search Not Showing Correct Results

cnewtonne · #1 07-27-2006, 04:35 PM

Hi all,
this is my first post into this forum. I purchased the SW yesterday and since then I've been working to set my DB using the GTD template provided.

My saved search simply does this...
select item_infos from UR where (item_template='TEXT' or item_template='DOCUMENT') and needs_archiving='YES'.

So need_archiving is a new attribute I added to my templates. This query returns 12 hits where it really needs to do only 3. I only have 3 info items where the above where clause is true. The other 7 are either 'DOCUMENT' or "TEXT' but for sure their needs_archiving attribute is set to 'NO'.

What am I or UR is doing wrong? Any ideas?

cnewtonne · #2 07-27-2006, 04:39 PM

to further clarify...
UR shows this in the saved search pane...

template_items equals DOCUMENT
or template_items equals TEXT
and needs_archiving YES

Results are...
Info_item 1 --> document --> needs_archiving = NO
Info_item 2 --> text --> needs_archiving = NO
Info_item 3 --> document --> needs_archiving = NO
Info_item 4 --> document --> needs_archiving = YES
...
...
...

cnewtonne · #3 07-27-2006, 05:05 PM

ignore it. Got figured out. It is all in the indentation. I should've done my homework.