Description
Customer had few queries on the Worklist SQL Question in CATool from the folder filter section.
As per the problem there seems to be something with “(LEFT(refr_srvc_name,1))” from testing various things that when there is only one line searching for a procedure_ckey then it will cause the list to not return results. They wanted to know is this an expected requirement to get the list to order by referring service? If so they wanted to know is there any other way they can automatically sort by ordering location in this list? Checked the user questions, referred the CATool document and provided the information below. Checked the requirement and yes this is an expected requirement to get the list to order by referring service. It can be done by setting up the query in the folder filter in CATool with the requirements matching for the studies.
After replying the customer they had few more questions on the case below. Provided the information below to the customer for their questions. So to clarify, the only way you can use ORDER BY priority_code DESC, (LEFT(refr_srvc_name,1)) in CATool is when the earlier part of the worklist query contains multiple specialties? Yes, That is correct. ORDER BY priority_code DESC, (LEFT(refr_srvc_name,1)) in CATool can be used when the earlier part of the worklist query contains multiple specialties. Since that does not seem to work for a worklist with only one specialty, is there a different syntax that can be used to get the same results? As of now there is no different syntax that can be used to get the same results.
Now customer is requesting an enhancement that would allow setting sorting by referring service in CATool for worklists that only include a single specialty. |