I have created a business object called Project_task_schedule. One of the attributes is called BaseLineNextTask which is an object reference to itself.

I have 2 problems

To allow addition of business entities to this attribute, I clicked on the Presentation to navigate into the Reference element window. I then had the "Generate "Add" button' ticked and then clicked on the settings to get into the "Add References" window. I then selected the "Use Default Implementation" radio button, to edit the Custom query as follows:

FIND Project_task_schedule WHERE Project_task_schedule IN ThisProject_task_schedule.BaseLineNextTask

The query returns correctly all the tuples in the attribute BaseLineNextTask.

Next I changed the query so as to complement it and get tuples other than the ones referred by BaseLine NextTask by introducing a negation "NOT" as follows:

FIND Project_task_schedule WHERE NOT(Project_task_schedule IN ThisProject_task_schedule.BaseLineNextTask)

I would have expected the query to return other tuples. However the query results were empty.

I find the following error in the Tomcat log output:

Web server returned error: Internal error. Element NOT(Project_task_schedule IN ThisProject_task_schedule.BaseLineNextTask) in query condition NOT(Project_task_schedule IN ThisProject_task_schedule.BaseLineNextTask) of query FIND Project_task_schedule WHERE NOT(Project_task_schedule IN ThisProject_task_schedule.BaseLineNextTask) cannot be converted to the currently installed version of SQL

Is there a limitation?

I thought of trying out directly the SQL by using the SQL form instead of the rule form and create my own SQL. However I find that SQL does not get saved. Whenever I exit from the query and come back I only find the following statement in the SQL form:

SELECT Project_task_schedule.* FROM PROJECT_MANAGEMENT_PROJECT_TASK_SCHEDULE AS Project_task_schedule

Is there a problem that the user created SQL statements do not get saved?