Changes between Version 5 and Version 6 of query_builder_doc
- Timestamp:
- Feb 3, 2016, 6:14:57 PM (8 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
query_builder_doc
v5 v6 1 2 == Query Builder tool == 1 = Query Builder tool = 3 2 4 3 You can find the Query Builder tool online at … … 6 5 https://ismi-dev.mpiwg-berlin.mpg.de/static-ismi/ng2-query-builder/index.html 7 6 8 = = Example query ==7 = Example query = 9 8 10 9 In this simple example we will find all witnesses of titles by Nasir al-Din al-Tusi. 11 10 12 == = Start ===11 == Start == 13 12 14 13 The tool starts with an option to select the first query step: … … 20 19 * "**object ID is**" to select one object with a certain ISMI_ID e.g. 47316 for Tusi 21 20 22 == = Show all persons ===21 == Show all persons == 23 22 24 23 If we select "**object type is**" in the first select box we get a second select box with all the possible object types like ALIAS, CODEX, COLLECTION and more. … … 32 31 Because this are a lot of objects the system will not show all of the objects automatically. If you really want to see all 2217 objects you can click on the "**show results**" button but your browser may crash or take a while to display so many objects in a table. 33 32 34 == = Select persons by name ===33 == Select persons by name == 35 34 36 35 Now we want to narrow down the list of persons to only those that have "tusi" in their name. … … 60 59 In the table we find the row containing Abū Jaʿfar Naṣīr al-Dīn Muḥammad ibn Muḥammad ibn al-Ḥasan al-Ṭūsī and we note that the corresponding ismi_id is 47316. 61 60 62 == = Select objects by ID ===61 == Select objects by ID == 63 62 64 63 Now we click "**add step**" again to add another step to select only Nasir al-Din al-Tusi to find only his works. … … 69 68 70 69 [[Image(qb-person-tusi-id.png)]] 70 71 Under "Query result" we see that now only 1 PERSON object is selected. 72 73 == Select texts written by a person == 74 75 Now we click "**add step**" again to add another step to select all texts written by Tusi. 76 77 In the first select box we select "**Relation type is**". 78 79 In the second select box we get a list of all relations of the Tusi object in the database like "is_alias_name_of" or "was_born_in". 80 81 You will note that all relation types show up in the list a second time prefixed with "<-". These are the reverse relations. These are needed because the relations are directed and you have to select the direction of the relation. 82 83 The "normal" relation is read from the last selected object, in this case a PERSON to the next possible objects. To find the birthplace of the PERSON you would select "**was_born_in**" and you would get the relation `PERSON-[was_born_in]->PLACE` going from a PERSON to a PLACE. 84 85 To get the texts written by Tusi we need the relation `TEXT-[was_created_by]->PERSON` which goes from a TEXT to a PERSON. But in our case we want to start at the PERSON not the TEXT so we have to select the reverse relation "**<- was_created_by**". 86 87 When we select "**<- was_created_by**" in the second select box the system runs the query to find all texts that were created by Tusi: 88 89 [[Image(qb-person-tusi-id-created.png)]] 90