RE: ViewQueriesQueries - Project

Question

Ref: http://communities.bentley.com/products/hydraulics___hydrology/f/5925/t/111173 
 Two notes: 
 1- Have a look at attached model. Open Pipe Query-1. Difference between Flow defined in Query Builder and calculated Flow is 0.0000000001. Pipe P-226 is selected when Apply is clicked. If you set a value out of +-0.0000000001 (like 0.000000001) it can not find the pipe. It means the tolerance in Queries is likely 0.0000000001. 
 2- I want to make a Query for a Selection Set. WaterGEMS seems can not do it. Am I right? Do you have an idea to do this? 
 Query (Tolerance).rar 
 thanks.

tlfoster56 · Answer

1. You are using the equal sign in your query, therefore it Is only going to find results that are exactly equal to that number. It is better that you use <= or >= to see results. 
 
2. You are correct in that you cannot create a query for a selection set. You can create a selection set from a query.

Rob Gurrieri · Answer

Hi Moosa, 
 
re: #2- query for a selection set 
 
If you know the id's that you want to query for, you could do something like this: 
 ElementID IN (32,34,36,38) 
 
Best regards, 
Rob.

MPachlhofer · Answer

Mike, 
 I believe the same suggestion that Jesse previously stated in the other forum thread will solve the problem. Using a query that searches for values less than a small value such as 0.01 should locate those values. (i.e. IdahoPipeResults_PipeDischarge (Flow) < 0.01 or IdahoPipeResults_PipeDischarge (Flow) < = 0.01). 
 If you wanted to use the = (equals) sign to search for exact values you could do that by using the unique values icon (see blue box) on the upper right side of the Queries window. This icon will only be clickable after you choosing a property (see red box) from the left hand portion on the window. The unique values will all be listed in the back box area in the unique values output portion of the window. From there you can double click on a value to choose that exact value. 
 
 Regards, 
 Mark

Jesse Dringoli · Answer

The "tolerance" is a multiplier, not a fixed value - see "Queries" section of the below Support Solution that was mentioned in the previous thread: 
 
 communities.bentley.com/.../24255.what-is-the-tolerance-used-with-queries-and-alerts 
 
In the model attached to this thread, the query is configured to retrieve pipes with flow = 0.000510254483787 
 
As seen in the article, the buffer multiplier of 0.000001 is applied, so the query will actually retrieve pipes with flow between: 
 
0.000510254483787 * (1 - 0.000001) = 0.000510253973532516213 
 
And... 
 
0.000510254483787 * (1 + 0.000001) = 0.000510254994041483787 
 
The query retrieves a single pipes, whose flow is 0.000510254583787. This flow is between the range as defined above.

RE: View>Queries>Queries - Project