Sort/Filter EXEC_SP results

Aware2014

I have a query that uses EXEC_SP. It returns the information fine no problems at all. However the standard column sorting and filtering functions do not work.

How might I get these columns to be able to sort/filter?

aware_support

You cannot use built-in automatic sorting and filtering capabilities when you use stored procedures. Aware IM doesn't know what your query is, so it cannot modify it to implement sorting and filtering.

So you need to implement sorting and filtering yourself. You will have to define separate stored procedures that implement this using parameters for sorting and filtering. Then you need to invoke these stored procedures from your main query as panel operations, for example. The operations can be implemented as a process that collects parameters of sorting and filtering and then runs the appropriate stored procedure and displays the results.

Aware2014

Thanks for the clarification, Vlad.

Having to build-in sort & filtering will not be ideal, so is there a way to implement the following query? I cannot seem to get any standard query, rule query, or SQL query to work.

Note: There is a one-to-many relationship setup in the BO (one Question can have many Responses).

SELECT Questions.* FROM MY_APPDB_QUESTIONS AS Questions
LEFT JOIN MY_APPDB_RESPONSES AS Responses
ON Questions.ID=Responses.QuestionsLink_RID
WHERE (Responses.QuestionID IS NULL)

aware_support

What are you trying to find at the high level? Responses for a particular question? Questions for particular responses?

Aware2014

I am trying to display a grid that shows the questions where there is no corresponding responses. The user then knows which questions need to be answered.

Separately I am trying to display a grid that shows questions that have a response so they know the question has been answered and they can sort by the date they have been answered.

Thanks for your help.

aware_support

For answers with no responses:
FIND Question WHERE COUNT Response (WHERE Response.QuestionLink = Question) = 0

For answers with responses:
FIND Question WHERE COUNT Response (WHERE Response.QuestionLink = Question) > 0

Aware2014

It works!!! Thank you very much!!

Jaymer

aware_support wrote
For answers with no responses:
FIND Question WHERE COUNT Response (WHERE Response.QuestionLink = Question) = 0

For answers with responses:
FIND Question WHERE COUNT Response (WHERE Response.QuestionLink = Question) > 0

Friggin' VOODOO !!!