Seach Model by GUID?

[Dorian Workman]

I assume there is a way to search for an object by its GUID, but I cant seem to find it.  Is there?

Thanks.

[mrf]

You could create a Custom SQL Search with the following query

Code: [Select]

SELECT t_object.ea_guid AS CLASSGUID, t_object.Object_Type AS CLASSTYPE, Name
FROM t_object
WHERE t_object.ea_guid = '<Search Term>'

[potterm]

Yes a custom search works, but only with v6.5.  I found that in v7.0/7.1 the custom search feature truncates the search term to a certain length which means that you can't enter an entire GUID.  I raised a bug report (which Sparx initially said was a feature request!), but I think they've addressed this in the EA7.5 beta anyway.

[Dorian Workman]

You're right I just tried it.  Have you tried to see if it works in the 7.5 betas?

P.S.  The only reason I need this feature is to get around a bug in the Compare Utility which drops the Source name of all Links.  So I'm looking in the XML and I found the Source GUID, and then am trying to search by that.

[potterm]

No I just saw it mentioned in the list of changes.

[mrf]

I tried the search in 7.5 and it seemed to work there without truncating the search term.

Alternatively if you have 7.5 you could open a Javascript console and use the type the following command:

Code: [Select]

Session.Output( Repository.GetElementByGuid("{E3FB786F-F882-4d4d-BDD1-393995D14886}").Name );

[Dorian Workman]

Thanks, we're not running 7.5 until it goes final, but will try it then.

[mrf]

Ah ok no problems. In the meantime (and this won't be 100% accurate) you could try this:

Code: [Select]

SELECT t_object.ea_guid AS CLASSGUID, t_object.Object_Type AS CLASSTYPE, Name
FROM t_object
WHERE t_object.ea_guid LIKE '<Search Term>#WC#'
which will try and match as much of the search term as it can to the t_object.ea_guid field (the #WC# macro inserts the wildcard for the current database).

[Dorian Workman]

Thanks!