Skip to main content
Panther Knowledge Base

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

  1. Last updated
  2. Save as PDF

QUESTION

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

ANSWER

 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

try

select json_object:my_special_field as my_field from the_table