Enumerations and Queries | Community
Skip to main content
robertc66522596
robertc66522596
Level 4
January 16, 2018

Enumerations and Queries

  • January 16, 2018
  • 1 reply
  • 11902 views

Good Morning!

We're hoping to utilize Enumerations within Campaign in order to avoid the potential fat finger/extra space/capital letter issue in our querying. However, after following the necessary set-up here: Managing enumerations  i'm running into some unexpected behavior (to me) and i'm looking to confirm whether or not it is how the system should perform.

We updated the schema so that one field is listed as:

<attribute dbEnum="wbmItemTypeGroupDescription" desc="Item Type Group Description Enum"

               label="Sales Category" length="100" name="ItemTypeGroupDescription"

               type="string"/>

This maps correctly to the Enumeration built in the system:

- As you can see in the screenshot the enumeration is listed as 'Open' so that more values can be added in the entry screen.

However in a query activity, i have the dropdown options, but no capability to free text in a new value.

Do 'Open' enumerations not allow entry from within a query? Or is there something wrong with out set-up?

Thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

florentlb
florentlb
Level 10
January 30, 2018

Hi,

From my understanding, new values should be entered through a form (in the detail view of the element I guess), while the query is used to query already existing values.

Can you share a screenshot of your query so I can still double check and make sure of where you are trying to insert the new value from?

Thanks,

Florent

robertc66522596
robertc66522596Author
Level 4
January 30, 2018

Hi Florent,

Sure thing:

Yeah, that's what I assumed but was hoping I did something wrong. It seems like a shortcoming of the 'open' functionality, because the query is the most useful place for enumerations and where they most frequently need to change.

One thing I did just notice is that if I click the 'Edit Expression' button from within the 'Value' field I am able to free text a new value, however it does not allow me to save the new entry as an enumeration.

Thanks

Amit_Kumar
Amit_Kumar
Level 10
January 31, 2018

Hi,

what you are asking is against the use of enumerations.

https://docs.campaign.adobe.com/doc/AC6.1/en/PTF_Administration_Elements_Managing_enumerations.html

new enumeration values should only be created via forms only.

In queries, you can use the distribution values, by using little button on top right corner, next to save, in query

or you can go one step ahead and write a workflow which will automatically update your enumeration based on the distribution values in your common tables.

Regards,

Amit

Terms & ConditionsAccessibility statement

Loading footer...