Examples: query, "exact match", wildcard*, wild?ard, wild*rd
Fuzzy search: cake~ (finds cakes, bake)
Term boost: "red velvet"^4, chocolate^2
Field grouping: tags:(+work -"fun-stuff")
Escape special characters +-&|!(){}[]^"~*?:\ - e.g. \+ \* \!
Range search: properties.timestamp:[1587729413488 TO *] (inclusive), properties.title:{A TO Z}(excluding A and Z)
Combinations: chocolate AND vanilla, chocolate OR vanilla, (chocolate OR vanilla) NOT "vanilla pudding"
Field search: properties.title:"The Title" AND text
 
Answered
Customization of Messages Sent by Q2

We're customizing Q2's alert notification templates to match our brand voice. Q2 provided a list of 89 messages (email, SMS, secure message, and push) along with variable definitions or example values for 70 of them, which has been a great starting point. For example, we turned the default PostedTransactionNotificationPushBody:

{3} item(s) matched the {6} criteria for your account ending in {2}.

into:

We found {3} item(s) totaling {4:C} that matched your {6} alert for account ***{2}.

We were able to customize these because we know that {3} is an item count; {4:C} is a sum of item amounts with a currency format; {6} is a posted transaction type description like (Debit Transaction, etc.); and {2} is a last x digits of accounts number based on our system property. Without these variable descriptions or examples we had no idea if {2} was masked (as is sometimes the case), if it was the full account number, or if we needed to include stars to mimic a mask.

We need two things to finish the project:

  1. Voice/phone notification templates - We haven't received any documentation on these. Looking for the template names, default format strings, and variable definitions for the phone notification equivalents of what we've already customized.
  2. Variable definitions for the remaining 19 messages - We have the ShortName references and know the format strings are stored in dbo.Q2_UiTextView, but we don't have access to run queries against that database.

A few questions for the community:

  • Is there a Caliper API endpoint that returns a full list of notification messages and their corresponding variable definitions? That would be a cleaner path than working through support tickets.
  • Has anyone gotten the full variable mappings from Q2 and found a reliable way to request them?
  • We received the attached "Alert Verbiage Guide" that has been our guide in support tickets as it contains some technical detail for Q2 to use; however, we've struggled to find someone who has access to the DB we need to get the message and variable data. We've used the Q2 Console to try and identify individual messages but this is timeconsuming and unreliable.

Appreciate any help anyone can offer!
📎 Alert Verbiage Guide_Internal_Q2.pdf

Votes Newest

Answers 2


Hello,

Currently there is no Caliper API endpoint for this. I don't really have a good answer for any of the other questions other than it seems specific to your organization so it would be best handled in a ticket either to Q2 Support or Developer Support.

-Trey

Posted 7 months ago
Trey Teter
489 × 4 Administrator

Appreciate it Trey!

Posted 7 months ago
139 Views
2 Answers
8 months ago
7 months ago
Tags