multiple database queries [message #1399] |
Wed, 15 September 2021 02:46 ![Go to next message Go to next message](/forum/theme/myThemeWithHFCSS/images/down.png) |
nats
Messages: 6 Registered: August 2021
|
Junior Member |
|
|
I want a set of data that the user can click on to display the matching data from another set of data which then links to another. I need to pull data from three database queries or have multiple datawarrior tables that allow to group and display partial results. I need multiple tables displayed in datawarrior.
How can I do this?
|
|
|
Re: multiple database queries [message #1412 is a reply to message #1399] |
Thu, 23 September 2021 11:44 ![Go to previous message Go to previous message](/forum/theme/myThemeWithHFCSS/images/up.png) |
thomas
Messages: 696 Registered: June 2014
|
Senior Member |
|
|
Currently, you cannot link a cell of a DataWarrior file to another cell of a different file. Possibly, you can merge your three tables into one DataWarrior file using common identifiers.
A more complicated alternative would be to split the information of files 2 and 3 into small text, html, or even image files located in special folders. If these detail files are named using identifiers used in the first file and if the first file contains information to read detail information from these folders, then the content of the detail files would be shown in the detail area of the first file when moving the mouse from row to row. You could also import the detail text/html/images file content into the first file. The 'flyingObjects.dwar' sample uses this technique.
If you have an HTTP server, which serves detail information using an URL that can be constructed from a general part and an ID, which is part of the first file, you may also define the first file's ID-column to retrieve the respective detail data from the server on request. When running the Wikipedia compounds retrieval, then the file contains backlinks to the Wikipedia page. You can check its 'column properties' section to understand how this is done.
When retrieving Google Patent results, then you get clickable links back to Google servers. You may also check the dwar file for that.
Hope this helps, Thomas
|
|
|