AnsweredAssumed Answered

Filtered dropdown list question

Question asked by Peter_P on Jan 14, 2014
Latest reply on Jan 14, 2014 by Dave

Hello,

I have created a DB table that holds some data and a field where the IDEA ID is stored as MATRIX_CR_ID. I also created a query, which should deliver the records that match the current idea:

SELECT   M.MATRIX_ID, M.MATRIX_NAME, M.MATRIX_CR_ID
FROM     ODF_CA_Z_KB_CR_HELPER M
WHERE    (matrix_cr_id = @where:param:xml:string:/data/id/@value@)
AND      @FILTER@
HAVING   @HAVING_FILTER@

I added a new field to the IDEA object that is a singe select based on the query and placed it onto the edit view, and yet it does not show any data. What did I do wrong?

Outcomes