Exclusive SAVE lock

classic Classic list List threaded Threaded
13 messages Options
Reply | Threaded
Open this post in threaded view
|

Exclusive SAVE lock

Patti Rodger Kirkpatrick
Can anyone provide any information about this EXCLUSIVE Save LOCK that pops up in OSCAR 15.  It randomly appears in the chart notes...and in some cases prohibits the user from saving.

I'd like to turn it off...but I don't know where it's coming from!  

Any ideas welcome!

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: [OSCAR-advanced-users] Exclusive SAVE lock

John Yap-2
I have seen this - all too often.  But it doesn’t seem to block me from re-accessing the chart, nor does it appear to cause data loss. Usually, it’s in the context of (sorry) setting up a GreaseMonkey script to set myself as the default biller.  I see the “lock” screen, and have to return to the billing screen via pt master demographics.  But now my default is set for the rest of the day, and the billing page is no longer a problem.  But the Lock will still appear, at times, when entering a chart outside of the schedule view.  The pattern is not clear to me except for the grease monkey scenario.  

Given OSP dislike for GM, I’m sure that you are experiencing this outside of the Monkey’s influence.  

My experience is that it’s a nuisance, but otherwise benign.  I’d like to know what the original intent was.

A more worrisome behaviour is the inactivation of autosave in Oscar15.  YES - autosave is set for every 5 seconds when active in the encounter screen.  But venture away - e.g. to an eForm, Tickler, Msg, Preventions, etc - and then return to the encounter page without additional input in the active note field, and watch all that hard work disappear.  I’ve done this before - too many times, and even today!

Typical scenario - I start a note, but don’t finish.  It’s autosaved.  Perfect!   But then re-enter the chart, fiddle with a Prevention, Tickler, Msg, etc - and then leave the chart without additional characters added to the encounter field - which would turn on autosave.  Come back - auto save has been wiped.  The entire note is gone!  Normally, you cannot wipe your prints off the chart that easily.   The date entry, at least, is captured for your eventual return.  But not with this bug/feature?!  Fortunately, the measurements, Tickler, eForm, Msg, whatever you touched to trigger the bug - all that input IS saved!

JohnY

> On Feb 13, 2018, at 11:50 AM, Patti Rodger Kirkpatrick <[hidden email]> wrote:
>
> Can anyone provide any information about this EXCLUSIVE Save LOCK that pops up in OSCAR 15.  It randomly appears in the chart notes...and in some cases prohibits the user from saving.
>
> I'd like to turn it off...but I don't know where it's coming from!  
>
> Any ideas welcome!
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
> OSCARmcmaster-advanced-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: [OSCAR-advanced-users] RBT Syntax

John Yap-2
To the Report By Template/database query experts out there….

My associate is an up and coming RBT guru who needs a bit of guidance.  His question:

Do you know if anyone has documented the syntax for RBTs anywhere?  I know there are a ton of examples, but I'm wondering if anyone has really laid out what's possible and what's not in the RBT.

An example: I'd like to have default values for the parameters of a RBT.  I have no idea how to make that happen, though.


I think he’d like to query the database to allow for range filters, etc.  This is part of the work towards the patient medical home concept.

Any advice would be welcome.

Thanks,

JohnY

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: Exclusive SAVE lock

Colcamex Resources Inc.
In reply to this post by Patti Rodger Kirkpatrick

Is this the same save lock that pops up when an encounter note is entered into a patient file by another provider that is not signed?   Are there any unsigned notes in the patient file?


Dennis Warren, Manager
Colcamex Resources Inc.
[hidden email] | colcamex.com | 778.386.9264

On Feb 13, 2018, at 11:50 AM, Patti Rodger Kirkpatrick <[hidden email]> wrote:

Can anyone provide any information about this EXCLUSIVE Save LOCK that pops up in OSCAR 15.  It randomly appears in the chart notes...and in some cases prohibits the user from saving.

I'd like to turn it off...but I don't know where it's coming from!  

Any ideas welcome!
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: [OSCAR-advanced-users] Exclusive SAVE lock

John Yap-2
When I see it, no one else is logged into the chart - but me.  It is different from the “you have started work on another workstation” (I’m paraphrasing here) - and "do you want to continue" message.  Whatever action is desired comes to a stop with the message - “…Exclusive Save Lock…”.  There are no missing notes.  I just want the billing screen to pop up usually, so I have to go back 3 steps and start over!

