Discuss Scratch
- Discussion Forums
- » Advanced Topics
- » ocular - scratch forum info
- DifferentDance8
-
1000+ posts
ocular - scratch forum info
I want to do the opposite, as I want to get all my posts that have been edited by any given ST member. This is the best I could do, but for some reason it's just giving me old posts from WAY before I even joinedThis seems to work: Is there any way for me to show all of my posts that were edited by the ST in general (not a specific user)?username = "han614698" AND last_edited_by IS NOT NULL AND NOT last_edited_by = "han614698"
username = "DifferentDance8" AND last_edited_by != "DifferentDance8" OR last_edited_by IS NULL
- mybearworld
-
1000+ posts
ocular - scratch forum info
(#3722)I think it's “IS NOT”, not “!=” – no idea if that's the problem thoughusername = "DifferentDance8" AND last_edited_by != "DifferentDance8" OR last_edited_by IS NULL
- DifferentDance8
-
1000+ posts
ocular - scratch forum info
“IS NOT” doesn't even exist(#3722)I think it's “IS NOT”, not “!=” – no idea if that's the problem thoughusername = "DifferentDance8" AND last_edited_by != "DifferentDance8" OR last_edited_by IS NULL
- Mrcomputer1
-
500+ posts
ocular - scratch forum info
Try this:I want to do the opposite, as I want to get all my posts that have been edited by any given ST member. This is the best I could do, but for some reason it's just giving me old posts from WAY before I even joinedThis seems to work: Is there any way for me to show all of my posts that were edited by the ST in general (not a specific user)?username = "han614698" AND last_edited_by IS NOT NULL AND NOT last_edited_by = "han614698"My other attempts just give me errorsusername = "DifferentDance8" AND last_edited_by != "DifferentDance8" OR last_edited_by IS NULL
username = "DifferentDance8" AND last_edited_by != "DifferentDance8" AND last_edited_by IS NOT NULL
- DifferentDance8
-
1000+ posts
ocular - scratch forum info
OHTry this:I want to do the opposite, as I want to get all my posts that have been edited by any given ST member. This is the best I could do, but for some reason it's just giving me old posts from WAY before I even joinedThis seems to work: Is there any way for me to show all of my posts that were edited by the ST in general (not a specific user)?username = "han614698" AND last_edited_by IS NOT NULL AND NOT last_edited_by = "han614698"My other attempts just give me errorsusername = "DifferentDance8" AND last_edited_by != "DifferentDance8" OR last_edited_by IS NULLusername = "DifferentDance8" AND last_edited_by != "DifferentDance8" AND last_edited_by IS NOT NULL
THE WHOLE ISSUE WAS CAUSED BY A MISSING “NOT”
I CANT BELIEVE I DIDN'T CHECK THAT FIRST OF ALL
- mybearworld
-
1000+ posts
ocular - scratch forum info
(#3724)Ah, that's only for null checks I think? Sorry
“IS NOT” doesn't even exist
- medians
-
1000+ posts
ocular - scratch forum info
https://ocular.jeffalo.net/search?q=%20&sort=relevance&filter=username%20%3D%20%22medians%22%20AND%20topic.category%20%3D%20%22Things%20I%27m%20Reading%20and%20Playing%22
https://ocular.jeffalo.net/search?q=%20&sort=relevance&filter=username%20%3D%20%22medians%22%20AND%20topic.category%20%3D%20%22Suggestions%22
https://ocular.jeffalo.net/topic/7204
https://ocular.jeffalo.net/topic/41673
https://ocular.jeffalo.net/topic/747546
:D it is somewhat working
https://ocular.jeffalo.net/search?q=%20&sort=relevance&filter=username%20%3D%20%22medians%22%20AND%20topic.category%20%3D%20%22Suggestions%22
https://ocular.jeffalo.net/topic/7204
https://ocular.jeffalo.net/topic/41673
https://ocular.jeffalo.net/topic/747546
:D it is somewhat working
- han614698
-
1000+ posts
ocular - scratch forum info
is there anyway to search just for text in titles?
- Maximouse
-
1000+ posts
ocular - scratch forum info
I don't think there's an option for that in ocular itself, but the ScratchDB API supports it. You can search normally, then run the following code in the console on the search results page: is there anyway to search just for text in titles?
// Modified code from https://github.com/jeffalo/ocular/blob/d8f89bb/pages/search.vue const search = document.querySelector(".container").__vue__ ; search.page = 0; search.showLoadMore = false; search.data = await fetch( `https://scratchdb.lefty.one/search/indexes/forum_posts/search?attributesToSearchOn=topic.title&hitsPerPage=50&q=${search.search}${search.sort}${search.filter}`, { headers: { authorization: "Bearer 3396f61ef5b02abf801096be5f0b0ee620de304dd92fc6045aeb99539cd0bec4", }, } ) .then((res) => res.json()) .catch((err) => { search.error = { title: "Network Error", details: "Failed to connect to ScratchDB.", }; return { posts: [] }; }); if (search.data.message) { search.error = { title: "Search error", details: search.data.message, }; } else search.showLoadMore = true; search.loadMore = async function() { this.showLoadMore = false; this.page++; var res = await fetch( `https://scratchdb.lefty.one/search/indexes/forum_posts/search?attributesToSearchOn=topic.title&hitsPerPage=50&q=${ this.search }&page=${this.page + 1}${this.sort}${this.filter}`, { headers: { authorization: "Bearer 3396f61ef5b02abf801096be5f0b0ee620de304dd92fc6045aeb99539cd0bec4", }, } ).catch((err) => { this.error = { title: "Network Error", details: "Failed to connect to ScratchDB.", }; }); var data = await res.json(); this.data.hits.push(...data.hits); this.showLoadMore = true; }
- han614698
-
1000+ posts
ocular - scratch forum info
(#3730)After farther testing, it looks like the old way, “+title:”abcdefg“” works.I don't think there's an option for that in ocular itself. is there anyway to search just for text in titles?
Last edited by han614698 (Aug. 11, 2024 12:41:14)
- Maximouse
-
1000+ posts
ocular - scratch forum info
+title:“ocular” shows posts containing the words “title” and “ocular” in topics whose titles don't mention ocular. After farther testing, it looks like the old way, “+title:”abcdefg“” works.
Last edited by Maximouse (Aug. 11, 2024 14:24:12)
- gilbert_given_189
-
1000+ posts
ocular - scratch forum info
It was working enough for ocular (not everything else though)ScratchDB kinda ded rn “Failed to connect to ScratchDB.”
(read here)
Last edited by gilbert_given_189 (Sept. 24, 2024 11:29:11)
- Jeffalo
-
1000+ posts
ocular - scratch forum info
ocular 2024:

ocular all time:

pretty cool! the huge dip is when scratchdb broke.

ocular all time:

pretty cool! the huge dip is when scratchdb broke.
- Game_master117
-
15 posts
ocular - scratch forum info
WOW thats actually really dang cool man… You should totally give us insider information and stuff like that :3 btw keep us updated on the works!
when I receive [SCRATCH ON v]
say [DIDDO]
- Jeffalo
-
1000+ posts
ocular - scratch forum info
hijacking the ocular topic again to announce that my last scratch updates have landed, you may notice the scratch forums now use 3.0 scratchblocks, no longer immediately die whenever someone uses unicode emoji, and are also very slightly faster!
i ripped out thousands of lines of code from the scratch codebase, so i'm surprised more stuff didn't break. - you may notice that signatures are gone at the moment.. oops!
when green flag clicked
say [yay!]
i ripped out thousands of lines of code from the scratch codebase, so i'm surprised more stuff didn't break. - you may notice that signatures are gone at the moment.. oops!
- Jeffalo
-
1000+ posts
ocular - scratch forum info
when green flag clicked::operators :: cat
frog blocks
- Discussion Forums
- » Advanced Topics
-
» ocular - scratch forum info