find persons in the same paragraph/sentence as another
find words/persons/etc. within a scope -- archive (multiple texts) or paragraph or sentence (within texts)
To find person instead of word - entry field might need to be configured so that it changes what is searches - enter typed content and it narrows in same way as the word/form/spelling -- but searches person table and the columns display_name, words/forms/spelling in the dictionary with type 'PN' and then collated to the name_uuid and relation_name_uuid columns in the person table
allow user to include all instances of the name that are not connected to that person in the sorted results below - with some sort of divider...
SCOPE- NEW OPTIONS
1) User chooses archive - then the criteria are searched only in the texts belonging to that archive.
2) User chooses paragraph (to be called to the user paragraph/section) -- if user chooses 'paragraph' allow drop-down of the types via query below that saves ip.variable_uuid (single) and the ip.value_uuid (array) -- and presents the user with the array of ip.value content and saves the corresponding value_uuid as from the user choice.
SELECT h.object_uuid, ip.variable_uuid, ip.value_uuid, ip.value FROM hierarchy h
INNER JOIN item_properties ip ON ip.variable_uuid = h.obj_parent_uuid
WHERE h.obj_parent_uuid = 'b1b01c98-78c7-4ea1-a8d0-b72399a94bae';
Then find all text discourse rows that are connected to that ip.value_uuid via
SELECT td.uuid FROM text_discourse td
INNEr JOIN item_proeprties ip ON ip.reference_uuid = td.uuid
WHERE ip.value_uuid =
That set of uuids then becomes the scope (all descendants of uuids in that list are searched for criteria )
find persons in the same paragraph/sentence as another
find words/persons/etc. within a scope -- archive (multiple texts) or paragraph or sentence (within texts)
To find person instead of word - entry field might need to be configured so that it changes what is searches - enter typed content and it narrows in same way as the word/form/spelling -- but searches person table and the columns display_name, words/forms/spelling in the dictionary with type 'PN' and then collated to the name_uuid and relation_name_uuid columns in the person table
allow user to include all instances of the name that are not connected to that person in the sorted results below - with some sort of divider...
SCOPE- NEW OPTIONS
1) User chooses archive - then the criteria are searched only in the texts belonging to that archive.
2) User chooses paragraph (to be called to the user paragraph/section) -- if user chooses 'paragraph' allow drop-down of the types via query below that saves ip.variable_uuid (single) and the ip.value_uuid (array) -- and presents the user with the array of ip.value content and saves the corresponding value_uuid as from the user choice.
SELECT h.object_uuid, ip.variable_uuid, ip.value_uuid, ip.value FROM hierarchy h INNER JOIN item_properties ip ON ip.variable_uuid = h.obj_parent_uuid WHERE h.obj_parent_uuid = 'b1b01c98-78c7-4ea1-a8d0-b72399a94bae';
Then find all text discourse rows that are connected to that ip.value_uuid via
SELECT td.uuid FROM text_discourse td INNEr JOIN item_proeprties ip ON ip.reference_uuid = td.uuid WHERE ip.value_uuid =
That set of uuids then becomes the scope (all descendants of uuids in that list are searched for criteria )