Tickets query pulls in more results when a name display criteria is added

When using a Tickets source view query to find price types associated with event registrants, one may notice that adding any constituent name field to the Results fields to display area triggers the results count to increase to more than the capacity of the event. 
This can occur when an incorrect source view is used. When using an ad-hoc query to find price types associated with event registrants, use a Sales Order source view instead of a Tickets source view. 

The below criteria will produce a list of registrants with their associated price types in a Sales Order source view query.

1. Add the following nodes to the Include records where area:
    a. Sales Order Item\Sales Order Item Ticket\Program Events\Event record is equal to [Insert your event here]
    b. and Sales Order Item\Sales Order Item Ticket\Sales Order Item Ticket Registrant\Registrant\Status is equal to Registered
2. Add the following nodes to the Results fields to display area:
    a. Sales Order Item\Sales Order Item Ticket\Sales Order Item Ticket Registrant\Registrant\Name
    b. Sales Order Item\Sales Order Item Ticket\Price type code
 

Steps to Duplicate

1. Create a Tickets source view query.
2. Add the following nodes to the Include records where area:
    a. Program Events\Event record is equal to [Insert your event]
    b. and Program Events\Registrants\Status is equal to Registered
3. Add the following nodes to the Results fields to display area:
    a. Program Events\Name
    b. Program Events\Registrants\Status
    c. Sales Order\Sales Order Item\Sales Order Item Ticket\Tickets\Price type
4. Navigate to your Preview results tab. Note that the number of results equals that of your event registrants.
5. Navigate back to the Select filter and output fields tab. Add the following node to the Results fields to display area:
    a. Program Events\Registrants\Name
6. Navigate back to the Preview results tab and notice that your results have increased to more than the capacity of the event.

Environment

 Altru Arts & Cultural
 5.10.407

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.