Home › Forums › Users › General User's Discussion ›

Does a report to search by problem exist?

Submitted by Guest on Sat, 10/10/2015 - 05:39
in

Good afternoon all. 

I cannot locate a report to search by problem. I was hoping that someone might already have one created before I reinvent the wheel.

Thanks in advance.

Alan

‹ Should reversing transaction have the same date as the reversed one Delect Customer Invoice warning ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Does a report to search by problem exist?

Submitted by tgething (not verified) on Sat, 10/10/2015 - 08:04.

Alan - I suspect that I can probably knock one up faster than you - and I think that the one to clone from is the Patient History Search - whose parameters are as follows:

Given that the act.patientClinicalProblem archetype is:

I suspect that you will want to search both the Presenting Complaint and Diagnosis fields

Given that the Patient History Search output looks like

do we just replace the notes text by both the Presenting Complaint and Diagnosis fields?

Note that the Patient History Search's explanatory text is:


I would expect the Patient Problem Search to work the same way except that it would search both the compaint and diagnosis.  However, given that the problem fields are:

Q1: should the search be of the Complaint & Diagnosis name or desription fields or both?  My vote is Yes and that it should be an OR search - ie the name or description contains the search text.

Q2: should the complaint & diagnosis matching be an AND or an OR condition? My vote is OR - ie "show problems where Diagnosis contains xxx OR Complaint contains yyy" rather than "show problems where Diagnosis contains xxx AND Complaint contains yyy"

Q3: should the Status be a search criteria or just an output - ie should one be able to search for unresolved problems?  My vote is No - just display the status & resolved date.

 

Alan - can you give me your input and I will build the report.

Regards, Tim G

Re: Does a report to search by problem exist?

Submitted by activet on Wed, 21/10/2015 - 13:00.

Hi Tim,

Just wondering if your proposed report is for a single patient or searching the entire database to list all patients that will fulfill the search criteria? I'm not sure if Alan was thinking the same way as I did that it would be useful to generate a report to list all patients with a specific problem/presenting complaint.

Kind regards,

Anthony (ActiVet)

Re: Does a report to search by problem exist?

Submitted by tgething (not verified) on Wed, 21/10/2015 - 14:08.

Anthony - it will return all patients that match the selection conditions. So if you ask for all speciea, all breeds, all clincians, date from 1/1/14 to today, presenting compaint = %epi you will get all the patients who presented since 1/1/14 with the following:

plus any others who presenting complaint Description contains "epi"

 

I am still awaiting Alan B's replies to my questions.

Regards, tim

Re: Does a report to search by problem exist?

Submitted by tgething (not verified) on Sun, 08/11/2015 - 10:45.

No response from Alan B so I built it the way I thought it should be.  I have placed it in the Resource Library - see http://www.openvpms.org/customisation/patient-problem-search

I would appreciate it if people have a play and suggest any modifications.

Note that the OR search is in fact using the rlike operator, and more complicated search expressions are possible. I did consider having a 'Use Regex' parameter and allow a full regex expression.  However I thought that since the vast majority of what regex is needed for is a simple OR search, it was best to use the approach taken - ie the the user enters 'abcd|efgh' as the text (meaning find stuff containing 'abcd' or 'efgh') and the code automatically switches to use rlike '(abcd|efgh)'.

Regards, Tim G

Syndicate content