when i am running above script i am able to find for how many patients i wrote particular medication which is a global field giving it as script parameter , but i want to search with date range as u can see in the image , i am trying to give it as script parameter 2 into pdate as u can see in image , but i m not able to do it can some help me please hope u understand

First of all you'll need to learn about the different parameter passing options that people use. There are a lot of them out there so pick one that a lot of people support. I still use the sixfriedrice method a different that hasn't let me down though working at different companies I see that there are a lot of choices out there.

Second, you should store the medication prescriptions in a prescription table. You can call it Prescription and link it to the person. Then auto-enter the creation date so you will see when a medicine or two were prescribed.

Then learn about looping if you want to find by multiple search criteria and create the new records so you can shorten your script by quite a lot.

 But I think that if you swap out the right side of the white fields to one portal you won't be needed to loop, you will be able to find a certain medicine prescribed within a time frame.

Edited December 16, 20178 yr by Agnes Riley

separately i am getting correct result but i want to mix both help me plz

Did you read what I wrote?

3 minutes ago, Agnes Riley said:

Did you read what I wrote?

yes i did , did same thing u said but cant mix both criteria

first i want drug count then from the found set i want the date range script to run

like this where am i going wrong ????

 

Edited December 16, 20178 yr by Dr.Gopala krishnam raju AMBATI

Set variable date and then add the other criteria right underneath in one script. Then perform find. Make sure nothing is left in the perform find.

Edited December 16, 20178 yr by Agnes Riley

6 minutes ago, Agnes Riley said:

Set variable date and then add the other criteria right underneath in one script. Then perform find. Male sure nothing is left in the perform find.

with this i am getting total drug count global date range not searching y ????

Edited December 16, 20178 yr by Dr.Gopala krishnam raju AMBATI

I'm getting lost here. What is global? I can't see any globals here.

Delete all those from the perform find dialog. Use a loop and loop though the many fields you have (again instead of a table and a portal) and create a new find request. Add the date to every find request.

12 minutes ago, Agnes Riley said:

I'm getting lost here. What is global? I can't see any globals here.

Delete all those from the perform find dialog. Use a loop and loop though the many fields you have (again instead of a table and a portal) and create a new find request. Add the date to every find request.

hope u will get some idea ?

Edited December 16, 20178 yr by Dr.Gopala krishnam raju AMBATI

working yaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaay any other method kindly guide me plz