[connor]

Greetings,

I'm trying to convert following query to a view


$query = 'SELECT
f.id,
f.top_pos,
f.left_pos,
f.height,
f.width,
f.type,
CASE WHEN f.required = \'t\' THEN \'true\' ELSE \'false\' END as required,
f.class_id_fk,
f.visible,
i.value,
i.field_id_fk,
i.pdf_user_id_fk
FROM
pdf_field f
LEFT JOIN
pdf_input i
ON
(i.field_id_fk = f.id AND i.pdf_user_id_fk = ?)
WHERE
f.pdf_id_fk = ?
AND
f.page_num = ?
AND
f.visible = \'t\'';


My current view looks like this


CREATE OR REPLACE VIEW fields_view AS
SELECT
f.id,
f.top_pos,
f.left_pos,
f.height,
f.width,
f.type,
CASE WHEN f.required = 't' THEN 'true' ELSE 'false' END as required,
f.class_id_fk,
f.pdf_id_fk,
f.page_num,
f.visible,
i.value,
i.field_id_fk,
i.pdf_user_id_fk
FROM
pdf_field f
LEFT JOIN
pdf_input i
ON
(i.field_id_fk = f.id)

and I'm not having any luck with the following

(i.field_id_fk = f.id AND i.pdf_user_id_fk = ?)

How do I pass this parameter to a view????


Thanks

Connor