1 Reply Latest reply on Aug 25, 2016 11:05 AM by tdanner

    ROUND error on SWQL on Orion Custom Query resource?

    mwb

      This may just be another difference between the SDK and the SWQL running in Orion.

       

      I have a query set with ROUND(<column>,2). Literally the same query is pasted into both - running SAM 6.2.4.

       

      In SDK:

      CaptureSDK.PNG

      In the Orion resource:

      CaptureOrion.PNG

      Report as bug?

        • Re: ROUND error on SWQL on Orion Custom Query resource?
          tdanner

          Yes, I would report that through support.

           

          Possible workaround for you to try: put TOSTRING(ROUND(<column>, 2)) in your query. This will cause SWIS to return a string to the client instead of a float. If SWIS does a better job of that than the Orion website, this will help. Otherwise it will just make it worse in SWQL Studio as well.