query to review outgoing links

[Jonckheere BVBA]

I want to select all links where the lowest invert level of the links that leave the node is greather than the lowest invert level of the links that come in a node.

I’ve tried with the queries
· us_links.ds_invert >ds_links.us_invert
· us_links.invert >ds_links.invert
· min(us_links.ds_invert) >min(ds_links.us_invert)


None of the queries work. What did I do wrong ?

[Patrick Moore]

Jonckheere BVBA,

Thank you for posting your question.

Would you mind clarifying which modeling software package are you currently using?

Innovyze Support

[Jonckheere BVBA]

Infoworks ICM 6.0
If this works in infoworks, I want to change the query so that it also works in Infonet

[Patrick Moore]

Jonckheere BVBA,

I asked someone from our staff who is more knowledgeable with Infoworks your question and here is what they recommended to try.

"It sounds like you probably want to select the actual node where this issue occurs, so change the ‘Object’ to ‘Node’ in the RTC and use this:

Max (ds_links.us_invert)>MIN(us_links.ds_invert)

The same RTC should work in InfoNet."

[Jonckheere BVBA]

Thanks, it works.