query works in SWQL Studio BUT does NOT on an actual Custom Table

Chris-S

I've created a query in SWQL Studio that has some basic inline html and the query works.

When I paste this exact same query into a Custom Table widget of type SWQL (not SQL) it shows me the CORRECT query results if I hit "preview results"  BUT I cannot save the query in the datasource because it says : 

Columns with problems:   LOG

Usually it should give additional detail there when there is a problem but in this case, it does not.  We're running NPM 2020.2.5 HF1

I have "Allow HTML tags" checked ON in the Table Layout settings for each column.

What am I doing wrong?

SWQL:

SELECT
CONCAT(&#39;<p style="font-size:smaller">&#39;,ToLocal(EventTime),&#39;</p>&#39;) AS TimeStamp,
CONCAT(&#39;<p style="font-size:smaller">&#39;,Message,&#39;</p>&#39;) AS Log
FROM Orion.Events
WHERE (NetObjectType=&#39;N&#39; OR NetObjectType=&#39;I&#39;) AND EventType<>19
ORDER BY EventTime DESC

tony.johnson

This type of error typically appears when the column is no longer available in the data source but is still defined in the table layout. iIwas able to use your query without issue and see the table with  the applied HTML formatting

If I edit the data source and change the column alias to Log1 

while LOG has been added to the Table layout then I will see that same message.