Passing unknown param inputs in a user command

will_bishop — Fri, 23 Sep 2016 00:17:09 GMT

[ FlexSim 16.2.0 ]

I am writing a user command ("query_getqueryvalue") that acts as a wrapper for the "query" command and "getqueryvalue" command -- this will run a query and get the first result value in one call.

I am wondering how to pass an unknown number of command inputs onto the 'query' command, since that function accepts an unknown number of inputs as dynamic query parameters (using the $ syntax). I basically want to pass any extra "..." command inputs (past the first 2) onto the internal 'query' call.

Right now I'm doing a hacky solution (below) that checks the number of inputs (with 'parqty()') and uses a switch statement to pass the right number of inputs onto 'query'. Is there a better way to do this in flexscript/C++?

/**Custom Code*/


// parameter inputs
// (str col, str query[, node/num/str p1, node/num/str p2, ...])
string col = parstr(1);
string query_str = parstr(2);
int par_count = parqty();


// make a hacky 'query' call with the correct parameters (up to 8)
switch (par_count) 
{
	case 2: query(query_str);
	case 3: query(query_str, param(3)); break;
	case 4: query(query_str, param(3), param(4)); break;
	case 5: query(query_str, param(3), param(4), param(5)); break;
	case 6: query(query_str, param(3), param(4), param(5), param(6)); break;
	case 7: query(query_str, param(3), param(4), param(5), param(6), param(7)); break;	
	case 8: query(query_str, param(3), param(4), param(5), param(6), param(7), param(8)); break;	
	case 9: query(query_str, param(3), param(4), param(5), param(6), param(7), param(8), param(9)); break;	
	case 10: query(query_str, param(3), param(4), param(5), param(6), param(7), param(8), param(9), param(10)); break;	
	default: query(query_str); 
} 


// get first query value
var res = getqueryvalue(1, col);
return(res);

See attached for a zip of my library "project" in response to @Arun KR -- this includes the source model file (source.fsx), along with input data and the output .fsl library file. The model includes this custom User Command.

tableusercommands.zip

Re: Passing unknown param inputs in a user command

joerg_vogel_HsH — Fri, 23 Sep 2016 05:16:04 GMT

@Will Bishop have you read information on passing parameter into user command.

Re: Passing unknown param inputs in a user command

philboboADSK — Fri, 23 Sep 2016 15:17:09 GMT

Your hacky solution may not be pretty, but it should work fine.

It's a good solution.

Re: Passing unknown param inputs in a user command

will_bishop — Fri, 23 Sep 2016 22:16:34 GMT

It does work......which is the first and most important step.

I'll be satisfied with it until I hit another similar case where things break down.

Re: Passing unknown param inputs in a user command

arunTTT2P — Mon, 26 Sep 2016 06:39:55 GMT

Can you post a sample model?

Re: Passing unknown param inputs in a user command

mischa_spelt — Thu, 29 Sep 2016 07:58:47 GMT

@Will Bishop - unrelated: you are missing a break in the first case (par_count == 2).

Re: Passing unknown param inputs in a user command

will_bishop — Thu, 29 Sep 2016 17:39:15 GMT

Ah, thanks @Mischa Spelt! Good catch.

topic Re: Passing unknown param inputs in a user command in FlexSim Forum

Passing unknown param inputs in a user command

Re: Passing unknown param inputs in a user command

Re: Passing unknown param inputs in a user command

Re: Passing unknown param inputs in a user command

Re: Passing unknown param inputs in a user command

Re: Passing unknown param inputs in a user command

Re: Passing unknown param inputs in a user command