Support

I understand the use case and the context. I need some time to investigate the plausibility of such a feature, mostly because of what you already said: performance. I think that since ticket assignment is a column of the tickets table —the first table in the series of JOINs— we could most likely implement it without having a negative performance impact. There is a performance impact filtering by the assigned_to column but since this returns a smaller subset of the tickets table I expect that the performance gains in the subsequent JOINs will outweigh it, leading to a similar net performance.

Well, only one way for me to find out: write the code and benchmark the queries :)

I can confirm that the performance is very good. My hunch was right, the pre-filtering of the tickets column improves the performance of the subsequent JOINs and the overall load time actually improved when displaying the smaller list of tickets.

So, yes, you're getting this feature in the next release planned for next week.

Thank you as ever, Eric, for filing a ticket with a coherent, well-defined, and detailed use case and taking into consideration everyone else who is also using the product. This is a stellar example of what the ideal feature request looks like!

You're welcome!

>  is there a way to prevent the browser "Confirm Form Resubmission" message when refreshing the page? 

The filter settings are stored in the user session and will be applied until changed.  So, just Click on the menu item for latest open tickets after applying the filters you want.  Hitting F5 / CMD-R on this page won't show the message.

> Unfortunately, in macOS there isn't a method available to do this via a shortcut startup switch as there is in Windows?

You mean starting up the browser on a filtered Latest Open Tickets page from a shortcut kind of thing? Sure you can! You just need to… think different.

Let's say your site is www.example.com, the URL to your latest open tickets is https://www.example.com/support/latest-open-tickets.html and you want to show unassigned tickets. You just need to create a shortcut which opens https://www.example.com/support/latest-open-tickets.html?filter.unassigned=1.

Doing that is rather simple. Open a new Safari window (not tab). Visit that URL. Drag the favicon from Safari's address bar to the desktop. You now have a .webloc file which is your URL shortcut.

Alternatively, create a file named Latest Unassigned Open Tickets.webloc with this content:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
	<key>URL</key>
	<string>https://www.example.com/support/latest-open-tickets.html?filter.unassigned=1</string>
</dict>
</plist>

You're welcome!

I honestly enjoy working on your tickets. They show us use cases for our ticket system that I originally hadn't thought of or intended. You describe your use cases clearly and efficiently, telling me what you're trying to achieve (instead of what most people do, i.e. telling me how they think something should work, even though their idea is completely unusable in mass distributed software). This is extremely helpful for gaining insight into your use cases and helps us design features which will work not just for you, but also other people with different uses cases who might have some overlap with yours. So, thank you for being what I can best describe as the model client :)