SWQL Query Integer Conversion

SWQL doesn't support the CAST and CONVERT functions (except for a special case - SWQL has a ToString(stuff) function that works like CONVERT(nvarchar, stuff)), but I think you can work around this by adding 0, like this: ORDER BY 0+CPS.Status desc

Thank you that is perfect.

Looks like with the latest version of NPM this no longer works. I get an error when I run it through SWQL that "the socket connected was aborted". If I remove the 0+ from the query it runs. Any other thoughts? Thank you.

Normally, "latest version of NPM" would be clear enough, but NPM 10.6 is currently available as a Release Candidate. Could you clarify whether you are seeing this error with 105 or 10.6 RC?

NPM 10.5

Ok, it looks like due to some internal changes, you now need to put the "0+Status" expression in the SELECT clause as well when you use it in the ORDER BY clause.

That worked, thank you.

Hi,

I read your solution and change my code like this:

SELECT
N.NodeName + ' (' + NCP.UniqueName + ') ' AS [Node Name],
'/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Node Name],
N.DetailsUrl AS [_LinkFor_Node Name],
N.CustomProperties.Ticket_No AS Jira_Num,
0+CurrentValue AS Temperature --CHANGE
FROM Orion.NPM.CustomPollerAssignmentOnNode CPAN
INNER JOIN ORION.NODES N ON N.NodeID = CPAN.NodeID
INNER JOIN Orion.NPM.NodeCustomPollers NCP ON NCP.CustomPollerID = CPAN.CustomPollerID

WHERE (0+CurrentValue >= 26 AND 0+CurrentValue <= 100) OR (N.STATUS = 2) --CHANGE

But I get this error:

I find a solution, using Abs(n) function instead..

ex. Abs(CurrentValue)