Change the standard sorting from "when" to "folder"

Support
1

Hello everyone, I am new here. First of all I would like to thank the author for his great work.

I was on reddit with this question but nobody was able to help me there so far. So I decided to repeat the question here.

Is there any way to change the standard sorting from “when” to “folder” on the top bar? I would like to be able to browse photos only from the selected folder but unfortunately when I enter it and select a photo I can only continue to scroll by date and from the entire collection, not just from this selected folder.

I know I can select a folder from the bottom bar, but I would prefer not to hide the photo and to be able to do this with buttons rather than the mouse.

Is there any way to change this or disable sorting by tags other than the folder structure?

2

Howdy @Stefan, welcome to PhotoStructure!

Apologies for the latency, this post got stuck in a Discourse moderation queue (and it didn’t help that I was offline for a couple days out with COVID :mask: )

You’ve raised a couple issues. I’ll work through them:

Can I change the order of the “root” tags on the home page?

There isn’t an easy GUI pointy-clicky way to reorder root tags, but, if you’re not afraid to get a little nerdy, I can help.

The tags table in your PhotoStructure library has an ordinal column to determine the order on the front end. We’re going to change the ordinal of the fs root folder to be less than then When.

Steps:

  1. Shut down PhotoStructure
  2. Install a SQLite database editor. https://sqlitestudio.pl/ and https://sqlitebrowser.org/ are both open source and free. I’ll show instructions for SQLite Studio below.
  3. Open your library database in the editor. The path will be $path-to-your-library/.photostructure/models/db.sqlite3
  4. Select “Tools > Open SQL editor”
  5. Enter this into the “Query” area:
SELECT *
  FROM Tag
 WHERE parentId IS NULL
 ORDER BY ordinal;

and hit f9 or click the “play” button to execute the query. You should be staring at this window:

image
image1447Ă—702 137 KB

  1. Click the “ordinal” cell on the row of the tag you want to edit, and give it a value smaller than 1 (the value that “When” has) (note that fractional and negative numbers are both valid). Make any other ordinal changes you’d like.

  2. Commit the change by typing Ctrl+Return or by clicking the :white_check_mark: right below the “Grid view” tab. You can verify you mathed everything out correctly by replaying the first query.

  3. Quit. Restart PhotoStructure. :partying_face: :tada:

Can I change where “next” and “previous” goes?

Unfortunately, the current version always ignores the context of where you started browsing assets–“next” and “previous” always go to the chronologically next and previous assets. This is a known (frustrating) bug, and will be addressed in a future version.

1 Like