cross workspace query breaks pivot?

Brass Contributor

I have a custom table in several workspaces.

Perf_CL | evaluate pivot(Name_s, sum(Value_d))

this works fine.

however when i try to run it across to another workspace:

workspace("remote").Perf_CL | evaluate pivot(Name_s, sum(Value_d))

i get the following error:

SYNTAX ERROR
One or more pattern references were not declared. Detected pattern references:
Support id: 1c9dac84-e6f4-441d-9072-40ae43dc971d
0 Replies