Created
March 15, 2012 16:55
-
-
Save josedaniel/2045261 to your computer and use it in GitHub Desktop.
Consultas SOQL
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//Colegios | |
Select a.creado_en_zambo__c, a.Id, a.Name, a.RecordType.Name from Account a where a.creado_en_zambo__c = false and a.RecordType.Name = 'Institución educativa' | |
//Destinos | |
Select d.creado_en_zambo__c, d.Fecha_1__c, d.Fecha_2__c, d.Fecha_3__c, d.Id, d.Nro_de_dias__c, d.Nro_minimo_de_dias__c, d.Programa_Destino__c from Destino_Alternativo__c d where creado_en_zambo__c = false | |
//Viajes | |
Select c.Colegio__c, c.Destino_definitivo__c, c.Fecha_llegada__c, c.Fecha_salida__c, c.Name, c.Nro_de_Grupos__c, c.RecordTypeId, c.RecordType.Name, c.Status from Campaign c where RecordType.Name = 'Viaje' and c.Status = 'Ganado' |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment