Developer forum

Forum » Ecommerce - Standard features » Using ecom as eventbooking?

Using ecom as eventbooking?

E-mail notifications
Peter Klünder
Reply
Posted on 06/07/2021 14:27:38

I have a client that wants to be able to book events with different options available, this is possible through ecom.

But is it possible to pull out lists for the different events with information on what has been ordered (coffee, placement and so on)  by each person that has booked the given event.

orderlists lists every individul order by person/orderid, cant seem to wrap my head around getting a list from (productid/eventnumber) and then list all that have ordered that product.

Best Regards

Peter


Replies

 
Nicolai Pedersen
Posted on 06/07/2021 14:37:33
Reply

Hi Peter

I think you have to go custom. You can create a SQL that combines the EcomProducts, EcomOrderlines and EcomOrders table (and maybe Accessuser) to query a full list of orderlines of a given product. You can create a datalist with that SQL and then use the datalist publisher to get it.

Alternatively you can use the SQL index builder using the same or similar SQL and then create a query and use querypublisher to display the result.

BR Nicolai

 
Peter Klünder
Posted on 06/07/2021 14:41:40
Reply

Hi Nicolai

Is this something DW would be willing to take a crack at (give an estimate), if I get a full description of what data it is the client wants ?

BR Peter

 
Nicolai Pedersen
Posted on 06/07/2021 14:58:22
Reply
This post has been marked as an answer

Yes, no probs.

You can drop an email to Jesper, jno@dynamicweb.dk and he can help estimate once you know the requirements.

BR Nicolai

Votes for this answer: 1
 
Peter Klünder
Posted on 06/07/2021 15:05:38
Reply

Hi Nicolai

Thank you for the fast reply, i'll contact Jesper with a more precise description :-)

Have a great summer

BR Peter

 
Nicolai Pedersen
Posted on 06/07/2021 15:12:12
Reply

Thank you - and great summer to you guys as well!

 

You must be logged in to post in the forum