I have a select query with a user-defined function field.
The function takes required args, some of which are fields in the query, plus some that I don't want in the query.
(The query is 1/2 of a union query, and I don't want to have to pad the other select query with fields it doesn't need.)
I use the Expression Builder for the function call, and it appears to work correctly.
My question is, in the context of the query design grid, does the Expression Builder "know" to join the fields not included in the query passed as args to the udf?
The fields passed to the udf not included as fields in the select query are all from the same tables on which the query is based.
The function takes required args, some of which are fields in the query, plus some that I don't want in the query.
(The query is 1/2 of a union query, and I don't want to have to pad the other select query with fields it doesn't need.)
I use the Expression Builder for the function call, and it appears to work correctly.
My question is, in the context of the query design grid, does the Expression Builder "know" to join the fields not included in the query passed as args to the udf?
The fields passed to the udf not included as fields in the select query are all from the same tables on which the query is based.
