Hello - I am trying to write an SOQL query to pull data from the SF share object related to one of my custom objects.
I am using Explorer to generate the query - but it does not work. I have reviewed the SOQL guide on relationships and am a bit lost on why this does not work.
My custom object is called DEALS and the DEALS__SHARE object was automatically created by SF to track any sharing associated with the records in this object. Any help getting this "join" to work is appreciated.
I am basically trying to get the AccessLevel, RowCause, and UserName (from the user table) from the Deal__share object and user object.
The suggested Explorer query and the error:
(Note: this works fine without the UserOrGroup.Name field. I believe this should refer to the group or user assigned the share permissions)
SELECT Id, AccessLevel, RowCause, UserOrGroup.Name FROM Deals__Share LIMIT 20
faultcode sf:INVALID_FIELD faultstring INVALID_FIELD: SELECT Id, AccessLevel, RowCause, UserOrGroup.Name FROM Deals__Share ^ ERROR at Row:1:Column:35 Didn't understand relationship 'UserOrGroup' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
All - I am using a web-based survey solution (Clicktools) to get some info from my clients to be imported into Salesforce. The survey tool enables the passing of "responses" to javascript. The code below is an example of a problem I am having that I can't seem to solve.
The code below takes the input from question 1 in the survey and writes it back out to the browser. The syntax in the survey tool is ${question_1} for question 1, ${question_2} for question 2, etc.
The problem is that if the response to question 1 is a NUMBER, the script below works fine. BUT if the response is TEXT, the javascript does not work. I am guessing the problem is due to the fact that I don't have quotes around the survey tool variable - but I can't because then the variable will not get set properly.
I have a List View Button that runs javascript to change the contents of a field. Basically, it is a bulk approval process - our salesmanager can run a list, check off a bunch of deals, then click the button to "Approve" a process (which is indicated by a specific field being updated to "APPROVED.")
I only want him to be able to run this button and have added a USER CUSTOM FIELD called APPROVE_DATA. How can I incorporate an IF statement in the javascript to first check if the logged in USER has APPROVE_DATA = TRUE before running the button. If APPROVE_DATA = FALSE, I would kick out an error.
I have a List View Button that runs javascript to change the contents of a field. Basically, it is a bulk approval process - our salesmanager can run a list, check off a bunch of deals, then click the button to "Approve" a process (which is indicated by a specific field being updated to "APPROVED.")
I only want him to be able to run this button and have added a USER CUSTOM FIELD called APPROVE_DATA. How can I incorporate an IF statement in the javascript to first check if the logged in USER has APPROVE_DATA = TRUE before running the button. If APPROVE_DATA = FALSE, I would kick out an error.
