Skip to content

Instantly share code, notes, and snippets.

@helloandie

helloandie/CC-queries

Created July 1, 2015 18:29
Show Gist options
  • Save helloandie/6f03536227fa5172656c to your computer and use it in GitHub Desktop.
Save helloandie/6f03536227fa5172656c to your computer and use it in GitHub Desktop.
Download ZIP
Course Compensation Queries
Raw
CC-queries
Course Owner Query
SELECT Course_Owner__r.Name, Course_Owner__c.Compensation__c, Course_Owner__c.Compensation_Notes__c, Course_Owner__c.Compensated_As__c, RFS_Number__r.Name FROM Course_Owner__c WHERE Course__r.Name = 'G-4'
Course Director Query
SELECT Course_Director_Summary__c, Compensation_Summary__c, Compensated_As__c, RFS_Number__r.Name FROM Course_Director__c WHERE Course__r.Name = 'G-4'
Course Instructor Query
SELECT Instructor__r.Name, Instructor_Account__c, Compensation_Summary__c, RFS_Number__r.Name FROM Skill__c WHERE Course__r.Name = 'G-4'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment