I am running into an issue with the soql queries. I am fairly new to using the soql and am not completely familiar with the restrictions. I am trying to pull information on the Cases in my sfdc, my question is regarding the relationship w/ the case owner information. I am using the Ajax Tookit/ Explorer to format my query, when I expand the information in Cases -> Parents -> Owner I only have access to: Id, Name, Type, Email, DoesSendEmailToMembers, CreatedDate, LastModifiedDate, SystemModstamp. The information I need is: UserRole.Name. Can someone explain to me how I go about tying these object together in order to obtain the information I need? I couldn't find really anything regarding joins like I would do in sql e.g. SELECT a.CaseNumber, a.Status, a.CreatedDate, b.UserRole.Name FROM Case a JOIN User b ON a.Owner.Id = b.Id
My end goal is to pull a query of almost all of the information tied to the cases so I can load this info into my database....If the above is not possible is there a better way to automate data dumps? I currently have a report in sfdc that gives me all of the info I need, however I need to automate this process so I don't have to manually download the report and insert it.
I am trying to use PHP in the self service portals header and footer and everytime I save it ends up changing my php code into percents signs and text.
Hi, I am probably missing something here, but after several tries using Formula, workflow and field updates in various combinations, I just can't seem to figure this one out. Please forgive me if this turns out to be a no-brainer...
I have created the same custom field "NDA Signed" for Account and Opportunity. What I am trying to accomplish is to be able to automatically update the field in Opportunity, when the field in the related Account is filled in or updated.
I was using a checkbox but that didn't go anywhere. I can see this field being a textbox with "Yes" or "No" to replace the checkbox, if necessary.
Any help would be greatly appreciated. Thank you! Lynn
I have used to Force.com IDE in Eclipse to build my trigger and before i even write my Unit Test method i want to know to the steps that i have to do through eclipse move my code from sandbox to prod.
I tried to click on validate option when i right click on the trigger and gives me an error
I am trying to use PHP in the self service portals header and footer and everytime I save it ends up changing my php code into percents signs and text.
