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

· October 21, 2023

 📜 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! 🌊💡🔧