Sales Order Query on Packages
Has anyone successfully crafted a query that returns package information per sales order?
Similar to the won't-fix bug impacting Promo Codes (KB 195895), simply adding any output field under Sales Order Item\Sales Order Item Ticket\Program\Event Packages returns information for ALL packages, not just the one tied to the ticket purchase.
The same happens with adding an output field under the incredibly granular Order Item\Sales Order Item Ticket\Tickets\Sales Order\Sales Order Item\Sales Order Item Ticket\Program\Event Packages
Simple Query and results with no package information:
Simple query and results, with one Event Package Field
Answers
-
Hi @Joe Killian - I moved this over to Altru API discussions in SKY Developer. Thanks!
0 -
Hi @Crystal Bruce - I was hoping to solve this through the Altru GUI, rather than via API.
0 -
Ok I'll move it back! Ty!
0 -
Hi @Joe Killian I'm sorry no responses have come through on your query. I can try and move it over to Altru API in Sky Developer, if you'd like. I know you mentioned you'd rather not use API. I am checking with another team member on this. In the meantime, an alternative would be to open a support case to see if crafting a query is possible in this instance. Thanks!
1 -
@Crystal Bruce
Thanks for the follow-up and looping in other staff! In part, I need to keep this in query so that I can consume an ODATA feed for third party integration, though I am also curious to see what API options there are now.
I do have a support case open, as I believe this is a defect with query, similar to how attempting to query on discount promo codes is broken (KB 195895). My support case seems to have stalled, if you'd be able to help there too, I'd be hugely grateful. Case #020739269.1 -
Great! Case number is super helpful. Let me escalate on my end. Thanks!
0 -
@Joe Killian looks like support is reaching out to you today! Let me know if you need further help and if there is a solution you can provide, please come back and provide it here. Thanks!
0
Categories
- All Categories
- 6 Blackbaud Community Help
- 211 bbcon®
- 1.4K Blackbaud Altru®
- 403 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.2K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 360 Blackbaud eTapestry®
- 2.6K Blackbaud Financial Edge NXT®
- 658 Blackbaud Grantmaking™
- 579 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 943 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.7K Blackbaud Raiser's Edge NXT®
- 3.8K SKY Developer
- 250 ResearchPoint™
- 120 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 241 Member Lounge (Just for Fun)
- 36 Blackbaud Community Challenges
- 37 PowerUp Challenges
- 3 (Open) PowerUp Challenge: Grid View Batch
- 3 (Closed) PowerUp Challenge: Chat for Blackbaud AI
- 3 (Closed) PowerUp Challenge: Data Health
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 798 Community News
- 3K Jobs Board
- 56 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)