Topic: [Feature] Update the search help page

Posted under Site Bug Reports & Feature Requests

Requested feature overview description.
e621:cheatsheet#Sorting should be updated to include the remaining means of sorting results

Why would it be useful?
I can only guess what some of the newer sort mechanisms are. I'd update the cheatsheet myself if I had access to edit it and knew exactly what they all were, but, some I am absolutely clueless on.
The sorting mechanisms (and my guesses about what they are), are below.
I am guessing some of the information based on the Source Code and what I can figure out from it's contents.

Exists in Cheatsheet Missing from Cheatsheet
Order What it does Order My Guess What it does
order:change Sorts by last update sequence order:arttags Most Artist Tags first
comment_bumped Posts with the newest comments order:arttags_asc Least Artist Tags first
comment_bumped_asc Posts that have not been commented on for the longest time order:change_asc Sorts by least recent update sequence
order:comment_count Most comments first order:change_desc redundant/identical to order:change
order:comment_count_asc Least comments first order:chartags Most Character Tags First
order:duration Video duration longest to shortest order:chartags_asc Least Character Tags First
order:duration_asc Video duration shortest to longest order:comment per source code: Posts last commented at (I can't determine the difference from order:comment_bumped)
order:favcount Most favorites first order:comment_asc per source code: Posts that have not been commented at for the longest time (I can't determine the difference from order:comment_bumped_asc)
order:favcount_asc Least favorites first order:comment_count Most Comments first (doesn't appear to be an "_asc" equivalent to this order)
order:filesize Largest file size first order:conttags Most Contributor Tags first
order:filesize_asc Smallest file size first order:conttags_asc Least Contributor Tags first
order:id Oldest to Newest order:copytags Most Copyright Tags first
order:landscape Wide and short to tall and thin order:copytags_asc Least Copyright Tags first
order:portrait Tall and thin to wide and short order:duration_desc redundant/identical to order:duration
order:mpixels Largest resolution first order:gentags Most General Tags first
order:mpixels_asc Smallest resolution first order:gentags_asc Least General Tags first
order:random Orders posts randomly * order:id_desc Newest to Oldest, identical to default sort
order:score Highest score first order:invtags Most Invalid Tags first
order:score_asc Lowest score first order:invtags_asc Least Invalid Tags first
order:tagcount Most tags first order:lortags Most Lore Tags first
order:tagcount_asc Least tags first order:lortags_asc Least Lore Tags first
order:metatags Most Meta Tags first
order:metatags_asc Least Meta Tags first
order:note Posts with the newest notes
order:note_asc Posts that have not been noted for the longest time
order:rank The Source Code suggests it's meant to show what's trending based on score and age
order:spectags Most Species Tags First
order:spectags_asc Least Species Tags first
order:updated I have no clue beyond the implication it's related to updates. it changes randomly each refresh. Even AI analyzing the Source Code can't give me an answer I understand.
order:updated_asc I have no clue beyond the implication it's related to updates. This one remains the same because whatever is affecting it's alternate isn't affecting it. Even AI analyzing the Source Code can't give me an answer I understand.
order:updated_desc redundant/identical to order:updated

What part(s) of the site page(s) are affected?
Posts, search, e621:cheatsheet#Sorting

dba_afish said:
order:updated from what I can tell is recent favs and add to sets maybe some other things?

It could be. I didn't mess around with favs at all.

Edit: After messing around with favs, it probably is indeed related to favs at the least. If I recall right upvoting and downvoting did nothing to affect it. The question is what exactly other than favs has an effect.

Updated

Aacafah

Moderator

It has been updated for grouped tags relatively recently (though they missed the faulty Post Metatags anchor), but the rest of the page could probably do with a once-over given the changes that have been made since those parts were written. There is a currently pending update that'll update sorting, so I'd imagine any changes would be put off until that's finished/rejected, but tbh the inconsistency between the cheatsheet, the autocomplete, and what's actually supported is part of the reason I made that thing anyway, so I'm hopeful for it. Actually, I should probably prepare a draft for that before it goes through instead of afterwards like last time, so thanks for the reminder!

Updated

Donovan DMC

Former Staff

dba_afish said:
order:updated from what I can tell is recent favs and add to sets maybe some other things?

Updated is just sorting by updated_at, so anything that updates the post

Pools and sets are included because posts maintain a list of those in pool_string (yes, despite the name this includes sets)

fk2169 said:
It could be. I didn't mess around with favs at all.

Edit: After messing around with favs, it probably is indeed related to favs at the least. If I recall right upvoting and downvoting did nothing to affect it. The question is what exactly other than favs has an effect.

Just like above favorites also have fav_string, votes however do not, and updating the score bypasses callbacks, so no change is made to the post that would also update the updated_at column

I will also note that you are using the sql query builder, which is not used for searching

The Elastic Post Query Builder is used for searching
They should be roughly equivalent but there are differences

Also, the commit in your link is from 2023, it's very old and changes have happened since then

fk2169 said:

Order My Guess What it does
order:comment per source code: Posts last commented at (I can't determine the difference from order:comment_bumped)
order:comment_asc per source code: Posts that have not been commented at for the longest time (I can't determine the difference from order:comment_bumped_asc)

Comments have a "do not bump" checkbox that can be checked when creating them, if that box is checked comment_bumped will not be updated
order:comment_bumped is actually what https://e621.net/comments?group_by=post uses (source)
Posts will also stop getting bumped regardless if they have more than 40 comments
code for bumping

Updated

Original page: https://e621.net/forum_topics/57161?page=1