Pulling a list based on Perf code

You could do it manually using the “Manual Edit” function in list manger – this will get everything in one list.

Select new list and  create a list using your first performance code.

When the criteria is done, select “Manual Edit” and find the line where it starts “AND e.performance_name = '[performance code 1]'”. At the end of this string just keep writing “ or e.performance_name = ‘[perf code]’ or e.performance_name = ‘[perf code]’ or……” for all your performance codes and this will get all the info you need in one list (although its less flexible to use if you need to alter the list at a later date).

You can check if you’re doing it right by clicking the “validate query” button.

It’s the long way around, but you could also create a list for each perf code, and then create a separate list with a criteria set of:

List IN (select all the lists you created from the drop-down)

Hope that makes sense.

T

I wonder if anyone can help... I need to pull a list of multiple perf codes but can't make it return anything but 0 if i include more than one. I need to pull it in the same way as I would using ticketing production.

Any help would be greatly appreciated!

Thanks, Dawn

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing 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 Marketing Forum. You may reply to this message to post to the Marketing 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!

You could do it manually using the “Manual Edit” function in list manger – this will get everything in one list.

Select new list and  create a list using your first performance code.

When the criteria is done, select “Manual Edit” and find the line where it starts “AND e.performance_name = '[performance code 1]'”. At the end of this string just keep writing “ or e.performance_name = ‘[perf code]’ or e.performance_name = ‘[perf code]’ or……” for all your performance codes and this will get all the info you need in one list (although its less flexible to use if you need to alter the list at a later date).

You can check if you’re doing it right by clicking the “validate query” button.

It’s the long way around, but you could also create a list for each perf code, and then create a separate list with a criteria set of:

List IN (select all the lists you created from the drop-down)

Hope that makes sense.

T

I wonder if anyone can help... I need to pull a list of multiple perf codes but can't make it return anything but 0 if i include more than one. I need to pull it in the same way as I would using ticketing production.

Any help would be greatly appreciated!

Thanks, Dawn

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing 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 Marketing Forum. You may reply to this message to post to the Marketing 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!