Search for multiple document objects using a list of document numbers

Hello,

Is there a way I can search for multiple document objects using their full document reference numbers?

I quite often have lots of objects that need adding to the basket as a group and there doesn't seem to be any functionality in eB to quickly search for these references, other than search each and everyone individually and add to basket.

Eg. I have a report with 100 references on it. Each document needs to be added to the basket to be transmitted. how can I search for these 100 references quickly and efficiently?

I currently use a work around in eql using an excel sheet to concatenate a string of reference numbers for me eg:

START WITH Document
SELECT
Id,
IsLatestRevision,
Code,
Revision,
Name
WHERE
Code IN ( '1X6XX9-XXX-XA_000-ZZZ-PXD-XXX-000001', '14X1X9-XXX-NA_250-ZZZ-PLN-XXX-000001', '14X119-XXX-AA_000-ZZZ-XXP-XXX-500169' )

However this inst really a user friendly way to search and return multiple references.

Any advice would be appreciated.

Regards,

Oliver

  • Oliver,

    I have been doing some investigation on how to allow a user to add multiple document codes into a eQL report.

    Unfortunately, I have not had any luck finding a way to allow a user to enter a comma separated list of document codes into an eB report.

    To use eB Report you would have to have several user entries for code and search on those.

    I think the only other option is to use the eB SDK to perform desired activities. If this is something that would be desirable you can contact your Bentley account manager for information on the SDK, if you do not already have access to it, or if you would like information on Professional Services to assist in your efforts.

    Thanks,

    Michael

    Answer Verified By: Carma De Villiers 

  • Many thanks, I know if there were a simpler function allowing a bulk search of object references, this would be a great help to eB users everywhere!

  • Oliver,

    That is what I was thinking was the situation. I just wanted to make sure. I will start looking around to find a simpler out of box solution for you.

  • Hi Michael,

    Often I have to perform tasks in eB that involve documents that have no common piece of metadata associating them. There are hundreds of situations where I and my colleagues have needed to do this and is why I am asking the question. If it were the case that a group of references were associated in some way or another I could find these using eql or even eB web's default search facility. Often I need to do exactly this to relate items and create a common relationship.

    Example:

    I have been given a report that references a 100 eB document numbers. I need to relate these drawings (which have no common attribute or piece of meta data) as children to the parent document (the report). How can I quickly search for these 100 document references and add these to my basket, in order to create the relationship needed? The only current solution is to search for each reference individually, add to basket and create the relationship after clicking though 100 document search's.

    The only solution for bulk searching object references is the above eql I wrote. Other than this I have also been running a VBA script that creates eB quick links using the doc number and revision and then launches the link and executes the 'add to basket' link automatically.

  • Is there anything in common with these documents, a common portions of the code, an Attribute, or even a specific relationship? If not, how do you know these are the documents you need to search for.