Complex datasource issue in Dynamics AX

Question

I have a grid that displays lines from a table. Now, I have these two requirements:

1. Show only the lines that contains values in the "hour" fields. The "hour" field is an array type.
2. Show the lines from a project and its subproject

My problem is this: to meet requirement #1, I need to use a select statement in my datasource since I cannot access array value using QueryBuildDataSource (this is a known limitation in Dynamics AX).

But to meet requirements #2 I need to have two "exists join", and this is not possible in Dynamics AX. For example the following code would not work:

select from table where
exists join tableChild where projectId = MyProjectId OR
exists join tableChild where parentProjectId = MyProjectId

How would someone address this issue?

Answer 1

You can use array values in query ranges providing field IDs using fieldID2Ext function.

You can build view and apply confitions on top of it.