Forum Discussion

didonato's avatar
didonato
Creator II
9 years ago

Notification (E-Message Blank)

Why is it when I leave a field blank in my form it generates a email with just labels and no data, but If I populate all the fields that are in the email form, it works fine. Example of my "Email Message" ========This is in the Body Html of my "Email Message"====================== <font size="+0" style="font-variant:small-caps">Program:</font> ${Item[@type="Program"]/name} <br/> <font size="+0" style="font-variant:small-caps">Customer:</font> ${Item[@type="Customer"]/name} <br/> ==========This is in the Query String of my "Email Message"============================== <Item type="Program" action="get" select = "name"> <id condition="in"> (SELECT program FROM innovator.Express_ECO WHERE (id = '${Item/@id}')) </id> </Item> <Item type="Customer" action="get" select = "name"> <id condition="in"> (SELECT customer FROM innovator.Express_ECO WHERE (id = '${Item/@id}')) </id> </Item>  

2 Replies

  • Zahar_Chernov's avatar
    Zahar_Chernov
    Creator II
    9 years ago
    Try to change you qry to:
    <Item type="${Item/@type}" id="${Item/@id}" action="get" select="customer(name),program(name)"/>
    and in the body something like:
    ${Item/customer/Item/name} ${Item/program/Item/name}
      Keep in mind if you have more than one Item in Query you need to point to with line (for first line no need) you refer as ${Item  for example if this is your query:
    <Item type="Activity" id="${Item/ActivityId}" action="get" select="name,message"/> <Item type="${Item/@type}" id="${Item/@id}" action="get" select="customer(name),program(name)"/>
    Your body will be:
    ${Item[2]/customer/Item/name} ${Item[2]/program/Item/name}