99% sure this has been asked before and 99% sure there is no solution
Ideally I need all Orders with Order Tags exported/reported
this is so we can build enhanced reports and also bill our customers by importing the data in our finance system.
I know it’s 2 different sets of data and Order Tags are not stored as SQL data joined to the Order table (this would make it so simple) but there must be a way as it displayed on screen so must be able to be exported/reported as it’s really just a ticket.
order tags are stored in orders table arnt they? Been a while since I looked at tables.
Thought they were stored in json in order tags column.
This is pretty common for flexible content.
SQL 2017 have support for json parsing in queries.
We post itemised charges to our booking system. We don’t show order tags as there own lines, price is included on order price regardless of samba setting but could have been seperate line.
Almost anything is posible with a bit of work.
What you have not told us though is exactly what data do you need and in what format? Just all orders that have order tags? Or are you needing the order tags that have orders? What exactly are you wanting?
Only similar topics I can recall is creating an itemised invoice for multiple tickets as a single invoice for an entity account from within samba which would be a challange.
Which in honesty isn’t a 'normal thing when dealing with accounts as samba uses them and tickets are the invoices and you would get an account statement. Suppliers don’t usually give an itemised invoice for multiple deliveries at end of month, they give a statement of account showing the invoices.
If coupled with an external system where data can be manipulated and rendered outside of the built in ticket and reports system its certainly allot easier.