DESelect June ’21 Release: Viewing SQL queries, encrypted fields, and multibyte characters

DESelect June '21 Release

At the start of summer, DESelect is releasing not 1 but 3 new sunny features: Viewing SQL Queries within DESelect, Encrypted fields and Multibyte characters in DESelect. Let’s dive in.

Viewing SQL Queries within DESelect

Available in: DESelect Enable, DESelect Plus, DESelect Advanced

As you know, DESelect provides a user-friendly interface to build campaign segments by a simple drag-and-drop, while building complex SQL queries in the backend.

Now, people who do understand SQL sometimes may want to see the query that DESelect built, to make sure DESelect built the query they wanted. This is now possible in a very easy way.

When you preview a selection, a link View Query becomes available on the Preview screen. When clicking this link, a modal pops up showing the SQL query DESelect built in a nicely formatted way, complete with indentation and colors for easy reading.

SQL query view that you can create in DESelect

Encrypted Fields

Available in: DESelect Enable, DESelect Plus, DESelect Advanced

DESelect supports working with data extensions that contain encrypted fields, and this reflects in 3 places: 

Available Fields

In the Available Fields sections, which shows the fields that are available for filtering, encrypted fields will be marked with a lock icon.

Available fields to use when building a selection in DESelect

Creating a Target Data Extension

When creating a new target data extension, an additional option appears on newly created fields to mark a field as encrypted.

Target data extension field in Salesforce Marketing Cloud

Note that when creating a new field from an existing encrypted field, this new field will also be encrypted.

Preview

When running a preview with encrypted fields, the preview screen in DESelect will show the columns of these encrypted fields not in plain values, but encrypted unreadable values.

Multibyte characters

Available in: DESelect Enable, DESelect Plus, DESelect Advanced

Multi-byte character sets are used to accommodate languages with scripts that have large numbers of characters and symbols, predominantly Asian languages such as Chinese, Japanese, and Korean. 

DESelect fully supports these character sets throughout the application. For a user working with multibyte characters in their data extensions, DESelect works in exactly the same way as a user using English in their data extensions.

Conclusion

Whether you’re a SQL expert or just want to learn SQL a bit more, DESelect now makes it very easy to see the SQL query DESelect builds for the preview in an easy-to-read format.

Organizations using encrypted fields can trust that with the use of DESelect, the encrypted data remains encrypted. Also, users working with multi-byte characters can be assured that DESelect fully supports their use case.

Do you want to give any of these features a try? Request a demo here.

Reach the most targeted<br/> audiences in half the time

Reach the most targeted
audiences in half the time

Deselect icon
Subscribe to the Newsletter
Receive Salesforce Marketing Cloud tips,
tricks, and DESelect updates

By clicking the “Subscribe now” button, you agree to the DESelect Terms of Use and Privacy Policy.