superset-notifications mailing list archives

GiannisDimitriou commented on issue #10754:
URL: https://github.com/apache/incubator-superset/issues/10754#issuecomment-688097787


   @villebro  thanks for trying to reproduce this. 
   I don't use any additional filters on the JSONB column. 
   Also the end query is a bit more complicated so exposing the `transaction_id` on a different
column will make things a lot more complicated.
   
   Can you try running the below query in SQL Lab and then press EXPLORE in order to visualise
it.
   This is what I see following the above steps:
   
   `SELECT 
   *
   FROM (
   SELECT 
   *
   FROM (
   VALUES 
   (1::int,'[{"transaction_status":"SUCCESS","transaction_id":1},{"transaction_status":"SUCCESS","transaction_id":2}]'::jsonb),
   (2::int,'[{"transaction_status":"PENDING","transaction_id":3},{"transaction_status":"CANCEL","transaction_id":4}]'::jsonb)
   ) s(id, transaction_details)
   ) t
   WHERE transaction_details @> '[{"transaction_status":"SUCCESS","transaction_id":1}]'`
   
   ![image](https://user-images.githubusercontent.com/47314887/92359393-d89b5880-f0f3-11ea-83fe-ffda82404e38.png)
   ![image](https://user-images.githubusercontent.com/47314887/92359493-02ed1600-f0f4-11ea-9935-d3d728884283.png)
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org