Search node by GUID

[Hardy]

If I know the GUID of the node, can I locate it in my model quickly?

[qwerty]

Write a SQL search

Code: [Select]

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

[Hardy]

I used that query in search builder with my GUID (with or without {}), and I clicked run button. But nothing really happened.

[qwerty]

For me it worked. You need the guid with curly brackets. Did you create the search so it's in the drop down? It will not work in the SQL tab of the search builder but only the Search Builder tab itself!



q.

[Hardy]

See mine

[qwerty]

I once found that when you copy/paste a SQL into the builder it does not work. Delete the word SELECT, type it manually and retry. That might fix it.

2nd thought. with "node" you mean an element, not a package?

q.

[Hardy]

No luck. If I remove the where condition I can get all nodes back.

[Geert Bellekens]

Two possible reasons:

1) the GUID you are searching for is one of a diagram, operation, element, ... anything but an element
To check this you can use the EA Navigator. There's button that selects anything with the copied GUID (also for non-element things)
2) you have an extra space somewhere before or after the GUID
To check this you can add wildcard to the where clause

Code: [Select]

where ea_guid like '#WC#<Search Term>#WC#'
Geert

[Hardy]

The GUID is a sequence diagram. I used your EA Navigator I could locate it properly but the built-in search feature failed.

[qwerty]

Then instead of t_object  you must search in t_diagram.

q.