Ticket Lister Date Range Expressions

[Posflow]

Hi everyone!

Is it possible to user Date Range for the Ticket Lister?

Something like this
Date > StartDate <> EndDate

[josephrussell]

Maybe something like this…

Ticket Lister Widget

And we would need to sort tickets by date as well.

As per Emre - OK That was easier than I thought. At least SambaPOS infrastructure permits such modifications. I’ve added support for easily typing date expressions as TicketDate is Today+1 or TicketDate > Now . It supports much more than it seems so you can just ask me how specific filtering expressions (not wildcards :)) can be written…

And…

Display ticket payment type on ticket lister

Column headers is just a label aligned above. The way I did it a few years back it was not responsive. I now know it can be done in a better way that would be responsive but haven’t went back to update it. The search is a pain and not perfect. It is due to the way I query just filtering by the number of days, so all the buttons and date ranges just return the number of days which is the main part that determines the results. There will be better ways to accomplish this I am sure. (line bre…

[Posflow]

Yeah Ive tried but I am looking to use a date range instead. So I can get tickets listed for lets say October 2020 or so

[josephrussell]

Its definitely possible, just requires some scripting. Did you check out the second post by Mark?

[Posflow]

@josephrussell yes I did, but even from Emre’s post Ive seen that it only allows expression for Today-xNumberOfDays.

See, creating a script to get This Month worth of ticket is absolutely fine, but if I want to do December 2020, Today - xNumberOfDays is not going to work.

[josephrussell]

So if you want to do a range you can use an AND operator which is functional as of v4.

Might be missing something but still thinking it’s possible.