topic Re: Is it possible to pass the result of a query as a function parameter? in FlexSim Forum

Is it possible to pass the result of a query as a function parameter?

guiroehe — Sat, 08 Nov 2025 23:10:08 GMT

Hello,

I wonder if it is possible to pass the result of a query as a parameter in a function call. If so, what is the specification for the variable in the function code? I tried with Table, but the function receives an invalid content.

Also, how one tests if a query is NULL? objectexists(...) does not seem to work.

Thank you.

Re: Is it possible to pass the result of a query as a function parameter?

jason_lightfoot_adsk — Sun, 09 Nov 2025 14:18:17 GMT

You can use a clone of the table result to cast it as an array and pass it as a variant parameter.

Re: Is it possible to pass the result of a query as a function parameter?

guiroehe — Mon, 10 Nov 2025 14:48:08 GMT

Hi, @jason_lightfoot_adsk ,

thank you. It worked.

I am implying that this way the query looses its "table" characteristics, correct (column names, indexes, etc.)?

Thank you once more.

Re: Is it possible to pass the result of a query as a function parameter?

jason_lightfoot_adsk — Mon, 10 Nov 2025 14:51:36 GMT

Yes - you lose that information in a array. You could alternatively create a Map of the table for better referencing and pass that to your function - try mapFromTable() here.

Re: Is it possible to pass the result of a query as a function parameter?

guiroehe — Mon, 10 Nov 2025 15:54:57 GMT

Thank you very much!