openmolecules.org

 
Home » DataWarrior » Cheminformatics » Link to oracle per row
Link to oracle per row [message #1850] Fri, 17 February 2023 17:28 Go to next message
de_maas is currently offline  de_maas
Messages: 2
Registered: February 2023
Junior Member
Hi All,

I want to retrieve data from my oracle database using an id stored in my Datawarrior file. Is it possible to pass a identifier to the SQL somehow? I tried this but it isn't working:

SELECT AVAILABILITY
FROM availability_info
WHERE description=$idnumber

I can't find the right synthax to do this. Same goes for the URL.

Thanks,

Peter
Re: Link to oracle per row [message #1851 is a reply to message #1850] Sun, 19 February 2023 20:28 Go to previous messageGo to next message
thomas is currently offline  thomas
Messages: 666
Registered: June 2014
Senior Member
I just deployed an update that allows exactly that: Using "IN($IDNUMBER)" in the WHERE clause of an SQL statement does an on-the-fly replacement with all entries from the IDNUMBER columns to "IN('entry1','entry2','entry3',...)". If the idea is to merge the retrieved information with the currently open file, this still has to be done in a separate step.

Thomas
Re: Link to oracle per row [message #1852 is a reply to message #1851] Mon, 20 February 2023 10:28 Go to previous message
de_maas is currently offline  de_maas
Messages: 2
Registered: February 2023
Junior Member
Thanks Thomas,

This already is a nice feature for me and merging works fine.

Cheers,

Peter
Previous Topic: Generate 2D atom coordinates gives overlapping atoms
Next Topic: Searching multiple structures in Google patents via "selected compounds"
Goto Forum:
  


Current Time: Wed May 22 06:20:30 CEST 2024

Total time taken to generate the page: 0.03937 seconds