Home » DataWarrior » Functionality » multiple database queries (How to pull multiple datasets in where one can reference data from another)
multiple database queries [message #1399] Wed, 15 September 2021 02:46 Go to next message
nats is currently offline  nats
Messages: 3
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
thomas is currently offline  thomas
Messages: 463
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

Previous Topic: Box Plot - Statistics
Next Topic: similarity_search_protocol
Goto Forum:

Current Time: Sun Oct 24 08:33:43 CEST 2021

Total time taken to generate the page: 0.01639 seconds