SELECT Artist_sX_Name__c,Guest_Role__c,Other_Role_Description__c,ACTS__r.Repertoire__c,ACTS__r.Act_Description__c,Id FROM SFDC_Attendee__c WHERE Concert_Date__c=2019-06-09 AND (Status__c='GUEST CONDUCTOR' OR Status__c='COMPED') ORDER BY Web_Ensemble_Order__c ASC LIMIT 100
{"fields":"Artist_sX_Name__c,Guest_Role__c,Other_Role_Description__c,ACTS__r.Repertoire__c,ACTS__r.Act_Description__c","o":"SFDC_Attendee__c","filter":"Concert_Date__c=2019-06-09 AND (Status__c='GUEST CONDUCTOR' OR Status__c='COMPED')","by":"Web_Ensemble_Order__c","n":"100","debug":"true"}
{"totalSize":3,"done":true,"records":[{"attributes":{"type":"SFDC_Attendee__c","url":"\/services\/data\/v48.0\/sobjects\/SFDC_Attendee__c\/a091T00000SeQxtQAF"},"Artist_sX_Name__c":"Christer L\u00f8vold","Guest_Role__c":"Director","Other_Role_Description__c":null,"ACTS__r":{"attributes":{"type":"SFDC_Acts__c","url":"\/services\/data\/v48.0\/sobjects\/SFDC_Acts__c\/a051T000014pufkQAA"},"Repertoire__c":"Swiss Gospel Singers and Friends (Switzerland)<\/span><\/p>","Act_Description__c":null},"Id":"a091T00000SeQxtQAF"},{"attributes":{"type":"SFDC_Attendee__c","url":"\/services\/data\/v48.0\/sobjects\/SFDC_Attendee__c\/a095000000QUsEJAA1"},"Artist_sX_Name__c":"Christopher Tin","Guest_Role__c":"Composer\/Conductor","Other_Role_Description__c":null,"ACTS__r":{"attributes":{"type":"SFDC_Acts__c","url":"\/services\/data\/v48.0\/sobjects\/SFDC_Acts__c\/a055000000qww3MAAQ"},"Repertoire__c":"Tin:\u00a0<\/b>Calling All Dawns<\/i>","Act_Description__c":"Featuring Distinguished Concerts Orchestra and Distinguished Concerts Singers International"},"Id":"a095000000QUsEJAA1"},{"attributes":{"type":"SFDC_Attendee__c","url":"\/services\/data\/v48.0\/sobjects\/SFDC_Attendee__c\/a095000000RcS2KAAV"},"Artist_sX_Name__c":"Jonathan Griffith","Guest_Role__c":"DCINY Artistic Director and Principal Conductor","Other_Role_Description__c":null,"ACTS__r":{"attributes":{"type":"SFDC_Acts__c","url":"\/services\/data\/v48.0\/sobjects\/SFDC_Acts__c\/a055000000xhe2lAAA"},"Repertoire__c":"Ray:\u00a0<\/b>Gospel Mass <\/i>(40th Anniversary of Composition)","Act_Description__c":"Featuring Distinguished Concerts Orchestra and Distinguished Concerts Singers International"},"Id":"a095000000RcS2KAAV"}]}
{"objectName":"SFDC_Attendee__c","fieldsArray":["Artist_sX_Name__c","Guest_Role__c","Other_Role_Description__c","ACTS__r.Repertoire__c","ACTS__r.Act_Description__c"],"currentLabelsArray":{"Id":"Record ID","IsDeleted":"Deleted","Name":"PG ID","RecordTypeId":"Record Type ID","CreatedDate":"Created Date","CreatedById":"Created By ID","LastModifiedDate":"Last Modified Date","LastModifiedById":"Last Modified By ID","SystemModstamp":"System Modstamp","LastActivityDate":"Last Activity Date","LastViewedDate":"Last Viewed Date","LastReferencedDate":"Last Referenced Date","Letter_to_the_editor_sent_hometn_media__c":"Letter to the editor sent hometn media?","Contact__c":"Main Contact","Status__c":"Status","ACTS__c":"ACTS","Group__c":"Group","Add_ons_Performer_Expected__c":"Performers Expected PG","Concert__c":"Concert","Performer_Registrations__c":"Performers Registered PG","VIP_Patron_comps__c":"VIP Patron comps","Performer_Comp__c":"Performer Comps PG","Add_ons_VIP_expected__c":"VIP's Expected PG","VIP_Patron_registered__c":"VIP's Registered PG","Artist_Passes_X100__c":"$150 Gala Reception Pass+ Concert Ticket","Soprano_1__c":"Soprano_1","Soprano_2__c":"Soprano_2","Alto_1__c":"Alto 1","Alto_2__c":"Alto 2","Tenor_1__c":"Tenor 1","Tenor_2__c":"Tenor 2","Bass_1__c":"Bass 1","Bass_2__c":"Bass 2","Deposit_Date_Details__c":"Deposit Date\/Details","Audition_Recording_Received__c":"Audition Recording Received","Formal_Invite_PPI_Sent__c":"Formal Invite\/PPI Sent?","Registration_Sent__c":"Registration Sent?","Registration_Returned__c":"Registration Returned?","Performer_s_Agreement_Sent__c":"Performance Agreement Sent","Performer_s_Agreement_Signed_Received__c":"Performance Agreement Signed","Deposited_Group__c":"Deposited Group","Vitals_Request_Sent__c":"Vitals Request Sent?","Vitals_Completed__c":"Vitals Completed","Registrants_21__c":"Registrants 21+","Registrants_Under_21__c":"Registrants Under 21","Initial_Deposit__c":"Initial Deposit Received","Date_of_Initial_Deposit__c":"Initial Deposit Date","X2nd_Deposit_Received__c":"Second Deposit Received","Third_Deposit_Received__c":"Third Deposit Received","Date_of_second_deposit__c":"Date of second deposit","Date_of_third_deposit__c":"Date of third deposit","Accounting_Notes__c":"Accounting Notes","Reception_Note__c":"Reception Note","W_9_form_sent_to_group__c":"W-9 form sent to group","Invitation_Notes__c":"Invitation Notes","Main_Contact_w_email_address__c":"Main Contact w\/ email address","PR_materials_requested_photo_bio__c":"PR materials requested (photo\/bio)?","Program_Notes_Received__c":"Program Notes Received?","Press_Release_sent_to_hometown_media__c":"Press Release sent to hometown media?","Mailing_List_s_received_from_group__c":"Mailing List(s) received from group?","Concert_Info_Memo_sent__c":"Concert Info Memo sent?","Press_Release_to_hometown_media_2nd_run__c":"Press Release to hometown media; 2nd run","Director_s_Meeting_confirmed__c":"Director's Meeting confirmed?","Poster_order_forms_sent__c":"Poster order forms sent?","Archival_Agreement_collected__c":"Archival Agreement collected?","Framed_Poster_distributed__c":"Framed Poster distributed?","Press_release_sent__c":"Press release sent hometn media?","Poster_order_status__c":"Poster order status","Thank_you_packet_sent__c":"Thank you packet sent?","Client_Follow_up_Survey_sent__c":"Client Follow-up Survey sent?","Client_Follow_up_survey_received__c":"Client Follow-up survey received.","Receipt_Info_doc_sent__c":"Receipt Info doc sent","X100_Gala_Performer_Pass__c":"$100 Gala Performer Pass","Photo_received__c":"Photo received?","Bio_received__c":"Bio received?","Ground_Transportation__c":"Ground Transportation","Travel_Agent__c":"Travel Agent","Single_Rooms__c":"Single Rooms","Flight_Number__c":"Flight Number","Flight_Itinerary__c":"Flight Itinerary","Double_Double_Rooms__c":"Double\/Double Rooms","Hotel_Address_and_Phone__c":"Hotel Address and Phone","Travel_Notes__c":"Travel Notes","Local_Media_2__c":"Local Media 2","Local_Media_1__c":"Local Media 1","Local_Media_3__c":"Local Media 3","Group_photo_received__c":"Group Photo received?","Group_Bio_received__c":"Group Bio received?","Secondary_Contact__c":"Secondary Contact","Attendee_Notes__c":"Attendee Notes","Vitals_Link__c":"Vitals Link","Rehearsal_Schedule_Sent__c":"Rehearsal Schedule Sent (TBA location)?","Token_Deposit_Received__c":"Token Deposit Received","PR_Materials_Due__c":"PR Materials Due","Tax_Exempt_Form_Sent__c":"Tax Exempt Form Sent","Program_Notes__c":"Program Notes","Program_Notes_Source__c":"Program Notes Source","Date_of_Token_Deposit__c":"Date of Token Deposit","Box_Office_Promotions_Form_Due__c":"Box Office&Promotions Form Due","Performance_Agreement_Due__c":"Performance Agreement Due","PR_Form_Returned__c":"PR Form Returned","ACT_Total_Performers__c":"ACT Total Performers","Concert_Total_Performers__c":"Concert Total Performers","Vitals_Due__c":"Vitals Due","Season_Announcement_Memo_Sent__c":"Season Announcement Memo Sent","Welcome_Packet_Sent__c":"Performer Portal Sent","Box_Office_Reminder_Sent__c":"Box Office Reminder 1 Sent","Box_Office_Promo_Form_Rec_d__c":"Box Office&Promo Form Rec'd","Box_Office_Reminder_2_Sent__c":"Box Office Reminder 2 Sent","Date_of_Invitation__c":"Date of Invitation","Invitation_Received__c":"Invitation Received?","Total_Number_of_Travelers1__c":"Total Number of Travelers","Main_Contact_w_phone_number__c":"Main Contact w\/ phone number","Treble_1__c":"Treble 1","Treble_2__c":"Treble 2","Treble_3__c":"Treble 3","Treble_4__c":"Treble 4","Rehearsal_Concert_Audit__c":"Rehearsal\/Concert Audit","Total_SATB_Numbers__c":"Total SATB Numbers","Reception_Venue__c":"Reception Venue","W_9_Returned__c":"W-9 Returned","Main_Contact_w_city__c":"Main Contact w\/ city","DCINY_Contact__c":"DCINY Contact","Main_Contact_w_state__c":"Main Contact w\/ state","ppi_rate_comp_notes__c":"PPI Rate\/Comp Notes","X200_Gala_Reception_Concert_Ticket__c":"$200 Gala Reception Pass+ Concert Ticket","ATC_follow_up_needed__c":"ATC follow-up needed","ATC_Notes__c":"Developer Notes","Concert_Date__c":"Concert Date","Triple_Rooms__c":"Triple Rooms","Quad_Room__c":"Quad Rooms","Private_Tour__c":"Private Tour","New_York_City_Attractions__c":"New York City Attractions","Travel_Agency__c":"Travel Agency","DCINY_Contact_Email__c":"DCINY Contact Email","Will_Call__c":"Will Call","Delivery__c":"Delivery","Delivery_Instructions_Notes__c":"Delivery Instructions\/Notes","Total_Number_of_Travelers__c":"Total Number of Travelers","Comp_Tickets__c":"Comp Tickets","Reception_1_s__c":"Reception +1's","Cross_Market_Comp_Tix__c":"Cross-Market Comp Tix","Ticket_Face_Value__c":"Ticket Face Value","Ticket_Location__c":"Ticket Location","Ticket_Seat_Number__c":"Ticket Seat Number","Discounted_Cost__c":"Discounted Cost","Discounted_Cost_Rate__c":"Discounted Cost Rate","Purchased_Tickets_Group_Order__c":"Purchased Tickets\/Group Order","SATB_CHOIR__c":"SATB CHOIR","TREBLE_CHOIR__c":"TREBLE CHOIR","MIXED_SATB_AND_TREBLE__c":"MIXED SATB AND TREBLE","FEE_paid_by_DCINY__c":"FEE paid by DCINY","Height__c":"Height","Rehearsal_Sch_Sent_confirm_location__c":"Rehearsal Sch Sent (confirm location)?","All_PG_Vitals_Received__c":"All PG Vitals Received?","Audition_Notes__c":"Audition Notes","Date_of_First_Invoice__c":"Date of First Invoice","Air_Utilization_Reminder__c":"Air Utilization Reminder","Double_King_Rooms__c":"King Double Rooms","Tour_arrival_date__c":"Tour arrival date","Tour_departure_date__c":"Tour departure date","Finance_Contact__c":"Finance Contact","Status_Client_Travel__c":"Status - Client Travel","ATC_Clients__c":"ATC Clients","ATC_Only_Invoicing__c":"ATC Only Invoicing","Group_Meals__c":"Group Meals","Revised_Invoice_Needed__c":"Revised Invoice Needed","Order_Status__c":"Order Status","Welcome_Packet_Status__c":"Concert Confirmation Packet Status","Local_Media_1_contact__c":"Local Media 1 (contact)","Local_Media_2_contact__c":"Local Media 2 (contact)","Local_Media_3_contact__c":"Local Media 3 (contact)","Ensemble_Name__c":"Ensemble Name (Group)","Ensemble_Name_PR_ready__c":"Ensemble Name PR ready?OLD","Returning_Group__c":"Returning Group?","Vitals_Status__c":"Vitals Status","Vitals_Discrepancy_Details__c":"Vitals Discrepancy Details","Artist_s_Name_PR_Ready__c":"Artist's Name PR Ready?","Web_Guest_Order__c":"Web Special Guest Order","Web_Ensemble_Order__c":"Web Ensemble Order","Guest_Role__c":"Role Description","Other_Role_Description__c":"Other Role Description","XXDirector_s_Name__c":"Director's Name","Link_to_Registration_Form__c":"Link to Registration Form","Artist_sX_Name__c":"Artist's Name","Web_Ensemble_Name__c":"Web Ensemble Name","Ensemble_Name_PR_ready_NEW__c":"Ensemble Name PR ready?","Group_Returned__c":"Group Returned","Link_to_PR_Registration_Form__c":"Link to PR Form","DCINY_Contact_2__c":"DCINY Contact 2","Gala_Guest_Name__c":"Gala Guest Name","Program_Notes_Due__c":"Program Notes Due","Add_On_VIP_Reg__c":"Add-On VIP Reg","Current_Developer_VIP_Registered__c":"Current Developer VIP Registered","Deposits__c":"Deposits","Letter_of_Agreement_Sent__c":"Letter of Agreement Sent","Letter_of_Agreement_Due__c":"Letter of Agreement Due","Letter_of_Agreement_Received__c":"Letter of Agreement Received","Add_on_Registered_Performers__c":"Add-on Registered Performers","SFDC_Test__c":"Current Developer Performers Registered","ACT_Total_VIP__c":"ACT Total VIP","Main_Contact_w_Country__c":"Main Contact w\/Country","Current_Developer_ID__c":"Current Developer ID","ATC_Revised_Invoice_Needed__c":"ATC Revision Needed","Invoice_Revision_Notes__c":"Revision Notes","Former_Developer_Reg_Perf_PG__c":"Former Developer Reg Perf PG","SFDC_TEST1__c":"SFDC TEST1","TAP_Ratio__c":"TAP Ratio","Sightseeing__c":"Sightseeing","Group_Roster__c":"Group Roster","Broadway_Tickets__c":"Broadway Ticket Vendor","Chorus_Type__c":"Chorus Type","ATC_New_Invoice_Needed__c":"ATC New Invoice Needed","Cancelled_Deposited_Performers__c":"Cancelled Performers Reg","Cancelled_VIPs_Reg__c":"Cancelled VIPs Reg","Cancellation_Notes__c":"Cancellation Notes","Update_Reception_s__c":"Update Reception #s","Performer_Travelers__c":"Performer Travelers #","VIP_Travelers__c":"VIP Travelers #","Other_Guest_Travelers__c":"Total Travelers","DCINY_Decline_Notes__c":"DCINY Decline Notes","Date_Deposited__c":"Date Deposited","Previous_Status__c":"Previous Status","Date_Edited__c":"Date Edited","Current_Developer__c":"Current Developer","Non_Traveler_Performer__c":"Non-Traveler Performer #","Non_Traveler_VIP__c":"Non-Traveler VIP #","Total_of_Travelers__c":"Total # of Travelers","Date_Declined__c":"Date Declined","Date_Invoiced__c":"Date Invoiced - DCINY","Update_Attendee_s__c":"Update Attendee #'s","Ensemble_Name_Contact__c":"Ensemble Name (Contact)","Status_Client_Travel_Date__c":"Status - Client Travel Date","Stage_Plot_Due__c":"Stage Plot Due","Stage_Plot_Request_Sent__c":"Stage Plot Request Sent","Stage_Plot_Notes__c":"Stage Plot Notes","Main_Contact_w_Address__c":"Main Contact w\/ Address","Main_Contact_w_Zip_Code__c":"Main Contact w\/ Zip Code","CP_Reminder_1__c":"CP Reminder 1","CP_Reminder_2__c":"CP Reminder 2","Choral_Recording_Received__c":"Choral Recording Received","Choral_Recording_Reviewed__c":"Choral Recording Reviewed","PR_Form_Google_Doc__c":"PR Form","Combined_Invoice__c":"Combined Invoice","Guest_Conductor_Production_PR_Form__c":"Guest Conductor Production & PR Form","Vitals_Follow_Up__c":"Vitals Follow Up","Gala_Pass_Expected_PG__c":"Gala Pass Expected PG","Vitals_Follow_Up_Values__c":"Vitals Follow Up Values","W9_Address__c":"W9 Address","W9_Link__c":"W9 Link","W9_Full_Name__c":"W9 Full Name","Name_of_Local_Newspaper__c":"Name of Local Newspaper","Name_of_Local_Classical_Radio_Station__c":"Name of Local Classical Radio Station","Name_of_Local_TV_News_Station__c":"Name of Local TV News Station","Name_of_Local_Concert_Reviewer_Publicati__c":"Name of Local Concert Reviewer\/Publicati","Other_Media_Outlet_1__c":"Other Media Outlet #1","Other_Media_Outlet_2__c":"Other Media Outlet #2","Other_Media_Outlet_3__c":"Other Media Outlet #3","Other_Media_Outlet_4__c":"Other Media Outlet #4","Link_to_Opportunity__c":"Link to Opportunity","Main_Contact_w_cell_phone__c":"Main Contact w\/ cell phone","Travel_Insurance_Link__c":"Travel Insurance Link","Gala_Pass_Registered__c":"Gala Pass Registered","Ground_Transportation_Confirmation__c":"Ground Transportation Confirmation","Director_Performing__c":"Director Performing?","Nonperforming_Director_Taking_a_Bow__c":"Nonperforming Director Taking a Bow?","Acknowledgement_of_Comp_Tickets__c":"Acknowledgement of Comp Tickets","Group_Promotion__c":"Group Promotion","Attractions_Date_Time__c":"Attractions Date\/Time","Hotel_Attrition_Deadline__c":"Hotel Attrition Deadline","Air_Utilization_Date__c":"Air Utilization Date","Hotel_Roster_Confirmed__c":"Hotel Roster Confirmed","Air_Ticketed__c":"Air Ticketed","Let_us_know_any_interesting_story_angles__c":"Let us know any interesting story angles","Total_Rooms__c":"Total Rooms","Airline_Consolidator__c":"Airline Consolidator","Room_Nights__c":"Room Nights","Hotel1__c":"Hotel","Airline1__c":"Airline","Thank_You_Packet_Ship_Date_Tracking__c":"Thank You Packet Ship Date & Tracking","Broadway_Ticket__c":"Broadway Ticket Amount","Broadway_Show_Name__c":"Broadway Show Name","Total_Room_Nights__c":"Total Room Nights","Metrocard_Amount__c":"Metrocard Amount","Metrocards__c":"Metrocards","Group_State__c":"Group State","Group_Country__c":"Group Country","Group_City__c":"Group City","Emergency_Contact_Information__c":"Emergency Contact Name","Group_Meal_Sightseeing_Itinerary__c":"Group Meal & Sightseeing Itinerary","Group_Promotion_Confirmed__c":"Group Promotions Confirmed","Hotel_Room_Allotment__c":"Hotel Room Allotment","Emergency_Contact_Phone__c":"Emergency Contact Phone Number","Main_Contact_PR__c":"Main Contact NYC","Main_Contact_PR_w_Phone_Number__c":"Main Contact NYC w\/ Phone Number","Associated_PG__c":"Associated PG","ATC_Declined_Notes__c":"ATC Declined Notes","Date_Calculator__c":"Duration of Stay","Room_Nights_Count__c":"Total Room Nights","Travel_Competitor__c":"Travel Competitor","Group_Names__c":"Group Names","Group_Contacts__c":"Group Contacts","Original_Vitals_Link__c":"Original Vitals Link","DCINY_Opportunity__c":"DCINY Opportunity","X2020_COVID_19_Transfer_Performers__c":"2020 COVID-19 Transfer Reg Performers","Total_Receivables__c":"Total Receivables","Total_Payables__c":"Total Payables","Total_Refunded_From_Vendor__c":"Total Refunded from Vendor","X2020_COVID_19_Transfer_VIP__c":"2020 COVID-19 Transfer Reg VIP","Full_Refund_Covid__c":"Full Refund - COVID-19","Previous_Travel_Agent__c":"Previous Travel Agent","Concert_Ticket_Notes__c":"Concert Ticket Notes","Mailing_Address_Line_1__c":"Mailing Address Line 1","Mailing_Address_Line_2__c":"Mailing Address Line 2","Mailing_State_Providence__c":"Mailing State\/Providence","Mailing_Country__c":"Mailing Country","Mailing_Postal_Code__c":"Mailing Postal Code","Director_is_a_VIP__c":"Director is a VIP?","Mailing_City__c":"Mailing City","Performer_Comps_Expected_PG__c":"Performer Comps Expected PG","DCINY_Appearances__c":"DCINY Appearances","Total_Participants_PG__c":"Total Participants PG","WeTravel_Link__c":"WeTravel Link"}}
Role Description
DirectorOther Role Description
ACTS__r.Repertoire__c
Swiss Gospel Singers and Friends (Switzerland)
ACTS__r.Act_Description__c
ArrayRole Description
Composer/ConductorOther Role Description
ACTS__r.Repertoire__c
Tin: Calling All DawnsACTS__r.Act_Description__c
Featuring Distinguished Concerts Orchestra and Distinguished Concerts Singers InternationalRole Description
DCINY Artistic Director and Principal ConductorOther Role Description
ACTS__r.Repertoire__c
Ray: Gospel Mass (40th Anniversary of Composition)ACTS__r.Act_Description__c
Featuring Distinguished Concerts Orchestra and Distinguished Concerts Singers International