JohnY

On Feb 15, 2018, at 4:42 PM, Colcamex Resources Inc. <[hidden email]> wrote:


Is this the same save lock that pops up when an encounter note is entered into a patient file by another provider that is not signed?   Are there any unsigned notes in the patient file?


Dennis Warren, Manager
Colcamex Resources Inc.
[hidden email] | colcamex.com | 778.386.9264

On Feb 13, 2018, at 11:50 AM, Patti Rodger Kirkpatrick <[hidden email]> wrote:

Can anyone provide any information about this EXCLUSIVE Save LOCK that pops up in OSCAR 15.  It randomly appears in the chart notes...and in some cases prohibits the user from saving.

I'd like to turn it off...but I don't know where it's coming from!  

Any ideas welcome!
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: [OSCAR-advanced-users] RBT Syntax

John Robertson-2
In reply to this post by John Yap-2
Isn't Rbt basically Sql? JohnR 

On Feb 15, 2018 18:55, "John Yap M.D." <[hidden email]> wrote:
To the Report By Template/database query experts out there….

My associate is an up and coming RBT guru who needs a bit of guidance.  His question:

Do you know if anyone has documented the syntax for RBTs anywhere?  I know there are a ton of examples, but I'm wondering if anyone has really laid out what's possible and what's not in the RBT.

An example: I'd like to have default values for the parameters of a RBT.  I have no idea how to make that happen, though.


I think he’d like to query the database to allow for range filters, etc.  This is part of the work towards the patient medical home concept.

Any advice would be welcome.

Thanks,

JohnY

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: [OSCAR-advanced-users] RBT Syntax

Earl Wertheimer
Yes and no.

The basic query IS MySQL. ie the SELECT etc...

The undocumented part are the parameters, that allow us to ask the user to enter information that can be used to alter the MySQL query.

This stuff:

<param id="provider" type="list" description="Provider">
   <param-query>
      ( select distinct provider_no, concat(last_name,',',first_name,'(',provider_no,')') as name 
         from provider where provider_type = 'doctor' and status = 1 )
      UNION
      ( select ' ALL', 'All providers' )
      order by provider_no ;
   </param-query>
</param> 
<param id="date_start" type="date" description="Start Date" />
<param id="date_end" type="date" description="End Date" />

There is a program that evaluates all the 'param' items and creates a nice web form.

So  the RbT parameters
<param id="date_start" type="date" description="Start Date" />

becomes

<input type="text" class="datefield" id="datefield1" name="date_start">
  <a id="obsdate1"><img title="Calendar" src="../../images/cal.gif" alt="Calendar" border="0" /></a> 
  <script type="text/javascript">Calendar.setup( { inputField : "datefield1", ifFormat : "%Y-%m-%d", showsTime :false, button : "obsdate1", singleClick : true, step : 1 } );</script>  


The types of input, etc are what John is looking for...

Plan B is to collect/write documentation and update the manual page:





On Thu, Feb 15, 2018 at 10:28 PM, John Robertson <[hidden email]> wrote:
Isn't Rbt basically Sql? JohnR 

On Feb 15, 2018 18:55, "John Yap M.D." <[hidden email]> wrote:
To the Report By Template/database query experts out there….

My associate is an up and coming RBT guru who needs a bit of guidance.  His question:

Do you know if anyone has documented the syntax for RBTs anywhere?  I know there are a ton of examples, but I'm wondering if anyone has really laid out what's possible and what's not in the RBT.

An example: I'd like to have default values for the parameters of a RBT.  I have no idea how to make that happen, though.


I think he’d like to query the database to allow for range filters, etc.  This is part of the work towards the patient medical home concept.

Any advice would be welcome.

Thanks,

JohnY

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: [OSCAR-advanced-users] RBT Syntax

