Opened 13 years ago
Last modified 13 years ago
#385 closed task
Export information needed by the tumor registry — at Version 1
Reported by: | Nicklas Nordborg | Owned by: | Nicklas Nordborg |
---|---|---|---|
Priority: | major | Milestone: | Reggie v2.6 |
Component: | net.sf.basedb.reggie | Keywords: | |
Cc: |
Description (last modified by )
The current information is that we need a comma-separated file with personal number, operation date and site. The list should be generated for a given month at a time.
The main query should find all Specimen
and NoSpecimen
items with a 'Created' date falling in the selected month. It should only exclude core biopsy items and other items annotated with the BiopsyType
annotation (unless the value is SpecimenSurgery
).
Once we have this list the patient can be found by loading the parent of the parent (eg. Specimen->Case->Patient
) and then the personal number can be found.
The site can be found by inspecting the name of the specimen item.
Duplicates (eg. bilateral cases) should be removed from the list.