• Replies 15 replies
  • Subscribers 340 subscribers
  • Views 333 views
  • Users 0 members are here
Related

List criteria

Debbie Harland (Past Member)
$organization

Hi All,

Is there a way of increasing the limit in the value field in List Criteria? My user wants to select all the performances in a Production Season, but is getting 'Too Many Items Selected'.

Thanks in advance. Debbie

Parents Reply Children
  • $organization in reply to Martin Keen (Past Member)

    Hi Martin and Mark,

    Yes, that almost works. She can't use Production Season, but she can use Production. However, If she doesn't want to select all the Performances within a Production, there is still a limit on how many can be selected. Back to my point, I think this is a limitation of List Manager, I don't know if Mark can verify that.

    Thanks for replying, any suggestions are welcome and I have tried this out.

    Debbie

  • $organization in reply to Martin Keen (Past Member)

    Thanks to everyone for the suggestions. I'm using some extra views so that the list criteria can be used to select Section, Row and Seat, as well as Performance.

    If I use Production, then the list pulls in everyone who has come to the Performances for the Production on the dates I have asked for, but doesn't filter out those who are not seated in the Row/Seat Number I have specified.

    I've tried other lists using Performance/Production/Production Seatson and there is definitely a limit to how many items can be selected from a drop down. Can you confirm that is the case, Mark?

    Thanks, Debbie

  • $organization in reply to Debbie Harland (Past Member)

    Not the Mark you were asking but...

    There is a limit on the number of items that can be selected in a list (I have hit his in the past) - although is not a fixed number of items as the restriction is due to the size of the generated string of IDs separated by commas.

    If you have created a custom view for the seat and row data one thing you can do is extend that view to restrict the data brought back by performance keyword.
    Setup a specific keyword for this and apply it to relevant performances (this can be done in Season Maintenance) and then add a join to your view to tx_inv_tkw linking on performance number and restricting by the new tkw id.

    Users can also search by that keyword in Season manager so there are ways for them to check that the performance list is correct but should remove a lot of confusion with long lists of performance ids within the list criteria itself. I normally add custom views like this to their own category so that all the criteria that can act on the view is together.

    Mark

  • $organization in reply to Mark Ridley

    Hi Mark, That's a really good idea. Yes, I had figured that the list limit was down to a field length limitation and our Perf Codes are all quite long, so we have hit the limit.

    I'll talk to Sophie about Keywords. I have to co-ordinate with her and not jump in with random codes of my own!!

    Thanks, Debbie