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@)
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?