Greenstand / Greenstand/treetracker-admin-client

List sessions and wallet registration in grower profile (grower card)

Open
#616 14 comments 0 reactions 1 assignee Assigned to @Jaiharishan View on GitHub
dependency: api Hackathon tool: Growers tool: Stakeholders type: enhancement UI/UX
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.