Eugene Robertus
In reply to this post by John Robertson-2
It is, but as I understand the question, he wants to preset default values
for parameters (like for a set of date fields, you may want to preset
date_sub(curdate() interval 30 day).  Or, for provider list that is produced
by a SQL query, you may want to default to currently logged provider.  I
haven't seen that in any documentation or examples. It would be definitely
nice to have such ability.  



--
Sent from: http://oscarmcmaster.16.x6.nabble.com/oscarmcmaster-devel-f3244825.html

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: [OSCAR-advanced-users] RBT Syntax

John Yap-2
In reply to this post by Earl Wertheimer
Thank you Earl.  I’m quite a luddite when it comes to MySQL and RBT’s.  I asked Paras to clarify what he was trying to accomplish.  

His challenge:

In writing reports by template, there is a language used to describe the input fields the user can set. For example,

<param id="provider" type="list" description="Provider"> 
<param-query>select provider_no, CONCAT(last_name) from provider WHERE status='1' 
	AND provider_type='doctor' 
	AND ohip_no>1 
ORDER BY last_name;</param-query> </param>

The RBT then lets you insert “provider” into the SQL query. 

I am wondering if there is any documentation for these “param” tags. Specifically, I am wondering if you can set a default value. For example, there are many reports that we use for billing that look at fee items billed in a certain date range. It would be nice to allow the user to set this range but also to set a default range (e.g. Jan 1 - Dec 31 of the current year. ) I am wondering if there is any way to do that but I cannot find documentation for the “param” settings for the report. 

Does that make sense?

Maybe that helps to clarify his needs.

Thx.

JohnY

On Feb 15, 2018, at 7:53 PM, Earl Wertheimer <[hidden email]> wrote:

Yes and no.

The basic query IS MySQL. ie the SELECT etc...

The undocumented part are the parameters, that allow us to ask the user to enter information that can be used to alter the MySQL query.

This stuff:

<param id="provider" type="list" description="Provider">
   <param-query>
      ( select distinct provider_no, concat(last_name,',',first_name,'(',provider_no,')') as name 
         from provider where provider_type = 'doctor' and status = 1 )
      UNION
      ( select ' ALL', 'All providers' )
      order by provider_no ;
   </param-query>
</param> 
<param id="date_start" type="date" description="Start Date" />
<param id="date_end" type="date" description="End Date" />

There is a program that evaluates all the 'param' items and creates a nice web form.

So  the RbT parameters
<param id="date_start" type="date" description="Start Date" />

becomes

<input type="text" class="datefield" id="datefield1" name="date_start">
  <a id="obsdate1"><img title="Calendar" src="../../images/cal.gif" alt="Calendar" border="0" /></a> 
  <script type="text/javascript">Calendar.setup( { inputField : "datefield1", ifFormat : "%Y-%m-%d", showsTime :false, button : "obsdate1", singleClick : true, step : 1 } );</script>  


The types of input, etc are what John is looking for...

Plan B is to collect/write documentation and update the manual page:





On Thu, Feb 15, 2018 at 10:28 PM, John Robertson <[hidden email]> wrote:
Isn't Rbt basically Sql? JohnR 

On Feb 15, 2018 18:55, "John Yap M.D." <[hidden email]> wrote:
To the Report By Template/database query experts out there….

My associate is an up and coming RBT guru who needs a bit of guidance.  His question:

Do you know if anyone has documented the syntax for RBTs anywhere?  I know there are a ton of examples, but I'm wondering if anyone has really laid out what's possible and what's not in the RBT.

An example: I'd like to have default values for the parameters of a RBT.  I have no idea how to make that happen, though.


I think he’d like to query the database to allow for range filters, etc.  This is part of the work towards the patient medical home concept.

Any advice would be welcome.

Thanks,

JohnY

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: [OSCAR-advanced-users] RBT Syntax

Peter Hutten-Czapski-2
You can set the default for a RBT by using a dropdown for the selector and putting the default into the first slot

eg The following gives "all providers" as the default parameter
<param-query> 
SELECT "%" AS provider_no, 'all providers' AS provider 
UNION 
SELECT provider_no, concat(last_name,',',first_name,'(',provider_no,')') from provider 
WHERE status='1' 
	AND provider_type='doctor' 
	AND ohip_no>1 
ORDER BY provider_no;
</param-query>  </param> 


================
Peter Hutten-Czapski
Haileybury Ontario

"The attitude that ‘if rural people want these services they’ll have to come to the city to get them’ is simply not acceptable…” (Newbery, 1999)

Before printing, think about the environment. Avant d' imprimer, pensez à l'environnement.

On 17 February 2018 at 14:17, John Yap M.D. <[hidden email]> wrote:
Thank you Earl.  I’m quite a luddite when it comes to MySQL and RBT’s.  I asked Paras to clarify what he was trying to accomplish.  

His challenge:

In writing reports by template, there is a language used to describe the input fields the user can set. For example,

<param id="provider" type="list" description="Provider"> 
<param-query>select provider_no, CONCAT(last_name) from provider WHERE status='1' 
	AND provider_type='doctor' 
	AND ohip_no>1 
ORDER BY last_name;</param-query> </param>

The RBT then lets you insert “provider” into the SQL query. 

I am wondering if there is any documentation for these “param” tags. Specifically, I am wondering if you can set a default value. For example, there are many reports that we use for billing that look at fee items billed in a certain date range. It would be nice to allow the user to set this range but also to set a default range (e.g. Jan 1 - Dec 31 of the current year. ) I am wondering if there is any way to do that but I cannot find documentation for the “param” settings for the report. 

Does that make sense?

Maybe that helps to clarify his needs.

Thx.

JohnY

On Feb 15, 2018, at 7:53 PM, Earl Wertheimer <[hidden email]> wrote:

Yes and no.

The basic query IS MySQL. ie the SELECT etc...

The undocumented part are the parameters, that allow us to ask the user to enter information that can be used to alter the MySQL query.

This stuff:

<param id="provider" type="list" description="Provider">
   <param-query>
      ( select distinct provider_no, concat(last_name,',',first_name,'(',provider_no,')') as name 
         from provider where provider_type = 'doctor' and status = 1 )
      UNION
      ( select ' ALL', 'All providers' )
      order by provider_no ;
   </param-query>
</param> 
<param id="date_start" type="date" description="Start Date" />
<param id="date_end" type="date" description="End Date" />

There is a program that evaluates all the 'param' items and creates a nice web form.

So  the RbT parameters
<param id="date_start" type="date" description="Start Date" />

becomes

<input type="text" class="datefield" id="datefield1" name="date_start">
  <a id="obsdate1"><img title="Calendar" src="../../images/cal.gif" alt="Calendar" border="0" /></a> 
  <script type="text/javascript">Calendar.setup( { inputField : "datefield1", ifFormat : "%Y-%m-%d", showsTime :false, button : "obsdate1", singleClick : true, step : 1 } );</script>  


The types of input, etc are what John is looking for...

Plan B is to collect/write documentation and update the manual page:





On Thu, Feb 15, 2018 at 10:28 PM, John Robertson <[hidden email]> wrote:
Isn't Rbt basically Sql? JohnR 

On Feb 15, 2018 18:55, "John Yap M.D." <[hidden email]> wrote:
To the Report By Template/database query experts out there….

My associate is an up and coming RBT guru who needs a bit of guidance.  His question:

Do you know if anyone has documented the syntax for RBTs anywhere?  I know there are a ton of examples, but I'm wondering if anyone has really laid out what's possible and what's not in the RBT.

An example: I'd like to have default values for the parameters of a RBT.  I have no idea how to make that happen, though.


I think he’d like to query the database to allow for range filters, etc.  This is part of the work towards the patient medical home concept.

Any advice would be welcome.

Thanks,

JohnY

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users




------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot



_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel






------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: FW: [OSCAR-advanced-users] RBT Syntax

mweston4
On the topic of Report by Template...

We recently discovered (though the only documentation was the code
itself ;)) that an input element option you can use is the checkbox!

