You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Where Clause in Desktop .NET app

Content

I have  to create a report that will need to only list if a contact in a case does not match a contact in an incident.

Normally a WHERE clause would look like this:

Case.Contact != Incident.Contact

But it seems I cannot do this in the Expression filters  because it limits to something like this:

Case.Contact  Not Equals  {value}

And this {value} cannot be a matched against another field.

How do I accomplish this using desktop application for reports?

 

The resolve I found was to uncheck selectable filter that allowed me to use an expression.

 

Version

Service Cloud

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!