Hi, I am getting the time in particular states in this way:
double FLHRS = 0;
Object FL = Group("name")[INDEX];
FLHRS += FL.as(Object).stats.state().getTotalTimeAt("travel empty");
FLHRS += FL.as(Object).stats.state().getTotalTimeAt("travel loaded");
Is there a way to do this using a query?
Hi @Enrique Elizaga, was Felix Möhlmann's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.
If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.
You can clone the state profile node into a global table and then use an SQL query on that.
Object FL = Group("name")[INDEX];
treenode states = FL.find(">stats/state_current/profile").as(Table).cloneTo(Table("GlobalTable1"));
Table result = Table.query("SELECT SUM(time) FROM GlobalTable1 WHERE state == 'travel empty' OR state == 'travel loaded'");
double FLHRS = result[1][1];
Though that is just an extra step to arrive at the same result. Might I ask why you want to use a query instead of the command?
In that case, shouldn't something like this also work (untested!)?
Object FL = Group("name")[INDEX];
treenode states = FL.find(">stats/state_current/profile");Table result = Table.query("SELECT SUM(time) FROM $1 WHERE state == 'travel empty' OR state == 'travel loaded'", states);
double FLHRS = result[1][1];
18 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
