Skip to content

Instantly share code, notes, and snippets.

@qpfiffer
Last active August 29, 2015 14:00
Show Gist options
  • Save qpfiffer/380ab72dd9a6535f8ad9 to your computer and use it in GitHub Desktop.
Save qpfiffer/380ab72dd9a6535f8ad9 to your computer and use it in GitHub Desktop.
select * from django_snailtracker_action as ac
join django_snailtracker_snailtrack as st on st.id = ac.snailtrack_id
join django_content_type as ct on st.content_type_id = ct.id
where ct.model = 'supplier' and '"invoiced"' in (select value::text from json_array_elements(columns_changed::json));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment