Write query to export JARS lookup spreadsheet

jac-uk / documentation

We are currently updating our documentation and bringing it together in one place. Here.

https://jac-uk.github.io/documentation/

MIT License

0 stars 0 forks source link

Write query to export JARS lookup spreadsheet #25

Closed warrensearle closed 3 years ago

warrensearle commented 3 years ago

Write a query to return the following data:

    candidate name
    exercise name
    exercise id/ref
    application ref
    date

Existing JARS interface can be found here: https://jars.judicialappointments.gov.uk

The JARS source files and database dump are stored on google drive

joy-ade commented 3 years ago

@warrensearle @tomlovesgithub After my meeting yesterday with Sharon she confirmed below Field wouldn't be required then l have deleted it from the requirement.

candidate contact details (email, postal address, phone)

warrensearle commented 3 years ago

Awesome, thanks Joy :)

joy-ade commented 3 years ago

@warrensearle @Tomlovesgithub I have updated the ticket based on the new requirements from Sharon and Matt. I hope this is clearer and achievable.

KateMJAC commented 3 years ago

Jeremy is liaising with Matt on this item.