I want to add our Note prompts field #3 to report fields on detail report patameters. When I export membership report, I like to see membership note colume? What is table name for this field? eg. name.MEMBER_TYPE,
If you want to add note field value into your report for ;field #3 prompt' you need to make a join with name_note table with id also include where clause for purpose field (Prompt text)
for example:
select NOTE, * from name inner join name_note on name.id = name_note.id where purpose = 'Note prompts field #3 (text)'
Hi, If you want to add note
Hi,
If you want to add note field value into your report for ;field #3 prompt' you need to make a join with name_note table with id also include where clause for purpose field (Prompt text)
for example:
select NOTE, * from name inner join name_note on name.id = name_note.id where purpose = 'Note prompts field #3 (text)'
Balaji