Filter recently updated

[Abubakar Siddique]

When a new update is available of coolector, it says 800 movies and series added.

Is there any way to have a filter from which I can check which are the movies added in this update?
So that I can easily browse those 400-800 movies and make some of them as wishlist.

[(cool) Hector]

A good part of the movies that were added is listed here:

https://www.coollector.com/viewtopic.php?f=5&t=116

[(cool) Hector]

My previous answer was tongue-in-cheek, but if I think about it more seriously, it would be very easy to implement, at least technically. Indeed to display the 800 latest added movies I only have to take the 800 with the biggest Ids.

The main issue is how to present such a filter... It would probably be about "displaying an Id range". When the user clicks the filter, he'd have to input a min Id and a max Id (the app would inform the user about the value of the biggest Id). Of course other filters could be applied (year, country, genre...).

This improvement isn't prioritary, but it's interesting and I keep it in the back of my mind.

If you have ideas, suggestions, comments, they're welcome!

[Abubakar Siddique]

From a developer perspective, I have few ideas how it can be achieved :

Method 1 :
In .cool file, for the next release introduce a variable which will have the latest row ID of the last entry.
When user update next time, and lets say in Tools menu add a new option "Newly Added",
when user clicks on it, it will display (a popup like recommendation witl listview) all the movies/series added after that id.
eg: "SELECT * FROM table_name WHERE id > :id_in_cool"

In that once user finishes checking, user can click a button "All checked". When clicked, the latest row ID will be stored in the cool variable.

Method 2 :
It will be similar to method 1, but can be accessed from the "Add/Remove Filter" for "Newly Added Movies"


Method 2 will be the better way.

[(cool) Hector]

I wanted an Id range to be able to go back anywhere in time but it's you who's right, focusing the feature only on the latest additions makes it much easier for the user to understand

Thank you very much!

[(cool) Hector]

If I include inside the database the size of the previous databases, we could have a new filter named "newly added to Coollector" that would have the values "added by version 4.20.9", "added by version 4.20.8", "added by version 4.20.7", etc...

[Abubakar Siddique]

I wanted an Id range to be able to go back anywhere in time

Well I am not sure about the db colums. If there is a column you are maintaining that when the movie/series is added in the db. then ID range can be implemented with a filter like Movies added in Jan 2023, Movies added in Dec 2022 etc

[Abubakar Siddique]

If I include inside the database the size of the previous databases, we could have a new filter named "newly added to Coollector" that would have the values "added by version 4.20.9", "added by version 4.20.8", "added by version 4.20.7", etc...

Yes this one will make more sense.

[(cool) Hector]

then ID range can be implemented with a filter like Movies added in Jan 2023, Movies added in Dec 2022 etc

You're right, adding a date would be more user-friendly.

For example "added v.4.20.9 (17 JAN 2023)".

[Abubakar Siddique]

Yes. Hope to see this feature soon.

[(cool) Hector]

Yes. Hope to see this feature soon.

Unfortunately not soon, I'm sorry.

I've very tempted to add this feature because it's quite easy to do, but I must stay focused on the killer features that I'm currently working on, they're game-changers!

[Abubakar Siddique]

Love to see new features.

[(cool) Hector]

Version 4.21.3 brings a new filter called "Latest Additions". Hope you'll like it

[Abubakar Siddique]

Cool, finally that will help a lot to find new movies to watch and mark them wished easily.

[Abubakar Siddique]

One little suggestion,

I want to filter with the following criteria :
All MOVIES which are
ADDED BY LAST 10 UPDATES and
NOT OWNED also
NOT WISHED.

so that I can get only those movies which I dont have and neither I have marked them as wished.

But I am unable to achieve that since NOT OWNED and NOT WISHED is within the same dropdown