Skip to Main Content
Autodesk
ADD A NEW IDEA

SQL

Showing 10 of 1040

Import and export SQL objects to InfoWorks formatted text file

Importing and exporting rainfall data, ground level files, flow surveys in ICM using a defined format is already possible. Adding this functionality to SQL queries means users can manage their SQL's more easily, store queries in a central location...
Nick Dahl 3 months ago in InfoWorks ICM / SQL 0 Gathering support

ChatGPT in ICM

Hello Help Desk, this is just a general query, but will Autodesk-Infoworks be developing plug-ins for ChatGBT to allow Chat GBT to write custom SQL queries for Infoworks WSPro and ICM? Chat GBT can already write generic SQL queries, but it needs t...
Paul Guilas about 1 year ago in InfoWorks ICM / SQL 1 Will not implement

Please provide Intellisense to the SQL Editor in ICM

I want the SQL Editor to help me write SQL queries by color coding and autocompleting data, similar to Intellisence.
Guest over 4 years ago in InfoWorks ICM / SQL 0 Gathering support

SQL in run dialog box to select gauged objects

Using SQL to select gauged objects would allow their dynamic selection based on object properties, not just from a static list. This is an issue when testing scenarios if field names are added/changed. It is further compounded by selection lists b...
Guest over 3 years ago in InfoWorks ICM / Productivity / SQL 0 Gathering support

TSDBs to produce logs of SQL queries

This is important to assist troubleshooting issues related with TSDB performance during implementation and maintenance of TSDBs. The log should include the exact queries produced by their streams when data is updated.
Guest almost 3 years ago in InfoWorks ICM / SQL / Time Series DB 0 Gathering support

Run SQL Query across multiple simulation results

Similar to how ICM lets me run a SQL query across multiple networks, I want to use SQL to summarize results in a custom way across multiple simulation results objects. Ideally they could be joined in one table similar to the way one can query fro...
Guest over 3 years ago in InfoWorks ICM / SQL 1 Gathering support

Run a SQL Query that requires sim and sim2 to be active from ICM Exchange

I would like to run a SQL query from ICM Exchange that requires two simulations to be active. I would like to be able to call multiple simulations simultaneously from Exchange.
Guest almost 3 years ago in InfoWorks ICM / API / Exchange / SQL 0 Gathering support

Select objects outside polygon in SQL

In Infoworks ICM the SQL select has a spatial search option where I can, for example, select all nodes within a 2D zone. I am wanting to select all nodes outside the 2D zones, and this I am unable to do as inverting the selection will select all ...
Guest over 3 years ago in InfoWorks ICM / SQL 0 Gathering support

Implicit SQL link between River reaches and associated storage area

It should be possible to write a validation query to check if the lowest vertex of a River reach bank line does not lie below the ground level of the storage area it overflows to. With an implicit link between the river reach and the left and righ...
Guest over 4 years ago in InfoWorks ICM / SQL 0 Gathering support

Enable SQL validation rules in ICM

In InfoAsset it is possible to setup SQL rules that can then be used in validation, it would be nice to have the same in ICM.
Guest over 4 years ago in InfoWorks ICM / SQL 0 Gathering support