multiple GEM identifier in standalone dashboard
Posted: Thu Jul 06, 2017 5:44 pm
Hello,
I am running two GEMs and collecting data using standalone dashboard.
For one GEM, I retrieved data by using "SELECT * FROM `minutedata` WHERE channel_id=x;" query in phpMyAdmin.
However, how can I separate each GEM's data from the same table?
I can find only one `minutedata` table in `dashboard` database. There is `devices` table, but no foreign key was found in `minutedata` from the `devices` table.
I think I can add foreign key on database, but I guess the data is already separated because when I looked at the line graph in each GEM, the two GEM's data are separated.
Thanks for the answers!
I am running two GEMs and collecting data using standalone dashboard.
For one GEM, I retrieved data by using "SELECT * FROM `minutedata` WHERE channel_id=x;" query in phpMyAdmin.
However, how can I separate each GEM's data from the same table?
I can find only one `minutedata` table in `dashboard` database. There is `devices` table, but no foreign key was found in `minutedata` from the `devices` table.
I think I can add foreign key on database, but I guess the data is already separated because when I looked at the line graph in each GEM, the two GEM's data are separated.
Thanks for the answers!