Job Status: sort and filter jobs

Hi @cfvonner, thank you for providing feedback! The timeline to release controls for filtering and sorting has been frustrating... we had faced a few challenges along the way with our existing code for enabling even the most basic filtering and sorting options. The major issue occurred when pagination is enabled (currently it is) or if there were many, many records to manage. The frontend had been unable to maintain performance when sorting (or filtering) was applied; it was a very poor / very slow experience when navigating between pages of results or changing the number of results displayed – effectively the frontend had to cache all that information each time, previously. We have refactored our backend queries that the frontend relies on to pull information from our database tables, so this information (sorted, filtered) can now be retrieved dynamically – and faster.The Job history tables (completed, queued, running) are in much better shape and that is the reason we have seen the most filtering options appear here. We no longer see the performance impact. (Noting that this is not true for some other tables... yet.)But that doesn't explain why haven't we enabled sorting for every column. When speaking with customers, we had determined that the value, for most, was the filtering – finding specific jobs more easily. We are definitely not saying "never" to any of the sorting options, but we want to know there is value for customers instead of "just doing it" – there are always tradeoffs in our product backlog that we have to make.All that said, I'm glad you have reached out to us! What columns would be most important to allow sorting for you? Would you use filtering before sorting? Are there any columns / metrics for Job history that you would like to see added? Any basic scenario you can outline would be helpful.Thank you again for commenting. I'm sure you are speaking for a lot of our users!

Looking at the latest FME Server 2019.x, we have made a lot of improvements since this idea was first posted – in fact, it was posted so long ago, the date marks when we transitioned our FME Community into its current space! Reading through the comments, we have had a number of great suggestions all related to filtering or sorting... but that also means it's no longer clear to us what options are more important to the FME Community than others. When we discuss effort and value to implement "Sorting on Column X" versus "Filtering on Column Y" – it can be apples and oranges! We need to evaluate these requests separately in order to effectively prioritize them, and when we don't have a good understanding of the value for you and your organization – it can amount to guesswork.This idea will be marked Released – if you strongly feel that we need additional filtering or sorting than what is currently possible, please create a new idea. If you do opt to create a new idea, please try and keep it contained to a single "type" of filtering or sorting. Consider reading this guide on Posting Effective Ideas.I'm sorry for the inconvenience this will cause, but we discussed this internally and now is a good time as ever give us an opportunity to "start fresh" with respect to the requests related to filtering and sorting.---Currently, we have the following options (as of FME Server 2019.2 Build 19743):Sorting: Finished Time (Default), WorkspaceFiltering: User Account, Status, Engine, Repository, Workspace, Source Type (Automations, Schedules, Server Apps, Workspace Subscriptions), Source Name'Image: Filtering options for Completed Jobs. Screenshot from FME Server 2019.2 Build 19743.'Image: Example of sorting by Workspace for Completed Jobs. Screenshot from FME Server 2019.2 Build 19743.

Additional Job Filtering Options are now available in FME Server 2018.1 Betas! We have added the ability to filter Completed Jobs based on Engine, Repository, and Workspace – you will also notice that a Duration column has been added, and the ability to Add/Remove Columns in this view!Still yet to do on this particular idea is handle Sorting and adding a Time-Range Filter – please note that these may be broken out into separate ideas, though if that happens I'll be sure to mention it here so that interested parties can vote appropriately!Currently, sorting will remain based on Finished Date/Time (Descending).'Note: Screenshot is from FME Server 2018.1 Build 18492....Please note that this is a beta feature and its functionality and appearance are subject to change as the product continues to evolve before the official release.Should this feature or its implementation not address your concerns, related to this Idea posting, please let us know by leaving a comment.As with all beta features and beta versions of our software, they are not considered production-safe and should be incorporated into your workflows with consideration and testing.

The ability to sort completed FME Server Jobs based on status is a new feature currently available in FME Server 2018.0! Check out the latest beta.'

I'd love to see a full search, filter and sort section added to the jobs list. Its a pain having to search for a particular job. I'd also like the search to be able to search the parameters inside the jobs. People at my work don't give me an fme job id, they give me a reference that is inside the job as a user parameter.

Definitely. We have some instances that generate hundreds of jobs per day, and finding one of them in the Jobs list can be a pain, especially if you have only a rough idea of what you're looking for.

@ryanatsafe,I strongly feel that column sorting and filtering are not and should not be mutually exclusive. Can I suggest looking at what Datatables.net (a popular JavaScript interactive table library) can do in this regard? That link shows an example where they have filters tied to specific table columns (see the select controls between the table and the paging controls at the bottom), and yet each column can also be sorted by clicking on the column headings (and in fact you can sort on multiple columns by SHIFT-clicking on the headings).I don't want to detract from what Safe has already accomplished in improving the user interface - it's definitely improved significantly over the last several releases. However, I think that many of us end users would like to see an experience similar to the example I cited.

When running jobs via a 'controller' workspace... a way to expand/filter a parent job to view it's child processes in the job history

In FME Server 2019 it is only possible to sort by Workspace? It would be very useful to be able to sort any column.There's also a great need for us to be able to use a date range filter on Date started / Date finished. Please add these capabilities!

Add search log files to this!

Being able to filter jobs that have failed would be useful.

Sort and filter jobs based on a number of criteria: start date, finished date, workspace name, repository name, schedule name.  

Perhaps you could 'tag' workspaces with key terms (e.g. lightning or traffic or dataload or user etc...) and then filter by tag. if you can't filter by request name