Closed WendyLBelcher closed 1 year ago
Blaine: They are doing a join to the story instance sheet for this query. The story instance table doesn't have the 7000s but the canonical story table does, which is why I think they are appearing as more in directus and not on the website. Also 33 is the number of stories with paintings greater than 19 and this includes four IDs from the 7000s. 33-4 = 29 (the figure appearing on the website
Note: Seemed like there was is a problem, website has 108 results (108 stories have paintings):
But Directus says that stories with greater than 0 total_story_id_paintings is 157
7Span Query SELECT canonical_stories.id FROM story_instance INNER JOIN canonical_stories ON story_instance.canonical_story_id = canonical_stories.id WHERE canonical_stories.total_story_id_paintings > 0 GROUP BY canonical_stories.id
Blaine: Blaine: They are doing a join to the story instance sheet for this query. The story instance table doesn't have the 7000s but the canonical story table does, which is why I think they are appearing as more in directus and not on the website. Also 33 is the number of stories with paintings greater than 19 and this includes four IDs from the 7000s. 33-4 = 29 (the figure appearing on the website.
There is a slight discrepancy; I'm not sure why. Web results = 33 stories with 29 or more stories
Directus results = 37 stories with 28 or more stories (or for 19 or more stories)
7Span Query SELECT canonical_stories.id FROM story_instance INNER JOIN canonical_stories ON story_instance.canonical_story_id = canonical_stories.id WHERE canonical_stories.total_story_id_paintings > 19 GROUP BY canonical_stories.id
7Span Query SELECT canonical_stories.id FROM story_instance INNER JOIN canonical_stories ON story_instance.canonical_story_id = canonical_stories.id INNER JOIN "translation" ON "translation".canonical_story_id = canonical_stories.id WHERE ("translation".language_translated_to = 'English' OR "translation".language_translated_from = 'English') GROUP BY canonical_stories.id
Add to query WHERE canonical_translation_recension = True WHERE translation_status ≠ Summary Only OR WHERE translation_status ≠ Translation of a Translation OR WHERE translation_status ≠ Partial Translation
OR>>>>>>>>>>>>>>>>>>> WHERE canonical_translation_recension = True WHERE translation_status = Published Translation OR WHERE translation_status = Complete Unpublished Translation OR WHERE translation_status = Complete Translation OR WHERE translation_status = Rough (unedited) Translation
Additional Note: You can tell English translation is not working because when you change the dates with the slider, the number doesn't change
7Span Query SELECT canonical_stories.id FROM story_instance INNER JOIN canonical_stories ON story_instance.canonical_story_id = canonical_stories.id WHERE LOWER(canonical_stories.origin) LIKE '%ethiopia%' GROUP BY canonical_stories.id
But Directus has Miracle of Mary stories = 696, Life of Mary stories = 297, Homilies = 59
Canonical story
table origin
field contains "Africa"
Website wrongly gives 280 stories from Africa
Directus correctly gives 810 stories from Africa
Canonical story
table origin
field contains "Ethiopia"
Website wrongly gives 344 stories from Ethiopia
Directus correctly gives 389 stories from Ethiopia: Canonical story
table origin
field contains "Egypt"
Website wrongly gives 111 stories from Egypt
Directus correctly gives 141 stories from Egypt: Canonical story
table origin
field contains "Egypt"Canonical story
table origin
field contains "Europe"
Website wrongly gives 52 stories from Europe
Directus correctly gives 64 stories from Europe: Canonical story
table origin
field contains "Europe"Correct, no problem
Correct, no problem
Not sure 13 website 15 Directus
okay
We need to add locations that are in our data but were not previously captured by the filters
[x] Change Gǝˁǝz to Geʿez
[x] Correct Amharic query Amharic query is NOT working (Website says 401 stories in Amharic. But even just one TGS has 400. And, yes, different TGS have overlap, repeating some of the same stories in others, but not that much overlap. I would expect this to be around 600. I just don't know how to look this up in Directus.)
[x] Correct Italian query Italian query is not working but not off by much???? (web 41; Directus 46)
[ ] Correct English query by adding WHERE canonical_translation_recension = True AND WHERE translation_status = Published Translation OR WHERE translation_status = Complete Unpublished Translation OR WHERE translation_status = Complete Translation OR WHERE translation_status = Rough (unedited) Translation That is, use the same correction as on the Filter button. English query is NOT working. Same problem as in Filter button.
Geʿez query is working (website says 990 stories but we have a total of 1003 stories, so 13 stories are not in Geʿez. This is probably because we only have them in Arabic) Jeremy "We have 10 Arabic only (no Ge'ez version) stories. I imagine the other three are 6000-6002, which deal with Unidentified stories. That query is probably for: Is there a Ge'ez version, so that number makes sense to me."
Arabic query is working (website says 93 stories in Arabic; Directus has 96 stories in Arabic, close enough)
Latin query is working (web 24, Directus 24)
French query is working (web 181; Directus 181)
Explanation: If there are 10 stories in French and 10 stories in Italian and 5 stories that appear in BOTH languages, the results should be 5 (NOT 10 or 20 or 0)
If there are 181 stories in French and 46 stories in Italian and 24 stories in Latin and x stories that appear in all three languages, the results should be x (NOT 181 or 46 or 24 or 251)
Example: When Europe AND Levant are selected, the result is 0 records. This is correct.
But, if you ALSO select Italian, the result is 9 records. This is wrong. No stories were composed in both Europe and Levant, so adding language should NOT increase the number
When using more than one filter (e.g., Story's Date of Origin AND Story's Place of Origin) all filters should be Venn Diagram type Must overlap
Search Titles and Translations
Note: This needs to search Translation table
translation_text
fieldProblem Search for "dog" gets 14 results: But search in Directus for "dog" gets 36 results:
7Span Query SELECT canonical_stories.id FROM story_instance INNER JOIN canonical_stories ON story_instance.canonical_story_id = canonical_stories.id WHERE LOWER(canonical_stories.canonical_story_title) LIKE '%dog%' GROUP BY canonical_stories.id