This is convenient if you need to select multiple search items, for
example, using the "IN" sql clause:

<report title="A1 Dummy - Count Appt Types" description="A1 Dummy -
Count Appt Types" active="1">

<query>
select count(*) as "Appt Type Count" from appointment a where a.type in
('{appt_types}');
</query>

<param id="appt_types" type="check" description="Appointment Types">
   <param-query>
       select name, name from appointmentType;
   </param-query>
</param>
       
</report>

Checking the provided checkbox at the top of the list with no label
gives you a "select all" option.

--Melissa.

On 2/18/2018 8:58 PM, Melvin Samuel wrote:

> *
> *
> ------------------------------------------------------------------------
> *From:* Peter Hutten-Czapski
> *Sent:* Sunday, February 18, 2018 8:53:30 PM (UTC-05:00) Eastern Time
> (US & Canada)
> *To:* [hidden email]
> *Cc:* A list for advanced OSCAR user discussions
> *Subject:* Re: [Oscarmcmaster-devel] [OSCAR-advanced-users] RBT Syntax
>
> You can set the default for a RBT by using a dropdown for the selector
> and putting the default into the first slot
>
> eg The following gives "all providers" as the default parameter
>
> <param-query>
> SELECT "%" AS provider_no, 'all providers' AS provider
> UNION
> SELECT provider_no, concat(last_name,',',first_name,'(',provider_no,')') from provider
> WHERE status='1'
> AND provider_type='doctor'
> AND ohip_no>1
> ORDER BY provider_no;
> </param-query>  </param>
>
>
>
> ================
> Peter Hutten-Czapski
> Haileybury Ontario
>
> "The attitude that ‘if rural people want these services they’ll have to
> come to the city to get them’ is simply not acceptable…” (Newbery, 1999)
>
> Before printing, think about the environment. Avant d' imprimer, pensez
> à l'environnement.
>
> On 17 February 2018 at 14:17, John Yap M.D. <[hidden email]
> <mailto:[hidden email]>> wrote:
>
>     Thank you Earl.  I’m quite a luddite when it comes to MySQL and
>     RBT’s.  I asked Paras to clarify what he was trying to accomplish.
>
>     His challenge:
>
>     In writing reports by template, there is a language used to describe
>     the input fields the user can set. For example,
>
>     <param id="provider" type="list" description="Provider">
>     <param-query>select provider_no, CONCAT(last_name) from provider
>     WHERE status='1' AND provider_type='doctor' AND ohip_no>1 ORDER BY
>     last_name;</param-query> </param>
>
>
>     The RBT then lets you insert “provider” into the SQL query.
>
>     I am wondering if there is any documentation for these “param” tags.
>     Specifically, I am wondering if you can set a default value. For
>     example, there are many reports that we use for billing that look at
>     fee items billed in a certain date range. It would be nice to allow
>     the user to set this range but also to set a default range (e.g. Jan
>     1 - Dec 31 of the current year. ) I am wondering if there is any way
>     to do that but I cannot find documentation for the “param” settings
>     for the report.
>
>     Does that make sense?
>
>     Maybe that helps to clarify his needs.
>
>     Thx.
>
>     JohnY
>
>>     On Feb 15, 2018, at 7:53 PM, Earl Wertheimer <[hidden email]
>>     <mailto:[hidden email]>> wrote:
>>
>>     Yes and no.
>>
>>     The basic query IS MySQL. ie the SELECT etc...
>>
>>     The undocumented part are the parameters, that allow us to ask the
>>     user to enter information that can be used to alter the MySQL query.
>>
>>     This stuff:
>>
>>     <param id="provider" type="list" description="Provider">
>>        <param-query>
>>           ( select distinct provider_no,
>>     concat(last_name,',',first_name,'(',provider_no,')') as name
>>              from provider where provider_type = 'doctor' and status = 1 )
>>           UNION
>>           ( select ' ALL', 'All providers' )
>>           order by provider_no ;
>>        </param-query>
>>     </param>
>>     <param id="date_start" type="date" description="Start Date" />
>>     <param id="date_end" type="date" description="End Date" />
>>
>>     There is a program that evaluates all the 'param' items and
>>     creates a nice web form.
>>
>>     So  the RbT parameters
>>     <param id="date_start" type="date" description="Start Date" />
>>
>>     becomes
>>
>>     <input type="text" class="datefield"
>>     id="datefield1" name="date_start">
>>       <a id="obsdate1"><img title="Calendar"
>>     src="../../images/cal.gif" alt="Calendar" border="0" /></a>
>>       <script type="text/javascript">Calendar.setup( { inputField :
>>     "datefield1", ifFormat : "%Y-%m-%d", showsTime :false, button :
>>     "obsdate1", singleClick : true, step : 1 } );</script>
>>
>>
>>     The types of input, etc are what John is looking for...
>>
>>     Plan B is to collect/write documentation and update the manual page:
>>     http://oscarmanual.org/oscar_emr_12/developers/4-10-report-by-template-sql/4-10-1-report-by-template-overview
>>     <http://oscarmanual.org/oscar_emr_12/developers/4-10-report-by-template-sql/4-10-1-report-by-template-overview>
>>
>>
>>
>>
>>
>>     On Thu, Feb 15, 2018 at 10:28 PM, John
>>     Robertson<[hidden email]
>>     <mailto:[hidden email]>>wrote:
>>
>>         Isn't Rbt basically Sql? JohnR
>>
>>         On Feb 15, 2018 18:55, "John Yap M.D." <[hidden email]
>>         <mailto:[hidden email]>> wrote:
>>
>>             To the Report By Template/database query experts out there….
>>
>>             My associate is an up and coming RBT guru who needs a bit
>>             of guidance.  His question:
>>
>>             Do you know if anyone has documented the syntax for RBTs
>>             anywhere?  I know there are a ton of examples, but I'm
>>             wondering if anyone has really laid out what's possible
>>             and what's not in the RBT.
>>
>>             An example: I'd like to have default values for the
>>             parameters of a RBT.  I have no idea how to make that
>>             happen, though.
>>
>>
>>             I think he’d like to query the database to allow for range
>>             filters, etc.  This is part of the work towards the
>>             patient medical home concept.
>>
>>             Any advice would be welcome.
>>
>>             Thanks,
>>
>>             JohnY
>>
>>             ------------------------------------------------------------------------------
>>             Check out the vibrant tech community on one of the world's
>>             most
>>             engaging tech sites, Slashdot.org
>>             <http://Slashdot.org>!http://sdm.link/slashdot
>>             <http://sdm.link/slashdot>
>>             _______________________________________________
>>             OSCARmcmaster-advanced-users mailing list
>>             [hidden email]
>>             <mailto:[hidden email]>
>>             https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users
>>             <https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users>
>>
>>
>>         ------------------------------------------------------------------------------
>>         Check out the vibrant tech community on one of the world's most
>>         engaging tech sites, Slashdot.org
>>         <http://Slashdot.org>!http://sdm.link/slashdot
>>         <http://sdm.link/slashdot>
>>         _______________________________________________
>>         Oscarmcmaster-devel mailing list
>>         [hidden email]
>>         <mailto:[hidden email]>
>>         https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
>>         <https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel>
>>
>>
>>     ------------------------------------------------------------------------------
>>     Check out the vibrant tech community on one of the world's most
>>     engaging tech sites,Slashdot.org
>>     <http://slashdot.org/>!http://sdm.link/slashdot_______________________________________________
>>     <http://sdm.link/slashdot_______________________________________________>
>>     OSCARmcmaster-advanced-users mailing list
>>     [hidden email]
>>     <mailto:[hidden email]>
>>     https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users
>>     <https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users>
>
>
>
>
>     ------------------------------------------------------------------------------
>     Check out the vibrant tech community on one of the world's most
>     engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
>
>
>     _______________________________________________
>     Oscarmcmaster-devel mailing list
>     [hidden email]
>     <mailto:[hidden email]>
>     https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
>     <https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel>
>
>
>
>
>

