Pulling a list based on Perf code

Here is the syntax in full (slightly amended so it shouldn’t throw an error)

 

Select Distinct a.customer_no

 From t_customer a (NOLOCK)

JOIN lvs_tck_hist e (NOLOCK) ON a.customer_no = e.customer_no

 Where  IsNull(a.inactive, 1) = 1

 AND e.performance_name in ('showcode', 'showcode', 'showcode')

 

Replace the italics with your showcodes and this should work (although keep the apostrophes in)

 

 

 

I tried this and received a syntax error – would you be able to clarify where exactly the spaces and punctuation should be placed?  This type of list certainly meets my needs!

 

Jennifer

 

 

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!

Mae’r ohebiaeth hon at ddefnydd y derbynnydd/derbynyddion bwriadedig yn unig. Os nad chi yw’r derbynnydd/derbynyddion bwriadedig, nodwch fod dosbarthu, copïo neu ddefnyddio’r ohebiaeth hon neu’r wybodaeth ynddi mewn unrhyw ffordd wedi ei wahardd yn gyfangwbl a gall fod yn anghyfreithlon. Os ydych wedi derbyn yr ohebiaeth hon trwy gamgymeriad a fyddech cystal â’i ddychwelyd i’r anfonwr. Yn yr achos hwn byddem yn ddiolchgar pe gallech hefyd anfon yr ohebiaeth at administrator@wmc.org.uk ac yna dileu’r e-bost a dinistrio unrhyw gopïau ohono. Cwmni cyfyngedig dan warrant, cofrestrwyd yng Nghymru a Lloegr. Rhif Cwmni 3221924. Rhif Elusen 1060458. Swyddfa gofrestredig: Plas Bute, Bae Caerdydd, Caerdydd CF10 3AL

This communication is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender. In this event would be grateful if you would also copy the communication to administrator@wmc.org.uk then delete the email and destroy any copies of it. A company limited by guarantee, registered in England and Wales. Company number 3221924. Charity number 1060458. Registered office: Bute Place, Cardiff Bay, Cardiff CF10 5AL

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!

Here is the syntax in full (slightly amended so it shouldn’t throw an error)

 

Select Distinct a.customer_no

 From t_customer a (NOLOCK)

JOIN lvs_tck_hist e (NOLOCK) ON a.customer_no = e.customer_no

 Where  IsNull(a.inactive, 1) = 1

 AND e.performance_name in ('showcode', 'showcode', 'showcode')

 

Replace the italics with your showcodes and this should work (although keep the apostrophes in)

 

 

 

I tried this and received a syntax error – would you be able to clarify where exactly the spaces and punctuation should be placed?  This type of list certainly meets my needs!

 

Jennifer

 

 

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!

Mae’r ohebiaeth hon at ddefnydd y derbynnydd/derbynyddion bwriadedig yn unig. Os nad chi yw’r derbynnydd/derbynyddion bwriadedig, nodwch fod dosbarthu, copïo neu ddefnyddio’r ohebiaeth hon neu’r wybodaeth ynddi mewn unrhyw ffordd wedi ei wahardd yn gyfangwbl a gall fod yn anghyfreithlon. Os ydych wedi derbyn yr ohebiaeth hon trwy gamgymeriad a fyddech cystal â’i ddychwelyd i’r anfonwr. Yn yr achos hwn byddem yn ddiolchgar pe gallech hefyd anfon yr ohebiaeth at administrator@wmc.org.uk ac yna dileu’r e-bost a dinistrio unrhyw gopïau ohono. Cwmni cyfyngedig dan warrant, cofrestrwyd yng Nghymru a Lloegr. Rhif Cwmni 3221924. Rhif Elusen 1060458. Swyddfa gofrestredig: Plas Bute, Bae Caerdydd, Caerdydd CF10 3AL

This communication is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender. In this event would be grateful if you would also copy the communication to administrator@wmc.org.uk then delete the email and destroy any copies of it. A company limited by guarantee, registered in England and Wales. Company number 3221924. Charity number 1060458. Registered office: Bute Place, Cardiff Bay, Cardiff CF10 5AL

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!