Expression for Custom Header Graphic

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!

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Siobhan Bennetts
Sent: Thursday, January 21, 2010 8:25 AM
To: Teresa Dean
Subject: Re: [Tessitura Technical Forum] RE: Expression for Custom Header Graphic

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!

Siobhan,

I am adding the graphic and then clicking the visible box.

I do not have a column right now.  Am I correct in my thinking that I’m going to have to edit my stored procedure and add some coding for the addition of the graphic, including adding a column in InfoMaker?

I am not a SQL programmer, so this is going to take me a while to figure out.  Thanks again for the helpful information.

Teresa  

Hi

So, you're adding the graphic, then are you clicking on the 'Visible' box and opening the expression screen?

And you do have a column called 'note_type' in your selection that's been brought through to Infomaker?

iobhan

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!