--
Melissa Beldman
Programmer Analyst
Western Technology Services
Western University
519-661-2111 x88902

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: [OSCAR-advanced-users] RBT Syntax

John Yap-2
In reply to this post by Peter Hutten-Czapski-2
Thank you PHC.  My partner is trying to create RBT’s which allow for selection of variables, such as dates, etc.  So the option below may be limiting. Is there an option that doesn’t limit one to drop-down menus.

His comments:

That would work for dropdowns (say, picking a provider) but not for text input (e.g. dates, billing codes, diagnostic codes, a list of providers, etc.)

I really should get him to sign on to this listserve, but he’s not ready to be buried under all those messages!

JohnY

On Feb 18, 2018, at 5:53 PM, Peter Hutten-Czapski <[hidden email]> wrote:

You can set the default for a RBT by using a dropdown for the selector and putting the default into the first slot

eg The following gives "all providers" as the default parameter
<param-query> 
SELECT "%" AS provider_no, 'all providers' AS provider 
UNION 
SELECT provider_no, concat(last_name,',',first_name,'(',provider_no,')') from provider 
WHERE status='1' 
	AND provider_type='doctor' 
	AND ohip_no>1 
ORDER BY provider_no;
</param-query>  </param> 


================
Peter Hutten-Czapski
Haileybury Ontario

