21916 results


  • Question: HOW TO USE CONDITIONAL LOGIC IN SQL

    Databases, SQL, Caché Is there a way or can it be done to use conditional logic in sql like so      Query Q1(formal as %String) As %SQLQuery [Final] {         SELECT patientnumber,ID, CASE     WHEN ID = 50 THEN "The is 50"     WHEN ID = 30 THEN ...

    Post by Thembelani Mlalazi 5 days ago


  • Comment:

    This limit on Comunity Edition will be expanded with the next update.


  • Comment:

    Thank you, Vitaly! ObjectScript is full of opportunities! With a creative community, of course :)

    Comment to the post "How to return JSON Array in SQL request for a List Property?" by Evgeny Shvarov, 6 days ago


  • Comment:

    But why "minus"? This is elegant and works.

    Comment to the post "How to return JSON Array in SQL request for a List Property?" by Evgeny Shvarov, 6 days ago


  • Answer:

    The recommended method of transforming data from CCD to HL7 is to use InterSystems SDA as an intermediary format. Use pre-built XSLTs to convert from CDA to SDA, and then create a DTL transformation to map the SDA to HL7. Here are the names of some ...

    Answer to the post "CCD to HL7" by Kurt Dawn, 5 days ago


  • Answer:

    Still another option: Class dc.test Extends %Persistent {Property  JSONData  As list Of %String  [  SqlListType  = SUBNODE ]; ClassMethod  Test() {   d .. %KillExtent ()       f  l = $lb ("apple", "pear", "plum"), $lb ({" ...

    Answer to the post "How to return JSON Array in SQL request for a List Property?" by Vitaliy Serdtsev, 5 days ago


  • Comment:

    Joe Gazillo!  Good to hear from you!

    I think that code should work back to 2016.2.  Basically after the change to our JSON objects.  To work on 2016.1 you'd have to change %Push() to $push().  Earlier versions, you'd have to something...

    Comment to the post "How to return JSON Array in SQL request for a List Property?" by Kyle Baxter, 6 days ago


  • Comment:

    Hi Kyle 

    Thanks for the great article. What version of Cache will this code work? 

    Joe

    Comment to the post "How to return JSON Array in SQL request for a List Property?" by Joe Gazillo, 6 days ago


  • Comment:

    You cannot, yes because of Accepted status. 

    Comment to the post "How to return JSON Array in SQL request for a List Property?" by Evgeny Shvarov, 6 days ago


  • Comment:

    Hi Sergey! Do not take Community Edition limits into consideration. 

    If you don't have limits what is the best strategy with packages/tools development in your opinion?