Question: Find element by identifier

[zhang-zimin]

Question:How can I query all elements with properties using a MicroStation identifier ID in an iModel?

[grigasp]

Hi. Try this query:

SELECT e.*
FROM bis.Element e
JOIN bis.ExternalSourceAspect a ON a.Element.Id = e.ECInstanceId
WHERE a.Identifier = ?