Skip to main content
Panther Knowledge Base

Can I have a Saved Search in Panther with a JSON selector in it?


 How do I use JSON selectors in my saved searches if Panther doesn't allow column named with a colon (:)?


 To use a colon as a JSON selector in saved searhces, you must alias the column name. For example, instead of

select json_object:my_special_field from the_table


select json_object:my_special_field as my_field from the_table