Skip to content

Instantly share code, notes, and snippets.

@salsalabs

salsalabs/custom_column_option_values.sql

Created January 18, 2019 19:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save salsalabs/a3a2dbca62d035120eb2901dc5364d6a to your computer and use it in GitHub Desktop.
Save salsalabs/a3a2dbca62d035120eb2901dc5364d6a to your computer and use it in GitHub Desktop.
Download ZIP
Query to retrieve custom column option values. Useful for creating cusotm fields in Engage when importing form Classic.
Raw
custom_column_option_values.sql
select cc.label, cc.type, cco.value
from custom_column cc
left outer join custom_column_option cco
on cco.custom_column_KEY = cc.custom_column_KEY
where cc.organization_KEY = 51035
and cco.organization_KEY = 51035
order by cc.label, cco.value;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment