Skip to main content
Solved

Changing Output through Advanced Logic?

  • September 8, 2023
  • 3 replies
  • 47 views
hunterjoseph12

I am trying to create a JO program that suggests content based on their role (CIO, Application, etc). The way in which I do this is to match their role to our contents Taxonomy Level through a calculated field.

My issue lies in that not all of our roles (Security & Risk or CIO/CTO for example) match up to its corresponding Taxonomy (Security or CIO). Is there a way within the advance logic to change the outputted string if it matches a certain criteria? Something that may mimic how I would make this change if it was a coding language such as:

If role == Security & Risk then role = Security

Any help would be appreciated! 

Best answer by kstim

@hunterjoseph12 Unsure if this is exactly what you’re looking for / if it fulfills this request, but instead of having to use the taxonomy, could you just create different email variants and apply filters in those variants based off their roles? Example:

  • Email variant 1: Role = Security (or you could do Role contains “Security” depending on what you’re looking for)
  • Email variant 2: Role = CISO
  • Email variant 3: Role = Product Manager

etc etc etc. 

Or, if the taxonomy needs to be used, I’m sure you could accomplish corresponding that with role by adding case expressions. Using your example, you could create a string case expression like so: 

  • CASE when role = Security & Risk THEN custom “Security”

Just an idea - hopefully this helps in some way!

3 replies

kstim
Forum|alt.badge.img+7
  • kstim
  • Helper ⭐️⭐️
  • Answer
  • September 8, 2023

@hunterjoseph12 Unsure if this is exactly what you’re looking for / if it fulfills this request, but instead of having to use the taxonomy, could you just create different email variants and apply filters in those variants based off their roles? Example:

  • Email variant 1: Role = Security (or you could do Role contains “Security” depending on what you’re looking for)
  • Email variant 2: Role = CISO
  • Email variant 3: Role = Product Manager

etc etc etc. 

Or, if the taxonomy needs to be used, I’m sure you could accomplish corresponding that with role by adding case expressions. Using your example, you could create a string case expression like so: 

  • CASE when role = Security & Risk THEN custom “Security”

Just an idea - hopefully this helps in some way!

heather_hansen
hunterjoseph12
hunterjoseph12
  • hunterjoseph12
  • Author
  • Contributor ⭐️⭐️
  • September 8, 2023

@hunterjoseph12 Unsure if this is exactly what you’re looking for / if it fulfills this request, but instead of having to use the taxonomy, could you just create different email variants and apply filters in those variants based off their roles? Example:

  • Email variant 1: Role = Security (or you could do Role contains “Security” depending on what you’re looking for)
  • Email variant 2: Role = CISO
  • Email variant 3: Role = Product Manager

etc etc etc. 

Or, if the taxonomy needs to be used, I’m sure you could accomplish corresponding that with role by adding case expressions. Using your example, you could create a string case expression like so: 

  • CASE when role = Security & Risk THEN custom “Security”

Just an idea - hopefully this helps in some way!

 

ah this was so incredibly helpful! I was going to default to the email variants - but the case expressions is exactly what i was looking for (and i was not aware about its existence!)

kstim
kstim
Forum|alt.badge.img+7
  • kstim
  • Helper ⭐️⭐️
  • September 8, 2023

Yay! Glad I could help 😃

Terms & ConditionsCookie settingsAccessibility statement