Using OR in Conditional Mask for Data Element

Hey all,

 

I've been trying to use this without any success.  Basically I'd like any element to show if peformance code(or description) contains certain strings, and to be blank ('') otherwise.

 

I've tried if(val like 'string1%' or val like 'string2%', 'Output', '')  

 

Is there a syntax that will make this work?

 

Thanks,

David

Parents
  • Something else I’ll throw in here, David, just in case…  conditional formatting in ticket design does not play well with copy/paste.  You’ll have to type the entire thing in.  It’s thrown me before, so I thought I’d put it out there.

     

    Cheers,

    Kathleen

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of David Pitak
    Sent: Thursday, October 16, 2014 4:53 PM
    To: Kathleen Smith
    Subject: [Tessitura Ticketing Forum] Using OR in Conditional Mask for Data Element

     

    Hey all,

     

    I've been trying to use this without any success.  Basically I'd like any element to show if peformance code(or description) contains certain strings, and to be blank ('') otherwise.

     

    I've tried if(val like 'string1%' or val like 'string2%', 'Output', '')  

     

    Is there a syntax that will make this work?

     

    Thanks,

    David




Reply
  • Something else I’ll throw in here, David, just in case…  conditional formatting in ticket design does not play well with copy/paste.  You’ll have to type the entire thing in.  It’s thrown me before, so I thought I’d put it out there.

     

    Cheers,

    Kathleen

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of David Pitak
    Sent: Thursday, October 16, 2014 4:53 PM
    To: Kathleen Smith
    Subject: [Tessitura Ticketing Forum] Using OR in Conditional Mask for Data Element

     

    Hey all,

     

    I've been trying to use this without any success.  Basically I'd like any element to show if peformance code(or description) contains certain strings, and to be blank ('') otherwise.

     

    I've tried if(val like 'string1%' or val like 'string2%', 'Output', '')  

     

    Is there a syntax that will make this work?

     

    Thanks,

    David




Children
No Data