• State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 23 subscribers
  • Views 378 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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?

  • 0

    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.

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.