SQL

Showing 10 of 1170

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 9 months ago in InfoWorks ICM / SQL 0 Gathering support

4 VOTE

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 over 1 year ago in InfoWorks ICM / SQL 1 Will not implement

9 VOTE

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 about 5 years ago in InfoWorks ICM / SQL 0 Gathering support

4 VOTE

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 almost 4 years ago in InfoWorks ICM / Productivity / SQL 0 Gathering support

2 VOTE

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 over 3 years ago in InfoWorks ICM / SQL / Time Series DB 0 Gathering support

2 VOTE

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 almost 4 years ago in InfoWorks ICM / SQL 1 Gathering support

1 VOTE

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 over 3 years ago in InfoWorks ICM / API / Exchange / SQL 0 Gathering support

1 VOTE

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 about 4 years ago in InfoWorks ICM / SQL 0 Gathering support

1 VOTE

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 almost 5 years ago in InfoWorks ICM / SQL 0 Gathering support

0 VOTE

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 about 5 years ago in InfoWorks ICM / SQL 0 Gathering support

Please enter your email address

FILTER BY CATEGORY