Spreadsheets across spaces with built-in parameters

[Tamilselvan Easwaran]

Hi Team,

Am trying to use spreadsheets across spaces, but querying with built-in parameters still fetches the original space values.

Eg : Created a spreadsheet & Query in space x. The query used $spaceKey parameter to filter the resutls. Created connection in space y using space X details. But when used the same query in space y, it doesn't use $spaceKey of space y, but uses $spaceKey of space x. 

Please help me to sort this out.

[Adrien Ragot (Play SQL / CYO)]

So you want to use cross-space queries and still use the $spaceKey parameter? That's correct, the macro's space isn't provided and you'll always see the original space's key.

• You could prompt the user for a value,
• You could use the $pageTitle or $pageId.

It is the best approximation, given there's no option to do exactly what you want.

[Tamilselvan Easwaran]

Thank u so much. I may not be using playSQL in the right way :) But that's what I need to do. Using $pageTitle can work across spaces ? Thx mate