• Replies 1 reply
  • Subscribers 412 subscribers
  • Views 60 views
  • Users 0 members are here
Related

Program names in an output set

Joshua Forward
$organization

Hi there,

I'd like to include program name in an output set so it can be alongside their recent donation amount etc but can't seem to get it to work. I used the Output Set Cookbook and followed the instructions, but it says that the element requires parameter values, even though I'm fairly sure I put it in correctly.

Does anyone have any advice on this?

Thanks,

 

Josh

  • $organization

    Hi, Joshua:


    Because it is possible to have an infinite number of programs, you need to put in a parameter for the specific program (from the T_PROGRAM system table) that you're selecting. To hard-wire the program into the query element, if you are concerned with one program only, you can put the program number in the "where" field.


    The following query element works for me:

    • data_select: !.cust_pname
    • data_from: vxs_cust_program
    • data_where: program_no = 23
    • **Make sure the single row box is checked.**

    ("23" refers to the id of the program I want in my version of the T_PROGRAM table. You'll need to replace that with the id value from your version of that table.)


    Lucie