table-transformer - use of custom plugin

[xahdpe]

hi,

kindly help me to understand how to use custom macro in queries. Is it possible at all (for now i can only use Status and Color macros?

SELECT 
FORMATWIKI("{status:colour=Orange|title=Ok}") status, -- WORKS 
FORMATWIKI("{page-info:page=",@pageTitle,"}" ) as pg_id -- DOES NOT WORK 
FROM T1

thanks.

[Stiltsoft support]

Hi @xahdpe ,

If you are talking about the Table Transformer macro provided by the Table Filter, Charts & Spreadsheets for Confluence app, then the macro is based on the AlaSQL library with bits of javascript.

The FORMATWIKI function supports Confluence wiki markup and works as a part of SQL query.

As I understand, you are talking about some custom macro that is not supported indeed. But as I see the @pageTitle variable in your query, you can still use it into your queries. We support the "today", @pageTitle and @currentUser variables as for now. Here are the examples how to use them.

[xahdpe]

yep , that is true, and i can use "status" macro, but i cannot use any other macros (3rd party macros), such as 'page-info' which can return me a pageid for the given title.