question

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