/*List<vlocity_cmt__OrchestrationDependencyDefinition__c> dependencies = [SELECT CreatedById,CreatedDate,Id,IsDeleted,LastModifiedById,LastModifiedDate,Name,SystemModstamp,vlocity_cmt__DependencyItemDefinitionId__c,vlocity_cmt__DependencyPlanDefinitionId__c,vlocity_cmt__DependencyType__c,vlocity_cmt__GlobalKey__c,vlocity_cmt__OrchestrationItemDefinitionId__c,vlocity_cmt__OrchestrationPlanDefinition__c,vlocity_cmt__Scope__c FROM vlocity_cmt__OrchestrationDependencyDefinition__c ORDER BY CreatedDate DESC NULLS FIRST];
String aux;

for(vlocity_cmt__OrchestrationDependencyDefinition__c data : dependencies){

	aux = data.vlocity_cmt__OrchestrationItemDefinitionId__c + ': ';

	for(vlocity_cmt__OrchestrationDependencyDefinition__c data2 : dependencies){

		if(data.vlocity_cmt__OrchestrationItemDefinitionId__c == data2.vlocity_cmt__DependencyItemDefinitionId__c){
			aux = aux + ' ' + data2.vlocity_cmt__OrchestrationItemDefinitionId__c;
		}
	}
system.debug(data.Id + ': ' + aux);
}*/




/*HowTo:
Levanto todos los OrchItems en una lista
Query para agarrar todos los datos que dependen de ese id
Query para agarrar todos de los que depende
*/

List<vlocity_cmt__OrchestrationItemDefinition__c> orchItems = [SELECT Id,vlocity_cmt__AsyncResponseVlocityDataRaptorBundleId__c,vlocity_cmt__AttributesEncodingStyle__c,vlocity_cmt__AutoTaskParameters__c,vlocity_cmt__ConditionData__c,vlocity_cmt__Condition__c,vlocity_cmt__CustomTaskExecutionURL__c,vlocity_cmt__ErrorQueueId__c,vlocity_cmt__EventConditionData__c,vlocity_cmt__GlobalKey__c,vlocity_cmt__IsPointOfNoReturn__c,vlocity_cmt__IsSkipBranch__c,vlocity_cmt__IsUseCustomCallbackURI__c,vlocity_cmt__itemImplementationId__c,vlocity_cmt__ItemLength__c,vlocity_cmt__JeopardySafetyIntervalUnit__c,vlocity_cmt__JeopardySafetyInterval__c,vlocity_cmt__Key__c,vlocity_cmt__LengthUnit__c,vlocity_cmt__manualQueueId__c,vlocity_cmt__ManualTaskExecutionMode__c,vlocity_cmt__NumberOfRetries__c,vlocity_cmt__OrchestrationPlanDefinitionId__c,vlocity_cmt__OrderItemsNodeName__c,vlocity_cmt__ProcessAfter__c,vlocity_cmt__QueueType__c,vlocity_cmt__RequestItemsEncodingStyle__c,vlocity_cmt__RequestItemsVlocityDataRaptorBundleId__c,vlocity_cmt__ResponseAttrsVlocityDataRaptorBundleId__c,vlocity_cmt__ResponseItemsVlocityDataRaptorBundleId__c,vlocity_cmt__ResponseVlocityDataRaptorBundleId__c,vlocity_cmt__RetryPolicy__c,vlocity_cmt__RollbackGroup__c,vlocity_cmt__RollBackPlanDefinitionId__c,vlocity_cmt__Scope__c,vlocity_cmt__SubPlanDefinitionId__c,vlocity_cmt__SubPlanDefinition__c,vlocity_cmt__SystemId__c,vlocity_cmt__SystemInterfaceId__c,vlocity_cmt__TimeoutMs__c,vlocity_cmt__VlocityDataRaptorBundleId__c FROM vlocity_cmt__OrchestrationItemDefinition__c];
List<vlocity_cmt__OrchestrationDependencyDefinition__c> depen = [SELECT CreatedById,CreatedDate,Id,IsDeleted,LastModifiedById,LastModifiedDate,Name,SystemModstamp,vlocity_cmt__DependencyItemDefinitionId__c,vlocity_cmt__DependencyPlanDefinitionId__c,vlocity_cmt__DependencyType__c,vlocity_cmt__GlobalKey__c,vlocity_cmt__OrchestrationItemDefinitionId__c,vlocity_cmt__OrchestrationPlanDefinition__c,vlocity_cmt__Scope__c FROM vlocity_cmt__OrchestrationDependencyDefinition__c];
String aux,aux2;
Map<String,String> data = new Map<String, String>();

for(vlocity_cmt__OrchestrationItemDefinition__c orchItem : orchItems) {

aux = '';
aux2 = '';

	for(vlocity_cmt__OrchestrationDependencyDefinition__c depc : depen) {

		if(orchItem.Id == depc.vlocity_cmt__DependencyItemDefinitionId__c){

			aux = aux + depc.vlocity_cmt__OrchestrationItemDefinitionId__c + ' < ';

		}
		if (orchItem.Id == depc.vlocity_cmt__OrchestrationItemDefinitionId__c){

			aux2 = aux2 + depc.vlocity_cmt__DependencyItemDefinitionId__c + ' > ';
		}

	}



aux = aux + ' - ' + aux2;
data.put(orchItem.Id, aux);
}

Integer i;
i = 0;
/*   for(String key : data.keySet()){
        System.debug(key + ': ' + data.get(key));
        i= i + 1;
    }*/

System.debug('Iterations: ' + i);
System.debug('OrchItems: ' + orchItems.size());

// Retorna ID de item: Dependiente -- Depende


List<vlocity_cmt__OrchestrationPlanDefinition__c> orchPlans = [SELECT CreatedById,CreatedDate,Id,IsDeleted,LastModifiedById,LastModifiedDate,LastReferencedDate,LastViewedDate,Name,OwnerId,SystemModstamp,vlocity_cmt__GlobalKey__c,vlocity_cmt__IsSchedulingEnabled__c,vlocity_cmt__SchedulingExpirationIntervalSeconds__c,vlocity_cmt__Scope__c,vlocity_cmt__ShowOrder__c FROM vlocity_cmt__OrchestrationPlanDefinition__c];

Map<String,String> planDep = New Map<String,String>();


for(vlocity_cmt__OrchestrationPlanDefinition__c orchPlan : orchPlans){
	aux = '';
	for(vlocity_cmt__OrchestrationItemDefinition__c orchItem : orchItems) {

		if(orchItem.vlocity_cmt__OrchestrationPlanDefinitionId__c == orchPlan.Id) {
			aux = aux + ' ' + orchItem.Id;
		}

	}

planDep.put(orchPlan.Id, aux);

}
i = 0;
system.debug('Continuacion de planes de orch');
   for(String key : planDep.keySet()){
        System.debug(key + ': ' + planDep.get(key));
        i= i + 1;
    }

15616