Emojis - SQL In ICM InfoWorks - 📜 3 Deletion with SQL 📜

 📜 3 Deletion with SQL 📜

Venture into the world of object removal using the DELETE keyword within InfoWorks ICM.

🔍 Deletion Features:

• Deleting objects with specific criteria 🔄: Use DELETE WHERE followed by the criteria, e.g., DELETE WHERE x > 10000.
• Overriding table names 📌: For specific tables, use DELETE FROM [Table Name] WHERE [Criteria].
• Modifying deletion behavior ⚙️: Use keywords ALL or SELECTED, e.g., DELETE ALL WHERE x > 10000.
• Deleting all objects ❌: Simply use DELETE ALL.

🧠 Advanced Scenarios:

• Delete within specific scenarios e.g., DELETE ALL FROM [All Nodes] IN SCENARIO 'west' WHERE x < 644000.
• Structured blob deletion, e.g., DELETE FROM [Table Name].blob_name WHERE condition.

📜 4 Insertion in SQL 📜

Discover the art of adding objects using SQL within InfoWorks ICM.

🔍 Insertion Features:

• Adding individual objects 🔄: Use INSERT INTO <table name> (fields) VALUES (values).
• Inserting into structured blobs 📌: Syntax is INSERT INTO <table name>.<blob name> (fields) VALUES (values).
• Inserting from SELECT statements ⚙️: Use INSERT INTO <table name> (fields) SELECT <select statement>.

🧠 Advanced Insertions:

• Add objects to specific scenarios using syntax like INSERT INTO node(node_id,x,y) IN BASE SCENARIO VALUES ('N2',3,4).

📜 5 Assignment with SQL 📜

Harness SQL to modify object values within the InfoWorks ICM network.

🔍 Assignment Features:

• Assigning new values 🔄: Use SET to modify fields, e.g., SET user_number_1 = 123.
• Overriding default tables or behaviors 📌: Use the UPDATE keyword.

🧠 Advanced Assignments:

• Assign multiple values at once by separating them with commas.
• Assign NULL values, e.g., SET ground_level = NULL.

Dive deeper into the power of SQL within InfoWorks ICM to optimize, customize, and elevate your workflows! 🌊💡🔧🖥️🔄.

Emoji - SQL in ICM InfoWorks - 📜 2 Advanced Topics In Selection 📜

 📜 2 Advanced Topics In Selection 📜

Dive deep into the realm of advanced selection features in InfoWorks ICM with SQL.

🔍 Considered Features:

• Multiple clause selection 🔄
• Overriding table names 📌
• Modifying selection behavior ⚙️
• Deselection ❌
• Clearing selections 🚫
• Special cases for selecting/deselecting all table objects 🔄

📝 2.1 Selection in multiple clauses 📝 Select objects using several clauses evaluated sequentially. Separate clauses with a semi-colon like x>10000; y>20000; ground_level > 15.5. With multiple clauses, the ‘test’ button won't predict selection count, only syntax correctness. Selections can also be represented as x>10000 OR y>20000 OR ground_level > 15.5.

📌 2.2 Overriding the table name 📌 Multiple clauses can select objects across different tables. By default, an SQL query targets specific tables like Node, Pipe, etc. Override this by using 'SELECT FROM' with the desired table, e.g., SELECT FROM Conduit WHERE width > 100.

🔄 2.3 Overriding the default selection behaviour 🔄 The SQL dialog box checkbox defines if a query is applied universally or just to selected objects. Use keywords ALL or SELECTED to adjust this behavior. E.g., SELECT ALL WHERE x > 10000.

❌ 2.4 Deselection ❌ Deselecting, the opposite of selecting, removes objects from your current selection. Use the DESELECT keyword followed by your criteria. E.g., DESELECT WHERE x > 10000.

🚫 2.5 Clearing The Selection 🚫 To remove all selections, use the CLEAR SELECTION keywords.

🔄 2.6 Selecting or deselecting all objects in a table 🔄 Use SELECT to select all objects in the default table. Many ways exist to select all objects, such as using the expression 1, true, or 'anystring'. To select from a non-default table, use SELECT FROM followed by the table name. Remember, these only modify the selection if the default behavior is to select all objects. If you want to specify the behavior, use SELECT ALL.

Harness the power of advanced selection techniques to optimize your workflows in InfoWorks ICM with SQL! 🌊💡🔧

Emoji - 🔗 ICM Exchange for Autodesk: Your Ultimate Bridge 🛠️

 🔗 ICM Exchange for Autodesk: Your Ultimate Bridge 🛠️

---

🌟 Overview:

Welcoming the ICM Exchange - InfoWorks ICM's IExchange masterpiece tailored for Autodesk aficionados. But wait, there's a twist! It's exclusively crafted for the elite, those wielding the power of an Ultimate license. Dive into this seamless integration and elevate your Autodesk experience.

---

🚀 How to Use:

Execute the command as:

bash
ICMExchange [options] [--] script [-login|-l] [args]

🔑 Parameters Breakdown:

1. options:

   • (Optional) Sprinkle in some Ruby command line zest. Dive deeper with the Command Line Options for a detailed grasp.

2. --:

   • (Optional) A neat separator to distinguish the Ruby command line options.

3. script:

   • Illuminate the path to your Ruby script.
   • Pro tip: If your script path has spaces sprinkled in, cocoon it within "" for a seamless experience.

4. -login or -l:

   • (Optional) An invitation to the Autodesk Identity party! Launches the webpage for users to log in.
   • For the already logged-in elite, the journey continues without a pause.
   • For the rest? An error message greets: "Autodesk Licensing Error: The licence is not authorised (3). unable to initialise".

5. args:

   • (Optional) A golden ticket for the curious minds! Bestow additional arguments to your script and witness the magic unfold.

---

🔔 Heads Up:

Beware of the Subscription overuse specter; it's always lurking. The rules are in play, so tread wisely.

---

📚 Further Reading:

Thirsty for more? Quench your thirst with the comprehensive Exchange document. Dive deep into the world of WSPro Exchange, ICM Exchange, and InfoAsset Exchange.

---

🌟 Wrapping Up:

With ICM Exchange for Autodesk, bridging gaps becomes a breeze. Whether you're a seasoned pro or just getting started, this tool promises to elevate your Autodesk journey. So gear up and embark on this seamless integration voyage.