Sort doesn't work when using Gravity Forms encryption plugins

GravityView cannot sort results when using plugins that encrypt Gravity Forms data. This is a known issue and is not going to be fixed.

Gravity Forms has multiple encryption plugins, the most popular being Gravity Forms Encrypted Fields. GravityView isn't able to sort results when this plugin is activated.

Why doesn't sorting work when using an encryption plugin?

To understand why the sorting doesn't work, let's look at what Gravity Forms encryption plugins do. The plugins work by encrypting the data submitted by Gravity Forms before it gets stored in your database.

Before encryption, values of form entries are stored in "plaintext" in your site's database, which means they're readable to the naked eye:

Entry values stored in the database, not encrypted. Example: Joan Smith

After encryption, the entry values are scrambled using a secure algorithm to prevent being readable without a password, which is also encrypted.

Entry values stored in the database, after being encrypted. The value is scrambled text.

You can see that sorting alphabetically would be problematic based on the encrypted values! GravityView sorts using values fetched directly from the database, so sorting won't work when the values are encrypted.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us