Saved Search Not Showing Correct Results

[cnewtonne]

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?