Advanced Search and Site information
Hi, all
I´m having a weird situation when using Advanced Search to search for items pertaining (or not) to more than one site.
The scenario is: I have Site 1 to Site 6 defined on an Agile 9.3.3 installation.
So I want to be able to find Items not related to Sites 1 or 2. When I use, on Advanced Search:
Item – Item sublclass – Object Search
Site Name – Not In – Site 1+Site 2 (both site names on the single Value box) AND
Site Name – Is not Null
It will show that one of the Items is related to both Sites
If I use, on Advanced Search:
Item – Item Subclass – Object Search
(Site Name – Not in – Site 1 AND or OR – Behavior is the same
Site Name – Not in – Site 2 ) AND
Site Name – Is not Null.
I have the same result as above.
What I really want is to be able to find Items related to any combination of Sites, but it seems that the operator Not In is not working as expected – or I´m doing something wrong.
Thanks in advance for any comments and help on this.
Best regards,
Clovis Chenaud Jr.
Clovis,
Try this
Object search
site name not it site 1 and
site name not in site 2
do you allow items to be in multiple sites?
Clóvis, I reproduced your issue on a 9.3.5 version environment.
It seems that is nor working as required, I suggest you raise a SR.
I went a little bit further in tests over here and I realized that if the item is related to only one site, the “not in” search works fine, but if the item is related to more than one, it doesn’t work as required.
My best
Carlos
The search isn’t working as you would expect because when you search for data that is within a table – the criteria is checked for each individual ROW of data in the table rather than matching the criteria for the entire table.
Example –
Lets say ItemABC is assigned to Site 1 AND Site 2.
If I execute Item Object search with the following criteria:
‘Site Name – Not In – Site 1’ AND
‘Site Name – Is Not Null’
ItemABC is returned.
This is because the criteria was matched for the Site 2 ROW of ItemABC. The site name isn’t null (it’s ‘Site 2’) AND it isn’t ‘Site 1’ (it’s ‘Site 2’).
There is a system-wide “Search Based On” preference in Server Settings > Preferences that can be changed to TABLE. This allows the AND operator to work the way you are expecting for searching Table data. This preference only applies to specific tables and I’m not sure if the Item.Sites table is included or not. It might be worth a try.
Hi Danny,
Sorry for the delay responding you, I´ve been away from the customer site since Nov 3rd.
I really appreciated your suggestion on the “Search Based On” preference. Looking at the documentation, it states that the Item.Sites table is NOT included, however, by changing the value to Table, it really seems that the Search is performing the way I was expecting (after a quick test)!!
Now I´m trying to figure out which would be the drawback of leaving this setting in Table mode instead of turning it back to Row mode… Will it disrupt non-Table-related Searches??
Anyway, thanks so much for your information, really very much appreciated!!
Best regards,
Clovis Chenaud Jr.