Hi all,
Can someone explain how are variables passed between linked protocols?
I have developed SQL queries reporting (in a pie chart) on designed and synthesized compounds to date. I also have a query in SQL that describes how many compounds each user has synthesized for each month.
The challenge, now, is how to link these queries together. I want to be able to link from the synthesized compounds by month to a breakdown for the clicked month by user. That is, the starting pie chart breaks down synthesized compounds by month. If I click on the "April" slice then a protocol is run reporting how many compounds each scientist synthesized in April.
I can link the two protocols together, but I do not know how to supply the month constraint across the protocols in a variable as well as supplying that variable to the SQL query.
Thanks!
Can someone explain how are variables passed between linked protocols?
I have developed SQL queries reporting (in a pie chart) on designed and synthesized compounds to date. I also have a query in SQL that describes how many compounds each user has synthesized for each month.
The challenge, now, is how to link these queries together. I want to be able to link from the synthesized compounds by month to a breakdown for the clicked month by user. That is, the starting pie chart breaks down synthesized compounds by month. If I click on the "April" slice then a protocol is run reporting how many compounds each scientist synthesized in April.
I can link the two protocols together, but I do not know how to supply the month constraint across the protocols in a variable as well as supplying that variable to the SQL query.
Thanks!