Hi all,
Am looking for a solution in which biomart would display data belonging
to (or associated with) a given user.
We have a web application requirement in which users may submit data
into the database and would like to query this data using Biomart,
ideally the user should only see the data they just submitted (maybe a
later requirement would be that they would like to view data they have
cummulatively submitted over time - we can ignore this for now).
One way to do this would be to assign an obscure id value to the user
(in our custom application) and generate a hyperlink with query string
containing the obscure id value. On accessing Biomart using this link,
Biomart would (somehow process GET request obtain the obscure id) and
pre-initialize the 'filter' for id with this value.
In the meantime the Biomart's DB would have had it's tables populated
with the data (fetched from a transaction database) submitted by the
user the corresponding record(s) in the main table would contain the
user's obscure id value in one of it's attributes. Which would mean that
only one Biomart DB stores data submitted by several users but they may
only view data they have submitted.
Therefore my question is: is there a way to preinitialize (populate) a
filter (permanently) in biomart from a http GET command?
And is a way to dyamically (not at design time) populate drop down lists?
Allan.
