PDA

View Full Version : query to review outgoing links



Jonckheere BVBA
June 26, 2015, 12:10 AM
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
June 26, 2015, 07:06 AM
Jonckheere BVBA,

Thank you for posting your question.

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

Innovyze Support

Jonckheere BVBA
June 26, 2015, 07:59 AM
Infoworks ICM 6.0
If this works in infoworks, I want to change the query so that it also works in Infonet

Patrick Moore
June 26, 2015, 10:42 AM
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
June 28, 2015, 11:50 PM
Thanks, it works.