How to Enable Redact Query in VDM

Trouble Viewing Images? Right-click on any image and select "Open in new tab" to view a larger version. You can also zoom in using Ctrl + Mouse Wheel for easier readability.

Article Goal

This article explains how to enable the Redact Query option in VDM and when to use it to protect sensitive information within queries.

Why Redact Queries?

Redacting queries is useful for hiding sensitive information such as:

• PII

• PCI

• PHI 

🔒 Example use case: If your query includes Social Security Numbers or personal account details, redacting them prevents those values from appearing in query logs or being unintentionally exposed during troubleshooting or sharing.

Normal Query: Shows full query text with all parameters.

Redacted Query: Obscures or removes sensitive values for privacy.

💡 These previews are visible in the application logs section after executing the view.

Where Is the Redact Query Option?

You can enable Redact Query in the View Options ribbon bar within the VDM interface.

💡 This is a per-view setting, meaning you must enable it individually for each view you want to protect.

Video Tutorial:

Not yet available.

Steps to Enable Redact Query in VDM

Note: Redact Query is a view level option. This option will need to be enabled on each view individually.

1: Open or Create a View: Start by opening an existing view or creating a new one where query redaction is required.

💡 Redaction only applies at the view level, not globally across VDM.

2: Open the View Options: From the main screen, click on View Options.

3: Enable the Redact Option: Locate the Redact box and enable it.

✅ Once enabled, the background of the Redact button will change color to indicate activation.

💡 Background color may vary depending on your UI theme; for example, in the default skin it appears gray when active.

4: Run the View and Check Logs: Execute the view, then inspect the logs to confirm that values are being redacted as expected.

🔍 Look for "Query Redacted" to confirm the query is not being returned in the logs.

⚠️ Redaction does not modify the actual data—it only alters the way queries are logged and displayed.

What’s Next?

With Redact Query enabled:

• You can safely run and share views without revealing sensitive information.

• This feature is ideal for auditing, logging, and debugging in secure environments.

Article Summary

This article guides users through enabling the Redact Query option in VDM to protect sensitive data within SQL queries. It describes when redaction is useful (for PII/PCI/PHI), where to find the setting, and how to confirm that redaction is active. Redaction applies at the view level, ensuring better privacy when working with confidential data.