|
|
Can we enhance conduit theming using robust SQL queries? We're aiming to apply themes based on the mean of minimum upstream and downstream velocities in each conduit over the TSR simulation. Considering the multiple scenarios involved in system design, this approach would significantly streamline result interpretation and support faster decision-making.
Thank you for your reply. We tried using the SQL option in Thems (to calculate the average of minimum upstream and downstream pipe velocity), but it did not work. The workaround we found is to populate values in user-defined fields and then re-run the process. However, since our task involves several trials, we thought of making this feature work within Thems SQL rather than using user-defined fields, as this would save a lot of time
Thank you for raising this and thanks to those who voted. As Bob mentioned, this can be done using a ruby script that can analyse a time-varying data and populate user-number fields and then you can run your SQL on the user-number fields.
Give it a try and let me know how you get on. I will move this to "Already exists" since there is a workaround and if you happen to disagree, please get back to us to share your thoughts and I would be happy to update the status.
this can also be done with ruby and the user fields