Searching for species

Submitted by bellvet on Wed, 03/06/2009 - 11:08

General User's Discussion

Hi,

One of our vets wants to get a list of all the rabbits in our system.

Is there a way I can do a species/breed search?

Sandra.

Re: Searching for species

Submitted by Tony De Keizer (not verified) on Wed, 03/06/2009 - 17:00.

Hi Sandra,

No current way to do this using the patient search but it would be quite easy to create a report to allow you to list them filtered by species and other criteria if required.

Cheers Tony

On 3/06/09 10:08 AM, "Sandra" :

> Hi, > > One of our vets wants to get a list of all the rabbits in our system. > > Is there a way I can do a species/breed search? > > Sandra. > _______________________________________________ > OpenVPMS User Mailing List > users@lists.openvpms.org > To unsubscribe or change your subscription visit: > http://lists.openvpms.org/listinfo/users > Posts from this mailing list can be viewed online and replied to in the > OpenVPMS User's forum- http://tinyurl.com/openvfu

_______________________________________________ OpenVPMS User Mailing List users@lists.openvpms.org To unsubscribe or change your subscription visit: http://lists.openvpms.org/listinfo/users Posts from this mailing list can be viewed online and replied to in the OpenVPMS User's forum- http://tinyurl.com/openvfu

Species searching

Submitted by paravet (not verified) on Sat, 13/06/2009 - 14:22.

If it is easy to create this report would it also be easy to add optional fields for age and sex as well?

This would be very useful but I suppose it may duplicate some of the work being done for general data export request

Cheers,

Nick

Searching for species

Submitted by tony on Sun, 14/06/2009 - 15:39.

Hi Guys,

I have created a Patient List Report templaet and placed in the shared resources area. It allows you to list customer and patient details and filter by species, breed and date of birth range.

Hopefully thsi is of some use.

Cheers

Tony

Species

Submitted by paravet (not verified) on Sun, 14/06/2009 - 16:10.

Thanks for rapid action Tony,

Nick

Searching for new breeds

Submitted by Geoffvet on Mon, 15/06/2009 - 00:39.

Hi Tony,

This new report will prove very useful to all .

One problem I have is that if the date of birth isn't entered for a patient the animal is left out of the report entirely.

How can I alter it so that if the age field is empty on the patient record the rest of its details won't be left out of the report.

Many of our patients are Pig Dogs and the details we are transferring from the old card files are incomplete - many just have a name -usually not a very flattering one.

