io.vertigo.orchestra.services.definition.activityDAO.ksp Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of vertigo-orchestra Show documentation
There is a newer version: 4.2.0
package io.vertigo.orchestra.dao.definition




create Task TkGetFirstActivityByProcess {
	storeName : "orchestra"
    className : "io.vertigo.basics.task.TaskEngineSelect"
        request : "
        
        	select act.* 
                from O_ACTIVITY act 
                inner join(
                            select  activity.PRO_ID as PRO_ID,
                                   min(activity.NUMBER) as NUMBER_MIN
                            from O_ACTIVITY activity
                            
                            where activity.PRO_ID = #proId#
                            group by activity.PRO_ID
                        ) actMin on (act.PRO_ID = actMin.PRO_ID and act.NUMBER = actMin.NUMBER_MIN)
                 where 1=1
        	
			"
	in proId	 	{domain : DoOIdentifiant 		cardinality: "1" 	}
	out dtOActivity	 	{domain : DoDtOActivity 		cardinality: "1" 	}
}


create Task TkGetNextActivityByActId {
	storeName : "orchestra"
    className : "io.vertigo.basics.task.TaskEngineSelect"
        request : "
        	select act.* 
                from O_ACTIVITY act 
                inner join(
                            select activity.PRO_ID as PRO_ID,
                                   min(activity.NUMBER) as NUMBER_MIN
                            from O_ACTIVITY activity
                            join O_ACTIVITY prevActivity on prevActivity.ACT_ID = #actId#
                            where activity.NUMBER > prevActivity.NUMBER 
                           
                                and activity.PRO_ID = prevActivity.PRO_ID
                            group by activity.PRO_ID
                        ) actMin on (act.PRO_ID = actMin.PRO_ID and act.NUMBER = actMin.NUMBER_MIN)
                 where 1=1
        	
        	
			"
		in actId	 	{domain : DoOIdentifiant 		cardinality: "1" 	}
		out dtOActivity	 	{domain : DoDtOActivity		cardinality: "?" 	}
}


create Task TkGetActivitiesByProId {
	storeName : "orchestra"
    className : "io.vertigo.basics.task.TaskEngineSelect"
        request : "
        
        	select act.* 
                from O_ACTIVITY act 
                where act.PRO_ID = #proId#
        	
			"
	in proId	 	{domain : DoOIdentifiant 		cardinality: "1" 	}
	out dtOActivities	 	{domain : DoDtOActivity 		cardinality: "*" 	}
}


create Task TkGetAllActivitiesInActiveProcesses {
	storeName : "orchestra"
    className : "io.vertigo.basics.task.TaskEngineSelect"
        request : "
        
        	select act.* 
                from O_ACTIVITY act 
                join O_PROCESS pro on pro.PRO_ID = act.PRO_ID
                where pro.ACTIVE_VERSION is true
        	
			"
	out dtOActivities	 	{domain : DoDtOActivity 		cardinality: "*" 	}
}