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.

Add Comment
6 Answer(s)

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)?

Agile Angel Answered on May 10, 2017.
Add Comment

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.

Agile Angel Answered on May 10, 2017.
Add Comment

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.

Agile Angel Answered on May 10, 2017.
Add Comment

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

Agile User Answered on May 10, 2017.
Add Comment

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.

Agile Angel Answered on May 10, 2017.

This was incredibly helpful! I have to verify that the description in Agile PLM matches the description in another database and the idea of pasting each part number one by one into the search bar was depressing me.

Thank you!

on March 6, 2019.
Add Comment

Hi,

I raised an ENH request 3 years back for this feature, no update from Oracle on this in the last 3 releases.

-Anand

Agile User Answered on May 18, 2017.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.