Database connection [message #1386] |
Mon, 30 August 2021 05:13 ![Go to next message Go to next message](/forum/theme/myThemeWithHFCSS/images/down.png) |
nats
Messages: 6 Registered: August 2021
|
Junior Member |
|
|
Is it possible to save a file and have the database queried automatically from a saved database connection and query (like reporting/BI software) or is a saved file just data that was retried from the database at the time of creating the file?
|
|
|
Re: Database connection [message #1389 is a reply to message #1386] |
Wed, 01 September 2021 13:17 ![Go to previous message Go to previous message](/forum/theme/myThemeWithHFCSS/images/up.png) ![Go to next message Go to next message](/forum/theme/myThemeWithHFCSS/images/down.png) |
thomas
Messages: 696 Registered: June 2014
|
Senior Member |
|
|
I am not sure, whether I understand the question. If you query a database, e.g. Chembl, then the result is a subset in an open DataWarrior window. If you save the window, the subset is stored in a file. If the original Chembl database is updated, it does not change the saved file.
You may, of course, create a macro that queries the Chembl database, creates views, merges other data, or does some other fancy stuff with the query result. If you run the macro at a later time after Chembl update, then it does the same thing with the the query result of a different, up-to-date query result.
This applies to all databases that DataWarrior is able to query including your in-house databases if you use plain SQL or have build a plugin for.
Does this answer the question?
|
|
|
|