Can I use SQL in the Table Transformer macro to filter for status macro values?

Question

I'm using Page Properties and Page Property Report macros to make customer reports of pages using specific Page Properties.  In one of my reports I'd like to include only Page Properties that contain a column called Status that contains a Status Macro with the value of "High".  I'm using the Table Transformer macro to provide SQL filter.  I tried the following, but didn't work: "SELECT * FROM T* WHERE 'Status' ~ "High".

I'm aware of the ability to filter based on an ID provided in Page Properties macros, but I'm looking for a finer degree of filtering beyond the simple example given above, such as with multiple columns (eg, Status combined with Importance)

Stiltsoft support · Answer

No, the ::string part is not necessary for the WHERE clause.

If the issue is that you don't get any errors but you just don't get any matching rows, it means that there are no such rows indeed.

You've mentioned that you used the "Status Macro with the value of "High" - try to filter your table by "HIGH" and not "High". It seems that the macro statuses are written in capital letters.

And the tilde "~" has a kind of a similar meaning as a simple LIKE (that is often considered to be an SQL-standard), your first query should be also recognized correctly.

Ted Nienstedt_jopgk9 · Answer

I found that ::string was necessary as follows

SELECT * FROM T* WHERE 'Status'::string LIKE "High"

Stiltsoft support · Answer

Hi @Ted Nienstedt ,

Please try the following SQL statement:

SELECT * FROM T* WHERE 'Status' LIKE "High"

It should be working fine.