Skip to main content
September 6, 2021
Question

How to query a JSON column in mySQL database

  • September 6, 2021
  • 1 reply
  • 0 views

Hello,

As mentioned in the title, I have an SQL table that has a JSON type column.

When I query it using a!queryEntity() in an expression rule, the resultant datasubset returns all the fields EXEPT the JSON field. 

Do I need to take special measures when I deal with a!queryEntity() when it comes to JSON fields? 

Thank you,

    1 reply

    malathik
    September 7, 2021

    Hi,

    Attached snip from the result of MariaDB and it doesn't seems like required any special mention. May be if you could share your table structure and QE code could help us in moving one step further.