"The attitude that ‘if rural people want these services they’ll have to come to the city to get them’ is simply not acceptable…” (Newbery, 1999)

Before printing, think about the environment. Avant d' imprimer, pensez à l'environnement.

On 17 February 2018 at 14:17, John Yap M.D. <[hidden email]> wrote:
Thank you Earl.  I’m quite a luddite when it comes to MySQL and RBT’s.  I asked Paras to clarify what he was trying to accomplish.  

His challenge:

In writing reports by template, there is a language used to describe the input fields the user can set. For example,

<param id="provider" type="list" description="Provider"> 
<param-query>select provider_no, CONCAT(last_name) from provider WHERE status='1' 
	AND provider_type='doctor' 
	AND ohip_no>1 
ORDER BY last_name;</param-query> </param>

The RBT then lets you insert “provider” into the SQL query. 

I am wondering if there is any documentation for these “param” tags. Specifically, I am wondering if you can set a default value. For example, there are many reports that we use for billing that look at fee items billed in a certain date range. It would be nice to allow the user to set this range but also to set a default range (e.g. Jan 1 - Dec 31 of the current year. ) I am wondering if there is any way to do that but I cannot find documentation for the “param” settings for the report. 

Does that make sense?

Maybe that helps to clarify his needs.

Thx.

