Hello,
Has anyone created any output set elements for Contact Permissions or know if any standard ones are in the pipeline? We're looking at the Wordfly Unsubscribe override and we need the last ask date for it to work. The trick is, we need to make sure it is for the right Contact Permission Type (guessing we are stepping into Output Set Filters here) and we are also in a Consortium so it needs to be from a Secure view.
I've been looking at the view VXS_CUST_CONTACT_PERM_TYPE. Is that the best one?
Has anyone else looked at this? Thanks in advance.
Kelly
Following up from this. I've created the output set elements but now I'm not sure how to create a reference to another table. For example, for the Contact Permission Type it is pulling the ID but I actually want to see the CP Type description. Is there a way to do this with the new set up?
Hey Kelly,
Under TR_OUTPUT_ELEMENT_PARAMETERS you are able to reference another table. This is how I've been able to pull out things like theater name for our different theaters even though it's looking at the id_no first. If you want me to get more in the weeds about it feel free to e-mail me mdummerth@centertstage.org
You will probably need to setup a local view and reference that
something like
CREATE View [dbo].[LVXS_CUST_CONTACT_PERM_FULL]ASselect cp.customer_no, perm_cat=cpc.description, perm_type=cpt.description, perm_type_short=cpt.short_description, cp.answer, cp.last_asked_dtfrom [dbo].[VXS_CONTACT_PERMISSION] cpjoin [dbo].[VRS_CONTACT_PERM_TYPE] cpt on cp.type_id=cpt.idjoin [dbo].[VRS_CONTACT_PERM_CATEGORY] cpc on cp.category_id=cpc.id