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

[sebastiangaertner]

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;

[nmcharlton]

Let's review the design for the Growers tool as part of the domain migration for the Admin Panel. We have a richer and better structured dataset and a more sophisticated set of use cases to accommodate.

[sebastiangaertner]

ok. great.

[dadiorchen]

@nmcharlton do you have any resource in terms of Figma UX prototype or so for the grower tool? Please send it to me so it's easier for me to get involved.

[nmcharlton]

@dadiorchen We don't yet have a design for how to present field data.

The baseline grower details design is in https://www.figma.com/file/G4Kl9fzLRgnk0SaeTne1Mc?node-id=6453:4960

@rgesulfo Would you be able to help us with this design? In particular how to present details for different planing sessions.

In addition to the grower card and details dialog, we will soon have a new tooltip for quicklook details as you hover over a card (#649). I welcome feedback on this approach - it might be cleaner to expand the text section of the grower card on hover.

[ZavenArra]

@Kpoke Can also provide support in terms of the field data schema and API.

[nmcharlton]

@sebastiangaertner There are a lot of fields returned by those queries. Can you clarify what data you need to see against the grower?

You mention "which app the user uses" – are you looking for a device info panel with make, model and app version number? I assume you also want session date, time and capture count. Anything else? Check-in photo? Organization?

I think we'd have a list of expandable sessions (an accordion or similar) with the following breakdown:

session
- check-in photo
- session start datetime
- organization
- capture count
- device info
  - device identifier
  - make/model
  - app version

[pranavkparti]

What is the status of this? I can work on this issue.

[sebastiangaertner]

@pranavkparti please do. Here is a prototype of what Dadio has build. http://dev.dadiorchen.com/

[sebastiangaertner]

@dadiorchen here is the issue.