How can I select a list of tasks where the OwnerId != CreatedById?

I am trying to do the following and getting an error: "Unexpected Token"

List<

What is the correct way to select tasks where the Creator != Owner?

thanks

Task> ltsk = [SELECT id, subject, CreatedById, OwnerId FROM Task WHERE OwnerId != CreatedById];

February 28, 2011
·
Like
0
·
Follow
0

Best Answer chosen by Admin (Salesforce Developers)

forecast_is_cloudy
Unfortunately, SOQL does not currently support comparing two field values in the WHERE clause. Though you can't do the above directly in SOQL, I do have a neat trick for you courtesy of our resident Force.com guru (Simon).

Create a Formula field on Task that compares the 2 fields. Something like

IF (OwnerId == CreatedById, "true", "false")

In your SOQL Query, just search on the Formula field instead:

i.e.

List<Task> ltsk = [SELECT id, subject, CreatedById, OwnerId FROM Task WHERE my_custom_formula__c = 'false'];