Expression for Custom Header Graphic

I'm trying to test out adding a warning graphic to my header in Tessitura.  Working on reports in Infomaker is fairly new to me and I have very basic knowledge of coding.  The problem I'm having is that I can't figure out what expression to use if I want the graphic to appear if there is a specific note type in a constituent record.  I'm following the documentation for custom headers and feel that I have probably done most everything else correctly.  But I won't know until I can get this expression figured out.  I thought it might be something like - If(note_type='28', 1, 0).  This is obviously not correct.  I'm afraid it's going to be more of a complicated expression, but I have no idea of what.  Can anyone point me in the direction I should be going instead? 

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

 

Siobhan

This is helpful in that is appears my thought process is correct.  The problem is that not matter what I do, when I click the verify button I get the message:  Expecting TRUE/FALSE Expression.  Is there anything I need to do other than insert the graphic and add my expression?  One thing that has crossed my mind is that I might need to add a column for this object, but I don’t know what type I would assign to it.

 

Thanks for the help!!

 

Teresa  

 

 

Hi Teresa

We have a few, for example:

To display an icon if a customer has a certain attribute, we use: if(attribute=1,1,0)

To display an icon if a customer hasn't been asked the data protection question we use: if( last_privacy_ask < dataprot OR isNull(last_privacy_ask), 1,0)

To display an icon if a customer has no email address on their account, we use: if (email_count>0 OR no_email_add=1,0,1)

And finally, for a heading on a specific account we use: if(customer_no=20108488,1,0)

 

I hope that's helpful!

Siobhan

I'm trying to test out adding a warning graphic to my header in Tessitura.  Working on reports in Infomaker is fairly new to me and I have very basic knowledge of coding.  The problem I'm having is that I can't figure out what expression to use if I want the graphic to appear if there is a specific note type in a constituent record.  I'm following the documentation for custom headers and feel that I have probably done most everything else correctly.  But I won't know until I can get this expression figured out.  I thought it might be something like - If(note_type='28', 1, 0).  This is obviously not correct.  I'm afraid it's going to be more of a complicated expression, but I have no idea of what.  Can anyone point me in the direction I should be going instead? 

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

 

is it possible that you have spaces between your , 1  and  , 0?

 

If(note_type='28', 1, 0). 

 

 

 

 

 

Siobhan

This is helpful in that is appears my thought process is correct.  The problem is that not matter what I do, when I click the verify button I get the message:  Expecting TRUE/FALSE Expression.  Is there anything I need to do other than insert the graphic and add my expression?  One thing that has crossed my mind is that I might need to add a column for this object, but I don’t know what type I would assign to it.

 

Thanks for the help!!

 

Teresa  

 

 

Hi Teresa

We have a few, for example:

To display an icon if a customer has a certain attribute, we use: if(attribute=1,1,0)

To display an icon if a customer hasn't been asked the data protection question we use: if( last_privacy_ask < dataprot OR isNull(last_privacy_ask), 1,0)

To display an icon if a customer has no email address on their account, we use: if (email_count>0 OR no_email_add=1,0,1)

And finally, for a heading on a specific account we use: if(customer_no=20108488,1,0)

 

I hope that's helpful!

Siobhan

I'm trying to test out adding a warning graphic to my header in Tessitura.  Working on reports in Infomaker is fairly new to me and I have very basic knowledge of coding.  The problem I'm having is that I can't figure out what expression to use if I want the graphic to appear if there is a specific note type in a constituent record.  I'm following the documentation for custom headers and feel that I have probably done most everything else correctly.  But I won't know until I can get this expression figured out.  I thought it might be something like - If(note_type='28', 1, 0).  This is obviously not correct.  I'm afraid it's going to be more of a complicated expression, but I have no idea of what.  Can anyone point me in the direction I should be going instead? 

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

 

is it possible that you have spaces between your , 1  and  , 0?

 

If(note_type='28', 1, 0). 

 

 

 

 

 

Siobhan

This is helpful in that is appears my thought process is correct.  The problem is that not matter what I do, when I click the verify button I get the message:  Expecting TRUE/FALSE Expression.  Is there anything I need to do other than insert the graphic and add my expression?  One thing that has crossed my mind is that I might need to add a column for this object, but I don’t know what type I would assign to it.

 

Thanks for the help!!

 

Teresa  

 

 

Hi Teresa

We have a few, for example:

To display an icon if a customer has a certain attribute, we use: if(attribute=1,1,0)

To display an icon if a customer hasn't been asked the data protection question we use: if( last_privacy_ask < dataprot OR isNull(last_privacy_ask), 1,0)

To display an icon if a customer has no email address on their account, we use: if (email_count>0 OR no_email_add=1,0,1)

And finally, for a heading on a specific account we use: if(customer_no=20108488,1,0)

 

I hope that's helpful!

Siobhan

I'm trying to test out adding a warning graphic to my header in Tessitura.  Working on reports in Infomaker is fairly new to me and I have very basic knowledge of coding.  The problem I'm having is that I can't figure out what expression to use if I want the graphic to appear if there is a specific note type in a constituent record.  I'm following the documentation for custom headers and feel that I have probably done most everything else correctly.  But I won't know until I can get this expression figured out.  I thought it might be something like - If(note_type='28', 1, 0).  This is obviously not correct.  I'm afraid it's going to be more of a complicated expression, but I have no idea of what.  Can anyone point me in the direction I should be going instead? 

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

 

If the note_type column is a number (probably datatype of long), you are using a string qualifier in the expression.

 

Try this and see if it works:

If(note_type=28, 1, 0)

 

Additional spaces are always ignored.

 

 

 

is it possible that you have spaces between your , 1  and  , 0?

 

If(note_type='28', 1, 0). 

 

 

 

 

 

Siobhan

This is helpful in that is appears my thought process is correct.  The problem is that not matter what I do, when I click the verify button I get the message:  Expecting TRUE/FALSE Expression.  Is there anything I need to do other than insert the graphic and add my expression?  One thing that has crossed my mind is that I might need to add a column for this object, but I don’t know what type I would assign to it.

 

Thanks for the help!!

 

Teresa  

 

 

Hi Teresa

We have a few, for example:

To display an icon if a customer has a certain attribute, we use: if(attribute=1,1,0)

To display an icon if a customer hasn't been asked the data protection question we use: if( last_privacy_ask < dataprot OR isNull(last_privacy_ask), 1,0)

To display an icon if a customer has no email address on their account, we use: if (email_count>0 OR no_email_add=1,0,1)

And finally, for a heading on a specific account we use: if(customer_no=20108488,1,0)

 

I hope that's helpful!

Siobhan

I'm trying to test out adding a warning graphic to my header in Tessitura.  Working on reports in Infomaker is fairly new to me and I have very basic knowledge of coding.  The problem I'm having is that I can't figure out what expression to use if I want the graphic to appear if there is a specific note type in a constituent record.  I'm following the documentation for custom headers and feel that I have probably done most everything else correctly.  But I won't know until I can get this expression figured out.  I thought it might be something like - If(note_type='28', 1, 0).  This is obviously not correct.  I'm afraid it's going to be more of a complicated expression, but I have no idea of what.  Can anyone point me in the direction I should be going instead? 

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!