Using same reference

rgates@ttcdas.com

I have 2 BOs. Project and Task. A Project can have many Task objects associated. A Task can have many Task associated. All of this is working fine except for one thing. My query that runs off of the Task BO only will only display the BOs that are relelated to the Task BO. I have no parameters on the query.

Example.

Project ABC
Task 1
Task 1.1
Task 1.1.1
Task 1.1.2
Task 1.2
Task 2
Task 3

What I see in the query results is just:
Task 1.1
Task 1.2
Task 1.1.1
Task 1.1.2

rgates@ttcdas.com

I reposted because I didn't format the information correctly.

Project ABC
-Task 1
--Task 1.1
----Task 1.1.1
----Task 1.1.2
--Task 1.2
-Task 2
-Task 3

aware_support

How does your query look like?

rgates@ttcdas.com

SELECT Task.Type,Task.EndDate,Task.BudgetedHours,Task.JRTask,Task.PercentComplete,Task.StartDate,Task.ActualHours,Task.ProjectTitle,Task.TaskTitle,Task.TaskLevel FROM ENGPROJMANAGEMENT_TASK AS Task INNER JOIN ENGPROJMANAGEMENT_TASK_REF AS ER_Task_Task_ChildTask ON Task.ID=ER_Task_Task_ChildTask.RID AND ER_Task_Task_ChildTask.FIELD_NAME='ChildTask' INNER JOIN ENGPROJMANAGEMENT_TASK AS Task_ParentTask ON ER_Task_Task_ChildTask.ID=Task_ParentTask.ID ORDER BY Task_ParentTask.TaskTitle,Task.TaskLevel,Task.JRTask

bwienhoven

Try a real query without parameters like:
FIND ALL Task
this will definitely work.
the query is simply outputting what you are asking it to output.

good luck

aware_support

I meant in the rule language format, not raw SQL.

rgates@ttcdas.com

FIND ALL Task ORDER BY Task.ParentTaskTitle,Task.TaskLevel,Task.JRTask

aware_support

Try removing ORDER BY and see if it makes the difference.