-
Hello, I'm new to the community and have been exploring the iTwin platform and iTwin.js documentation to understand how ECSQL facilitates interactions with iModels, I've observed a lot on read operations in the examples and proyects. so my first question: Is it possible to perform UPDATE operations, or to use commands equivalent to "DESC" for exploring table schemas in ECSQL? Based on my readings, it seems these operations might not be supported, but I would like to get confirmation on this. Additionally, I have a question concerning the concept of working locally as defined by iTwin.js. I understand that it's possible to download iModels and interact with them on a local machine. When iTwin.js docs mentions the ability to download the iModel and work locally, does this refer solely to collaboration within a team, or could it also mean making modifications—such as updating a comment on a piece of functional equipment—and later uploading these changes back to the Imodel inside the Itwin in the iTwin platform? I appreciate any insights, or guidance Thank you very much in advance! |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments 8 replies
-
You cannot change the contents of an iModel directly using ECSql statements like INSERT, UPDATE, and DELETE. You must instead use the TypeScript APIs provided by @itwin/core-backend like updateElement. For interactive editing workflows you would typically rely on tools to perform those operations. Interacting with an iModel locally involves downloading a briefcase. You can then push your own local changes and pull other people's changes. HTH. If you have further questions, please specify what you are trying to accomplish. |
Beta Was this translation helpful? Give feedback.
-
You can use ECSql to query for the schemas used to store data in the iModel. It's exposed via the ECDbMeta schema. Here is some examples from our doc site: https://www.itwinjs.org/learning/ecsqltutorial/metaqueries/ I hope this helps. If you have more specific questions about querying for EC (db) schemas in an iModel. |
Beta Was this translation helpful? Give feedback.
You cannot change the contents of an iModel directly using ECSql statements like INSERT, UPDATE, and DELETE. You must instead use the TypeScript APIs provided by @itwin/core-backend like updateElement. For interactive editing workflows you would typically rely on tools to perform those operations.
Interacting with an iModel locally involves downloading a briefcase. You can then push your own local changes and pull other people's changes.
HTH. If you have further questions, please specify what you are trying to accomplish.