Can we search multiple objects in one search
Hi,
Is that be possible to search multiple objects in one search.
example I have Objects a, b, c, d, e ….. z, aa, ab…. 100 thousand objects
I want to search for a, c, e, g, h, j, k . Is that be possible in one go.
gykumar,
Can you be a bit more specific. Why not give us the logic you are seeking. Are they are items or documents or parts? What are the specifics that set them apart (is this on page 2 or page 3)?
Are they all the same type of objects (Items, Changes, etc)??
Then yes, easily. In fact, every search assumes that more than 1 object may be returned, and if so, the objects are listed with the identifying number, class/subclass and usually description shown. Use the advanced search to add criteria, such as “number = ‘a’ or number = ‘c’ or number = ‘e’……”. Such a search would then return those objects. Or you could try to look for a common attribute values that those objects possess.
Note that when you do a simple search for an item number, it will return not only that item, but related changes, manufacturers, mfr parts and such. The Advanced search is usually more narrowly focused on one type of object, and it doesn’t show “related” objects either.
I think I understand what you are getting at here, but correct me if I’m wrong.
Basically – you want to run a search based on multiple specific object numbers. Something like – Object Search where Item Number = a; b; c; d; e; g; h; j; k (which doesn’t work, but that is the idea, I think).
As Kevin mentioned – an advanced search with multiple “Number – Equal To” criteria lines would work, but that might get unrealistic in a hurry depending on the number of objects you want to return.
One relatively easy work-around to this would be to list out the items you want returned in Excel and then create a “dummy” change request and add those items as Affected Items. This would give you search criteria unique to only those specific items:
Object Search – Pending Changes.Number = [your CR Number]
The benefit of listing the items in Excel first is that the entire column can be copied and pasted onto the CR (after clicking “Add” on the Affected Items tab) which saves you from having to add each item one-by-one.
Hi,
Yes, you are right on my query. “Basic search not the advanced option” Intention is to reduce the time and search in one go.
Object Search where Item Number = a; b; c; d; e; g; h; j; k (which doesn’t work, but yes this is the idea )
I assume Teamcenter supports ( comma and semi column separater for multiple search in basic search ) this so was just curious if any possibilities in Agile PLM.
Regards
gykumar
Another option that has worked perfectly for me in some environments, but not so well in others is a Basic Custom Search using “Name/Number/Desc” field along with the “Contains Any Word” condition followed by each item number you are looking for (separated by a space).
For example – Lets say I wanted to run a search for 5 specific items – 10001, 10002, 10003, 10004, and 10005
If all of my Item Numbers are 5 characters long – The following search works to return only those 5 items:
Name/Number/Desc – Contains Any Word – 10001 10002 10003 10004 10005
Note – In environments with item numbers of varying lengths – this doesn’t always work as expected because the system treats the “Contains Any Word” condition more like “Contains any word that STARTS with”.
In other words – if I also had items 100011, 100012, 100059 in the same environment, the search would return those items as well since those numbers all start with one of the “words” I used in my search criteria.
It also creates a problem if any of the numbers you enter in the search criteria are included in the Descriptions of other objects.
Needless to say – if your object numbers were actually “a”, “b”, “c”, “d”… as in your example – this wouldn’t work at all as the search would return every item that has any word in its Description that starts with one of those letters.
Hi,
I raised an ENH request 3 years back for this feature, no update from Oracle on this in the last 3 releases.
-Anand