nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Sales Order Query on Packages

Joe Killian

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

Find more posts tagged with

Query

Sales

Accepted answers

All comments

Crystal Bruce

Hi @Joe Killian - I moved this over to Altru API discussions in SKY Developer. Thanks!

Joe Killian

https://community.blackbaud.com/discussion/comment/310961#Comment_310961

Hi @Crystal Bruce - I was hoping to solve this through the Altru GUI, rather than via API.

Crystal Bruce

https://community.blackbaud.com/discussion/comment/310973#Comment_310973

Ok I'll move it back! Ty!

Crystal Bruce

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!

Joe Killian

@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.

Crystal Bruce

https://community.blackbaud.com/discussion/comment/311456#Comment_311456

Great! Case number is super helpful. Let me escalate on my end. Thanks!

Crystal Bruce

@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!