Drop down list ignores stored procedure defined for query

ddumas

I have a BO ProjectResource that has an attribute Resource of Type Resource, defined with Presentation as a dropdown. I have configured he dropdown to use a query. The query calls a SQL Server stored procedure.

At runtime, the stored procedure is being ignored.

This first shot shows the expected results running the query by hand in SQL:

This next one shows the query (shows the code) that is called in the presentation options for ProjectResource.Resource:

This next one shows the query (look at the filter) that is called in the presentation options for ProjectResource.Resource:

This last one shows the runtime results, which do not match the manual query results form the top screenshot:

So, I am confident that AWAREIM is ignoring the query selection defined in the drop down for ProjectResource.Resource

Any ideas?

aware_support

This will be fixed in 5.8

Aware2014

Was this fixed?

Reason for asking is that in v5.8 when attempting to use EXEC_SP in a query now results in a message stating that a query must start with select.

Aware2014

Please disregard last post. I realized that I was putting the EXEC_SP in the SQL form. Late night...