Getting data from a database to create a dynamic combo box
Hi, I need to create a combo box that will take data from a database dynamically. How could I do this? Thank you
Hi Ramon, depends a little bit on what you mean with 'dynamically'. I have some wrappers that may be interesting for you: https://github.com/bgruening/galaxytools/tree/master/chemicaltoolbox/pgchem/... Basically, you can choose the Database/Scheme dynamically and the SQL query is also constructed dynamically. Cheers, Bjoern
Hi, I need to create a combo box that will take data from a database dynamically. How could I do this?
Thank you
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
Ok. In fact I need that the combo box of my tool uses items from a database, then whenever someone accesses the combo box items should be updated as I have in the database, so dynamically it may be that every time the user accesses the tool there are new options in the combo box to choose it.
Subject: Re: [galaxy-dev] Getting data from a database to create a dynamic combo box From: bjoern.gruening@pharmazie.uni-freiburg.de To: ramao_tiago_tiburski@hotmail.com CC: galaxy-dev@bx.psu.edu Date: Fri, 16 Aug 2013 07:52:10 +0200
Hi Ramon,
depends a little bit on what you mean with 'dynamically'. I have some wrappers that may be interesting for you:
https://github.com/bgruening/galaxytools/tree/master/chemicaltoolbox/pgchem/...
Basically, you can choose the Database/Scheme dynamically and the SQL query is also constructed dynamically.
Cheers, Bjoern
Hi, I need to create a combo box that will take data from a database dynamically. How could I do this?
Thank you
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
Hi, that can be tricky I guess. What you can always do is to write your own data_source application. Basically, you write your own small webpage with all the magic you need and only transfer the data you need. Like the UCSC genome browser. A really small example can be found here (without SQL): https://github.com/bgruening/galaxytools/tree/master/chemicaltoolbox/data_so... Hope that helps, Bjoern
Hi, I need to create a combo box that will take data from a database dynamically. How could I do this?
Thank you
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
I will try it. Thank you for the help.
Subject: Re: [galaxy-dev] Getting data from a database to create a dynamic combo box From: bjoern.gruening@gmail.com To: ramao_tiago_tiburski@hotmail.com CC: galaxy-dev@bx.psu.edu Date: Fri, 16 Aug 2013 13:21:40 +0200
Hi,
that can be tricky I guess. What you can always do is to write your own data_source application. Basically, you write your own small webpage with all the magic you need and only transfer the data you need. Like the UCSC genome browser.
A really small example can be found here (without SQL): https://github.com/bgruening/galaxytools/tree/master/chemicaltoolbox/data_so...
Hope that helps, Bjoern
Hi, I need to create a combo box that will take data from a database dynamically. How could I do this?
Thank you
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
On 08/16/2013 01:21 PM, Bjoern Gruening wrote:
Hi,
that can be tricky I guess. What you can always do is to write your own data_source application. Basically, you write your own small webpage with all the magic you need and only transfer the data you need. Like the UCSC genome browser.
A really small example can be found here (without SQL): https://github.com/bgruening/galaxytools/tree/master/chemicaltoolbox/data_so...
Hope that helps, Bjoern
as an alternative, see this old e-mail thread http://tinyurl.com/6uom4uo Regards, Hans-Rudolf
Hi, I need to create a combo box that will take data from a database dynamically. How could I do this?
Thank you
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
I had tried a few things with this link, but I could not, I must be doing something wrong.
Date: Fri, 16 Aug 2013 14:45:18 +0200 From: hrh@fmi.ch To: ramao_tiago_tiburski@hotmail.com CC: galaxy-dev@bx.psu.edu Subject: Re: [galaxy-dev] Getting data from a database to create a dynamic combo box
On 08/16/2013 01:21 PM, Bjoern Gruening wrote:
Hi,
that can be tricky I guess. What you can always do is to write your own data_source application. Basically, you write your own small webpage with all the magic you need and only transfer the data you need. Like the UCSC genome browser.
A really small example can be found here (without SQL): https://github.com/bgruening/galaxytools/tree/master/chemicaltoolbox/data_so...
Hope that helps, Bjoern
as an alternative, see this old e-mail thread
Regards, Hans-Rudolf
Hi, I need to create a combo box that will take data from a database dynamically. How could I do this?
Thank you
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
Hi Ramon You need to provide the code you have written and the error messages you get. Otherwise, it is very difficult for the community to help you. Regards, Hans-Rudolf On 08/16/2013 03:43 PM, Ramon Tiburski wrote:
I had tried a few things with this link, but I could not, I must be doing something wrong.
Date: Fri, 16 Aug 2013 14:45:18 +0200 From: hrh@fmi.ch To: ramao_tiago_tiburski@hotmail.com CC: galaxy-dev@bx.psu.edu Subject: Re: [galaxy-dev] Getting data from a database to create a dynamic combo box
On 08/16/2013 01:21 PM, Bjoern Gruening wrote:
Hi,
that can be tricky I guess. What you can always do is to write your own data_source application. Basically, you write your own small webpage with all the magic you need and only transfer the data you need. Like the UCSC genome browser.
A really small example can be found here (without SQL):
https://github.com/bgruening/galaxytools/tree/master/chemicaltoolbox/data_so...
Hope that helps, Bjoern
as an alternative, see this old e-mail thread
Regards, Hans-Rudolf
Hi, I need to create a combo box that will take data from a database dynamically. How could I do this?
Thank you
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
I solved my problem using dynamic_options. Thank you
Date: Mon, 19 Aug 2013 09:14:28 +0200 From: hrh@fmi.ch To: ramao_tiago_tiburski@hotmail.com CC: galaxy-dev@bx.psu.edu Subject: Re: [galaxy-dev] Getting data from a database to create a dynamic combo box
Hi Ramon
You need to provide the code you have written and the error messages you get. Otherwise, it is very difficult for the community to help you.
Regards, Hans-Rudolf
On 08/16/2013 03:43 PM, Ramon Tiburski wrote:
I had tried a few things with this link, but I could not, I must be doing something wrong.
Date: Fri, 16 Aug 2013 14:45:18 +0200 From: hrh@fmi.ch To: ramao_tiago_tiburski@hotmail.com CC: galaxy-dev@bx.psu.edu Subject: Re: [galaxy-dev] Getting data from a database to create a dynamic combo box
On 08/16/2013 01:21 PM, Bjoern Gruening wrote:
Hi,
that can be tricky I guess. What you can always do is to write your own data_source application. Basically, you write your own small webpage with all the magic you need and only transfer the data you need. Like the UCSC genome browser.
A really small example can be found here (without SQL):
https://github.com/bgruening/galaxytools/tree/master/chemicaltoolbox/data_so...
Hope that helps, Bjoern
as an alternative, see this old e-mail thread
Regards, Hans-Rudolf
Hi, I need to create a combo box that will take data from a database dynamically. How could I do this?
Thank you
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/
To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/
participants (4)
-
Bjoern Gruening -
Björn Grüning -
Hans-Rudolf Hotz -
Ramon Tiburski