+ Start a Discussion
HayaHaya 

Compile Error: No such column

I have an extension with the following:

     caseOpen = [Select Priority,CaseNumber,Accountid,Subject,Contactid,CreatedDate,Ownerid,Status,SuppliedName   
                    from case

Which works fine.

 

I want to add a field: Owner, and I get the msg: Error: Compile Error: No such column 'Owner' on entity 'Case'.

 

It is a field in Case. The difference from the other fields is that it has Data Type Lookup(user,Queue)

 

How do I go about getting the field?

 

THanks,

Haya

Best Answer chosen by Admin (Salesforce Developers) 
souvik9086souvik9086

caseOpen = [Select ownerID,Priority,CaseNumber,Accountid,Subject,Contactid,CreatedDate,Ownerid,Status,SuppliedName   
                    from case];

 

It will be ownerid.

 

If this post is helpful please throw Kudos.If this post solves your problem kindly mark it as solution.

Thanks

 

 

All Answers

souvik9086souvik9086

caseOpen = [Select ownerID,Priority,CaseNumber,Accountid,Subject,Contactid,CreatedDate,Ownerid,Status,SuppliedName   
                    from case];

 

It will be ownerid.

 

If this post is helpful please throw Kudos.If this post solves your problem kindly mark it as solution.

Thanks

 

 

This was selected as the best answer
HayaHaya

Thanks Souvik,

 

I didn't realize that I was already asking for ownerid.

 

Where would I find the field name to use?

When I go to Customize -> Case -> Fields I see Case Owner and Owner not ownerid.

 

Thanks again,

Haya

souvik9086souvik9086

http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_objects_case.htm#topic-title

 

Go through this list of Case fields.

 

If the post helps you please throw KUDOS.

Thanks

HayaHaya

Thank you Souvik,

 

That is very helpful.

 

Haya