<myweb createdb="true" dbname="dotproject">
	<views>
	    <view name="querytask" path="/jsp/project/task/querytask.jsp"/>
	    <view name="taskinfo" path="/jsp/project/task/taskinfo.jsp"/>

	</views>





	<controls>	
	
	<control name="taskinfo">
			<action name="SysType"><input name="typename" value= "taskpriority" /></action>
			<action name="SysType"><input name="typename" value= "yesno" /></action>			
			<action name="Select">
				<input name="sql" value="select CONCAT(user_last_name,user_first_name),user_id from users "/>
				<input name="name" value="user"/>			
			</action>

			<action name="Query">
				<input name="sql" value="select * from tasks,projects "/>
				<input name="where" value="where task_project=project_id" />
				<input name="name" value="res"/>
			    <input name="resulttype" value="single"/>			    							
			</action>	
			
			<action name="Query">
				<input name="sql" value="select * from files "/>
				<input name="where" value=""/>
				<input name="prestr" value="query1"/>
				<input name="query1.file_task.equ.int" value="!custom!query.task_id.equ.int" />
				<input name="name" value="rsfile"/>
			    <input name="resulttype" value="mul"/>			    							
			</action>	
			
			<action name="Query">
				<input name="sql" value="select * from user_tasks,users  "/>
				<input name="where" value="where user_tasks.user_id=users.user_id"/>
				<input name="prestr" value="query2"/>
				<input name="query2.task_id.equ.int" value="!custom!query.task_id.equ.int" />
				<input name="name" value="rsuser"/>
			    <input name="resulttype" value="mul"/>			    							
			</action>							
						
			<action name="Forward">
				<input name="view" value="taskinfo"/>
			</action>				
	</control>			
		
		<control name="querytask">
			<action name="Select">
				<input name="sql" value="select avg(task_percent_complete),task_project as percent from tasks group by task_project"/>
				<input name="name" value="projectcomplete"/>			
			</action>		
	
			<action name="Select">
				<input name="sql" value="select CONCAT(user_last_name,user_first_name),user_id from users "/>
				<input name="name" value="user"/>			
			</action>		
			<action name="Query">
				<input name="sql" value="select distinct tasks.task_id ,tasks.* ,projects.* from tasks,user_tasks,projects "/>
				<input name="where" value="where tasks.task_id=user_tasks.task_id and task_project=project_id "/>
				<input name="order" value="order by task_project"/>								
				<input name="name" value="res"/>
				<input name="sucess" value="querytask"/>
				<input name="fault" value="querytask"/>				
			</action>
		</control>
	
</controls>
</myweb>