JohnY

On Feb 15, 2018, at 7:53 PM, Earl Wertheimer <[hidden email]> wrote:

Yes and no.

The basic query IS MySQL. ie the SELECT etc...

The undocumented part are the parameters, that allow us to ask the user to enter information that can be used to alter the MySQL query.

This stuff:

<param id="provider" type="list" description="Provider">
   <param-query>
      ( select distinct provider_no, concat(last_name,',',first_name,'(',provider_no,')') as name 
         from provider where provider_type = 'doctor' and status = 1 )
      UNION
      ( select ' ALL', 'All providers' )
      order by provider_no ;
   </param-query>
</param> 
<param id="date_start" type="date" description="Start Date" />
<param id="date_end" type="date" description="End Date" />

There is a program that evaluates all the 'param' items and creates a nice web form.

So  the RbT parameters
<param id="date_start" type="date" description="Start Date" />

becomes

<input type="text" class="datefield" id="datefield1" name="date_start">
  <a id="obsdate1"><img title="Calendar" src="../../images/cal.gif" alt="Calendar" border="0" /></a> 
  <script type="text/javascript">Calendar.setup( { inputField : "datefield1", ifFormat : "%Y-%m-%d", showsTime :false, button : "obsdate1", singleClick : true, step : 1 } );</script>  


The types of input, etc are what John is looking for...

Plan B is to collect/write documentation and update the manual page:





On Thu, Feb 15, 2018 at 10:28 PM, John Robertson <[hidden email]> wrote:
Isn't Rbt basically Sql? JohnR 

On Feb 15, 2018 18:55, "John Yap M.D." <[hidden email]> wrote:
To the Report By Template/database query experts out there….

My associate is an up and coming RBT guru who needs a bit of guidance.  His question:

Do you know if anyone has documented the syntax for RBTs anywhere?  I know there are a ton of examples, but I'm wondering if anyone has really laid out what's possible and what's not in the RBT.

An example: I'd like to have default values for the parameters of a RBT.  I have no idea how to make that happen, though.


I think he’d like to query the database to allow for range filters, etc.  This is part of the work towards the patient medical home concept.

Any advice would be welcome.

Thanks,

JohnY

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users




------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot



_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel
Reply | Threaded
Open this post in threaded view
|

Re: [OSCAR-advanced-users] RBT Syntax

Peter Hutten-Czapski
The syntax of the parameter that defaults to "any provider" I exampled earlier allows you to put anything in the drop down picker, such as 1,4,8,12 with the first item being the default

There is no option to validate free text unless you build it into your SQL with IF and REGEX

The date picker is built in
<param id="start_date" type="date" description="Start Date">
</param>


================
Peter Hutten-Czapski
Haileybury Ontario

"The attitude that ‘if rural people want these services they’ll have to come to the city to get them’ is simply not acceptable…” (Newbery, 1999)

Before printing, think about the environment. Avant d' imprimer, pensez à l'environnement.

On 21 February 2018 at 00:07, John Yap M.D. <[hidden email]> wrote:
Thank you PHC.  My partner is trying to create RBT’s which allow for selection of variables, such as dates, etc.  So the option below may be limiting. Is there an option that doesn’t limit one to drop-down menus.

His comments:

That would work for dropdowns (say, picking a provider) but not for text input (e.g. dates, billing codes, diagnostic codes, a list of providers, etc.)

