Skip to content

Databrowser > Detailed Querying #68

@cf7

Description

@cf7

There are two key features that SPY staff will need come June which have not been implemented yet . . .

Advanced QueryBuilding

  • the ability to chain more WHERE conditions with AND's and OR's

Use Case:
Search the RESOURCE client [WHERE first_name is exactly "John" ] AND [WHERE last_name is exactly "Doe"]

query_building

Views

  • the ability to save and restore the result of a past query

Use Case:
Save the above built query into a View called "John Doe's profile" that can be retrieved later with a single click

views

The are several other features in other parts of the app that Databrowser will have to pick up slack for. For example, the Frontdesk page needs to have displays for past DropIn Sessions and all of the enrollment and checkin data associated with each DropIn (#43). However, due to time constraints, we will have to settle for letting Databrowser handling that kind of querying since Databrowser is a "query-everything" page.

Files:
static/js/search.js
templates/search.html

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions