Greenstand / Greenstand/treetracker-admin-client
List sessions and wallet registration in grower profile (grower card)
- Dominant language
- JavaScript
- Stars
- 36
- Forks
- 212
- PR merge metrics
- No merged PRs in 30d
Description
It would be very useful to see the wallet_registration from the field_data schema and possibly the sessions in the planter profile card. This would be a quick way to determine which App the user uses. Later all filters should also be extended to session or?
```
SELECT se.*, dc.* FROM field_data."session" se
join field_data.device_configuration dc on
dc.id = se.device_configuration_id
WHERE se.target_wallet = '78064669'
```
```
SELECT se.*, dc.*, wr.*, count(rc.*) FROM field_data."session" se
join field_data.device_configuration dc on
dc.id = se.device_configuration_id
join field_data.raw_capture rc on se.id = rc.session_id
join field_data.wallet_registration wr on wr.id = se.originating_wallet_registration_id
WHERE se.target_wallet = 'felixkhoviwa@hotmail.com' or se.target_wallet = '0995421401'
group by se.id, dc.id, wr.id;
```
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.