Hopefully a Quckie Question - Re: Ticket Lister Filter

[windinghouse]

Hi Sorry for another question…
I would like to add a filter to a Ticket Lister Widget to only display tickets from one particular Entity please advise what the syntax is that I need to enter.

I have a Table Entity called ‘Takeaway’ and want to list all tickets for that entity

Thanks as always

Rob

[morshed1]

Use Department Id under filter. If your takeaway department is configured to ‘2’ (second department) then it should be set to DepartmentId is 2.

On below example I have set to ‘DepartmentId is 1’ (1 is my Restaurant Department), all the tickets for the restaurant department will be displayed.

Additional information:

Kitchen Display Setup

@gerlandog since everybody have different venue setups releasing a solution that fits everyone won’t be possible. You can easily implement this for yourself. You can modify widgets to display tickets that created on a specific department or that have a specific ticket type. The values you need to know is the department or ticket type ids. Check Departments or TicketTypes tables for Id numbers. If the department id is 2 you can edit ticket lister widget settings to filter out other tickets by ty…

[windinghouse]

@morshed1 thank you for your reply. I have tried this and no tickets are being displayed. I have attached screen shots below.

1st one shows an entity screen that is displaying all open ‘preparing’ tickets
2nd one shows the same entity screen with ‘DepartmentID is Takeaway’ in the filter field
3rd showing settings

Many Thanks

Rob

[morshed1]

Your filter expression is incorrect it should be 'DepartmentID is 1 or 2 and NOT 'DepartmentID is Takeway

In below Example Department 1 is the Restaurant and 2 is the Takeaway

Ps: Can you also check the mapping settings is configured correctly for the specific department.

[windinghouse]

Brilliant @morshed1 - I’m still learning but that has worked - thank you so much. One last quick question is it possible to filter by 2 departments and if so what would the expression be ?

Thank you so much for your help

Rob

[morshed1]

@windinghouse, can you expand bit more on “One last quick question is it possible to filter by 2 departments”

[windinghouse]

I would like to display tickets for department 1 and department 2 in the same ticket lister widget is this possible and if so what would the expression be.

Thanks

[morshed1]

yes, its simple. Under the mappings for the Entity Screen set it to * under Department and ticket type

Leave the Filter blank…
http://forum.sambapos.com/uploads/default/original/3X/d/7/d797543815789794d18d0f9e22f1b6511512ebe5.png

[gerlandog]

I will add one more complexity to this…
The field ORDER FILTER is ment to filter each line of orders? for example, could we add an expressionto filter all order that should go to the kitchen and not display the ones that should go to the bar?

THANKS!!!

G.

[windinghouse]

I have 3 departments and wish to display 1 department in 1 ticket lister and the other 2 departments in another lister. I can filter by using DepartmentId is 1 in the first ticket lister - but what would I need to type in the Filter field to show 2 departments?

Thanks

Rob

[emre]

Try DepartmentId != 1 in other widget. != means not equals.

[windinghouse]

thanks @emre is there a document or somewhere for me to find all the expressions, syntaxes etc? to save me keep asking silly questions I’m sure that you are a very busy man and can do without answering simple questions!

Thanks as ever for a brilliant system and great support!

Rob

[emre]

@windinghouse this is not a silly question. That feature works more like a programming language and I wouldn’t think we can use != operator somewhere until someone asks a related question. Honestly I even don’t know all SambaPOS possibilities. Questions reveals them. So please keep asking

[windinghouse]

That Worked! thanks @emre is it possible to add a filter to filter a product group? if so how ?

Thanks again

[emre]

Not tested it but you can try '{GROUP CODE}' is 'Beverages' or '{GROUP CODE}' == 'Beverages' on Order Filter. You should type single quotes. Please let me know your result.

[windinghouse]

@emre

‘{GROUP CODE}’ is ‘Beverages’

Perfect! both work I now have 2 kitchen screens 1 with drinks and 1 with food :smile - the next thing I need to get working is that - we create a ticket for drinks and then add a ticket for food (on the same order) once the customer has requested the bill we ‘merge’ the tickets. However when I ‘Merge’ tickets the Kitchen status changes back to preparing. This then does not close the ticket once payment has been made.
I’m sure that this should be quite simple and for us is a great solution for being able to process drinks and food on the same order. Any help with the Merging would be great.

Thanks @emre for all of your help

[emre]

I’m not able to test that atm but I think you can solve it by handling Tickets Merged rule.

[windinghouse]

I’ve tried changing the merge ticket rule in several ways - but nothing changes - no matter what I change or even if I delete the rule I get the following after I merge 2 tickets

each ticket shows like the following before I merge.

[emre]

Can you PM me a zip file that contains backup of your database?

[emre]

Hello @windinghouse

When you configure Tickets Merged actions like this :

That means Update Ticket Status to Delivered if Current Ticket Status is Delivered. You should use it like Change status to X if current status is Y. When both statuses are same obviously it doesn’t work.

To fix that either leave Current Status empty to always change merged ticket’s status to Delivered or configure Current Status properly.