Question About Query SQL

[zhang-zimin]

Hi all,

If I want to retrieve all file or model names from an iModel, do you have any suggestions?

Thanks!

[anmolshres98]

Hi, There are a couple of ways to do this depending on your context.

1. Best option if you have a iTwin application running locally. You can access and acquire the active iModel connection with call like useActiveIModelConneciton. You can iterate over all the models using iModelConnection.models. Each item returned in the iterator returns a ModelState object. This has a name field that gives the value you are looking for. There is other data about the model that you might find useful as well
2. You can run a ECSQL query from your app or on the cloud in iModel Console: SELECT e.CodeValue from BisCore.Element e JOIN BisCore.PhysicalModel p on e.ECInstanceId = p.ECInstanceId. You can play around in iModel Console and Schema Explorer to find more information about the model as well

Note: If you use the ecsql query, the codeValue might be empty. In that case, we use this fallback logic to determine what the label should be: https://www.itwinjs.org/presentation/advanced/defaultbisrules/#label-overrides