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.

  • What’s new in DESelect: December 2022

    Happy Holidays! It’s time to reveal what’s inside the last DESelect release of 2022. Our December release is packed with upgrades like access to more data, serious workflow enhancements, and helpful improvements that admin users will love.   Shared Custom Values Expedite your process and remove redundant tasks. *Available for: the Advanced plan. Previously, when […]
  • What’s new in DESelect: October 2022

    Happy October! We’re excited to announce a bunch of new features focused on increasing your efficiency and effectiveness as marketers. Many of the new features in this release have been highly requested and eagerly awaited by our customers so let’s jump right in. Introducing: Filter Sets Drive efficiency with Filter Sets*Available for: Plus and Advanced […]
  • What’s new in DESelect: August 2022

        The DESelect team has been looking forward to this release with many eagerly requested features finally here and ready for you! This August we’re introducing several features and UIUX enhancements designed to keep your workflow smooth, simplify data management, and empower Admin users. Building, revising and managing Waterfall Selections is now easier, and […]
  • What’s new in DESelect: June 2022

    Summer is finally here along with powerful new features from our team. DESelect proudly opened the door to non-technical marketers by ending the technical dependencies around SQL. We also take pride in equipping technical marketers with tools that increase work efficiency and campaign precision in Marketing Cloud. Today we’re taking this even further: Introducing: Data […]

Stay Connected

Join our newsletter to receive updates and helpful SFMC guides

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.