[Please note I have edited this comment.

I was having a problem with in that new Breeds I had entered weren't generating reports. I have remedied the problem by deleting the new breeds and reentering them - it may have been due to the computer date issue I had earlier.]

Thanks Geoff

Re: Searching for new breeds

Submitted by Tony De Keizer (not verified) on Mon, 15/06/2009 - 11:00.

Hi Geoff,

Not sure why the Pig Dog breed is not working as expected. Will do some tests here. Have you tried appending a wildcard at the end i.e % ?

Can modify report to take into account null birthdates i.e include them always if that is what you think is required ...

Cheers Tony

On 14/06/09 10:37 PM, "Geoffsim@Yahoo. Au" :

> Hi Tony,

Thanks Tony this new report will prove very useful to all .

There are

> a couple of issues I have found. None of the breeds or crosses that I have

> entered myself under Breed lookups will produce a report. I have, for instance > entered Pig Dog, as a breed but when entered in the report field it produces a > blank page. The breed is associated with canine correctly in lookups and comes > up in the dropdown box on the patient as it should. Enter one of the

> predefined species and alls well - and I get a report with owner, address > ,patient, dob and species. Well almost all well. If the date of birth isnt

> entered for a patient the animal is left out of the report entirely. How can I > alter it so that if the age field is empty on the patient record the rest of > its details wont be left out of the report. Many of our patients are Pig Dogs

> and the details we are transferring from the old card files are incomplete - > many just have a name -usually not a very flattering one. (I did check that

> there were some Pig Dogs with ages against there records - so its not > incomplete fields stopping New Breeds generating reports). Thanks

> Geoff

_______________________________________________

OpenVPMS User Mailing

> List

users@lists.openvpms.org

To unsubscribe or change your subscription

> visit:

http://lists.openvpms.org/listinfo/users

Posts from this mailing list

> can be viewed online and replied to in the OpenVPMS User's forum- > http://tinyurl.com/openvfu

Re: Searching for new breeds

Submitted by Tony De Keizer (not verified) on Mon, 15/06/2009 - 11:00.

Hi Geoff,

Actually I think I have worked out what is wrong. My fault as I wasn't comparing the breed range against the name but the code which has spaces etc replaced with underscores. I have modified the report to fix this.

Have added a check for null birth date but not sure if will always work due to way certain database details are stored if they are missing. Test and see

Have uploaded modified report to web site ... Cheers Tony

On 15/06/09 9:07 AM, "Tony De Keizer" :

> Hi Geoff, > > Not sure why the Pig Dog breed is not working as expected. Will do some > tests here. Have you tried appending a wildcard at the end i.e % ? > > Can modify report to take into account null birthdates i.e include them > always if that is what you think is required ... > > Cheers > Tony > > > On 14/06/09 10:37 PM, "Geoffsim@Yahoo. Au" : > >> Hi Tony, > Thanks Tony this new report will prove very useful to all . > There are >> a couple of issues I have found. > None of the breeds or crosses that I have >> entered myself under Breed lookups will produce a report. I have, for >> instance >> entered Pig Dog, as a breed but when entered in the report field it produces >> a >> blank page. The breed is associated with canine correctly in lookups and >> comes >> up in the dropdown box on the patient as it should. > Enter one of the >> predefined species and alls well - and I get a report with owner, address >> ,patient, dob and species. > Well almost all well. If the date of birth isnt >> entered for a patient the animal is left out of the report entirely. How can >> I >> alter it so that if the age field is empty on the patient record the rest of >> its details wont be left out of the report. > Many of our patients are Pig Dogs >> and the details we are transferring from the old card files are incomplete - >> many just have a name -usually not a very flattering one. > (I did check that >> there were some Pig Dogs with ages against there records - so its not >> incomplete fields stopping New Breeds generating reports). > Thanks >> Geoff > _______________________________________________ > OpenVPMS User Mailing >> List > users@lists.openvpms.org > To unsubscribe or change your subscription >> visit: > http://lists.openvpms.org/listinfo/users > Posts from this mailing list >> can be viewed online and replied to in the OpenVPMS User's forum- >> http://tinyurl.com/openvfu > > > _______________________________________________ > OpenVPMS User Mailing List > users@lists.openvpms.org > To unsubscribe or change your subscription visit: > http://lists.openvpms.org/listinfo/users > Posts from this mailing list can be viewed online and replied to in the > OpenVPMS User's forum- http://tinyurl.com/openvfu

Re: Searching for new breeds

Submitted by Geoffvet on Mon, 15/06/2009 - 13:15.

Hi Tony,

Thanks thats sorted the name search.

The patients without birthdates still do not appear though .These include chickens, budgies, rabbits,etc - which often don't have ages assigned - so over time those left out will mountup.

I can workaround it assign them all dob of 1/1/2008 and sort it that way.

I actually tried the null expression you've added last night but had my brackets wrong but at least I was on the right track.

As you say its probably how a missing value is handled in the database is it a null value, a 0 or something else being a date?

I can produce all the patients in a report by removing the date and date of birth fields. I then tried re entering date of birth field to the report but run into the same problem with 'null' values.

Thanks Geoff

Re: Searching for new

Submitted by Tony De Keizer (not verified) on Mon, 15/06/2009 - 18:00.

Hi Geoff

To fix this you need to make the following change to the data query in the report.Change line :

join entity_details d1 on d1.entity_id = p.entity_id and d1.name = "dateOfBirth"

to:

left outer join entity_details d1 on d1.entity_id = p.entity_id and d1.name = "dateOfBirth"

Cheers Tony

On 15/06/09 12:15 PM, "Geoffsim@Yahoo. Au" :

Hi Tony, Thanks thats sorted the name search.

The patients without

> birthdates still do not appear though .These include chickens, budgies, > rabbits,etc - which often don't have ages assigned - so over time those left > out will mountup. I can workaround it assign them all dob of 1/1/2008 and sort

> it that way. I actually tried the null expression you've added last night but

> had my brackets wrong but at least I was on the right track. As you say its

> probably how a missing value is handled in the database is it a null value, a > 0 or something else being a date? I can produce all the patients in a report

> by removing the date and date of birth fields. I then tried re entering date > of birth field to the report but run into the same problem with 'null' > values.

Thanks

> Geoff

_______________________________________________

OpenVPMS User Mailing

> List

users@lists.openvpms.org

To unsubscribe or change your subscription

> visit:

http://lists.openvpms.org/listinfo/users

Posts from this mailing list

> can be viewed online and replied to in the OpenVPMS User's forum- > http://tinyurl.com/openvfu