Querying Databases

Posted in

#51 by rampaa
2020-06-16 at 12:48
I think the following query can be used for automated extraction of known "Non-standard" resolutions from the notes: link
#52 by yorhel
2020-06-16 at 13:37
The challenge with automated extraction is more in removing the old information from the notes than in matching the data, and if that's going to need manual intervention anyway, it's better to do that in a single edit.
#53 by rampaa
2020-06-16 at 13:46
How about link then? "Resolution: X" format should be pretty easy to remove from the note section, and it returns 505 results, which is more than half of the all instances.Last modified on 2020-06-16 at 13:47
#54 by yorhel
2020-06-16 at 13:51
Try a regexp_replace() on the notes to see if you can get the desired effect.
#55 by rampaa
2020-06-16 at 16:12
EDIT: Updated the query.
EDIT2: Updated the query for the last time. And wrote an additional query to cover "X resolution" format: link

I think the end result is fairly decent but what do you think?Last modified on 2020-06-16 at 21:02
#56 by yorhel
2020-06-17 at 05:40
Better than some of my conversions. :)

Thanks, batch edits done.
#57 by rampaa
2020-06-24 at 18:11
I can't find where, but I vividly remember Yorhel saying something along the lines of "Having no screenshot is better than having screenshots with wrong resolutions". In the light of that motto, here: link
#58 by briarmae
2020-07-01 at 20:40
I'm trying to use the Advanced Search query but every time I try to un-comment-out the search by tag ID it breaks, giving me syntax errors. All I'm doing is deleting the /* before the first INTERSECT and changing the tag ID. Obviously- this is wrong. But... I can't figure out what's right. Any help would be appreciated.
#59 by rampaa
2020-07-02 at 10:57
#58 The line with "get_child_tags" was missing a ")". It's fixed now.Last modified on 2020-07-02 at 10:58
#60 by briarmae
2020-07-02 at 15:24
Thank's so much, that was really fast!


You must be logged in to reply to this thread.