I really should get him to sign on to this listserve, but he’s not ready to be buried under all those messages!

JohnY


On Feb 18, 2018, at 5:53 PM, Peter Hutten-Czapski <[hidden email]> wrote:

You can set the default for a RBT by using a dropdown for the selector and putting the default into the first slot

eg The following gives "all providers" as the default parameter
<param-query> 
SELECT "%" AS provider_no, 'all providers' AS provider 
UNION 
SELECT provider_no, concat(last_name,',',first_name,'(',provider_no,')') from provider 
WHERE status='1' 
	AND provider_type='doctor' 
	AND ohip_no>1 
ORDER BY provider_no;
</param-query>  </param> 


================
Peter Hutten-Czapski
Haileybury Ontario

"The attitude that ‘if rural people want these services they’ll have to come to the city to get them’ is simply not acceptable…” (Newbery, 1999)

Before printing, think about the environment. Avant d' imprimer, pensez à l'environnement.

On 17 February 2018 at 14:17, John Yap M.D. <[hidden email]> wrote:
Thank you Earl.  I’m quite a luddite when it comes to MySQL and RBT’s.  I asked Paras to clarify what he was trying to accomplish.  

His challenge:

In writing reports by template, there is a language used to describe the input fields the user can set. For example,

<param id="provider" type="list" description="Provider"> 
<param-query>select provider_no, CONCAT(last_name) from provider WHERE status='1' 
	AND provider_type='doctor' 
	AND ohip_no>1 
ORDER BY last_name;</param-query> </param>

The RBT then lets you insert “provider” into the SQL query. 

I am wondering if there is any documentation for these “param” tags. Specifically, I am wondering if you can set a default value. For example, there are many reports that we use for billing that look at fee items billed in a certain date range. It would be nice to allow the user to set this range but also to set a default range (e.g. Jan 1 - Dec 31 of the current year. ) I am wondering if there is any way to do that but I cannot find documentation for the “param” settings for the report. 

Does that make sense?

Maybe that helps to clarify his needs.

Thx.

JohnY

On Feb 15, 2018, at 7:53 PM, Earl Wertheimer <[hidden email]> wrote:

Yes and no.

The basic query IS MySQL. ie the SELECT etc...

The undocumented part are the parameters, that allow us to ask the user to enter information that can be used to alter the MySQL query.

This stuff:

<param id="provider" type="list" description="Provider">
   <param-query>
      ( select distinct provider_no, concat(last_name,',',first_name,'(',provider_no,')') as name 
         from provider where provider_type = 'doctor' and status = 1 )
      UNION
      ( select ' ALL', 'All providers' )
      order by provider_no ;
   </param-query>
</param> 
<param id="date_start" type="date" description="Start Date" />
<param id="date_end" type="date" description="End Date" />

There is a program that evaluates all the 'param' items and creates a nice web form.

So  the RbT parameters
<param id="date_start" type="date" description="Start Date" />

becomes

<input type="text" class="datefield" id="datefield1" name="date_start">
  <a id="obsdate1"><img title="Calendar" src="../../images/cal.gif" alt="Calendar" border="0" /></a> 
  <script type="text/javascript">Calendar.setup( { inputField : "datefield1", ifFormat : "%Y-%m-%d", showsTime :false, button : "obsdate1", singleClick : true, step : 1 } );</script>  


The types of input, etc are what John is looking for...

Plan B is to collect/write documentation and update the manual page:





On Thu, Feb 15, 2018 at 10:28 PM, John Robertson <[hidden email]> wrote:
Isn't Rbt basically Sql? JohnR 

On Feb 15, 2018 18:55, "John Yap M.D." <[hidden email]> wrote:
To the Report By Template/database query experts out there….

My associate is an up and coming RBT guru who needs a bit of guidance.  His question:

Do you know if anyone has documented the syntax for RBTs anywhere?  I know there are a ton of examples, but I'm wondering if anyone has really laid out what's possible and what's not in the RBT.

An example: I'd like to have default values for the parameters of a RBT.  I have no idea how to make that happen, though.


I think he’d like to query the database to allow for range filters, etc.  This is part of the work towards the patient medical home concept.

Any advice would be welcome.

Thanks,

JohnY

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users




------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot



_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
OSCARmcmaster-advanced-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-advanced-users





------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Oscarmcmaster-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/oscarmcmaster-devel