UnDP Transform has no units

Question

Is it just me, or is there no way to add units to a UnDP transform?

I have looked all over and I can't seem to find a way to get them on there.

My poller has the units set, but the trouble I'm running into is that I'm displaying the information in a custom query widget.

I'm essentially concating Orion.NPM.CustomPollersAssignment.CurrentValue with CustomPollerID.Unit. Trouble is, the transform has no unit assigned.

I'm just doing a basic conversion of hertz to megahertz, but in the transform there is no place to set units like you can in the poller.

This seems like a massive oversight, unless I'm doing something dumb.

Here's my query if interested:

SELECT a.CustomPollerDescription as Name, +a.CurrentValue+' '+b.Unit as Value

FROM Orion.NPM.CustomPollerAssignment a
INNER JOIN Orion.NPM.CustomPollers b on a.CustomPollerID = b.CustomPollerID

WHERE a.NodeID = ${NodeID} AND (

CustomPollerName = 'DFSAction' OR
CustomPollerName = 'CurrFrequencyGHz' OR
CustomPollerName = 'GpsReceiverInfo' OR
CustomPollerName = 'GpsReceiverLatitude' OR
CustomPollerName = 'GpsReceiverLongitude' OR
CustomPollerName = 'RedundancyRole' OR
CustomPollerName = 'RedundancyStatus' OR
CustomPollerName = 'Redline_Model' OR
CustomPollerName = 'Redline_Serial'

) ORDER BY Name

cscoengineer · Answer

I would avoid the transforms and do the data  manipulations in the custom SWQL.  That way you have full control without the limitaions of transforms.

maliron · Answer

For what it's worth I was able to "hack" the solution by going in to the CustomPoller table in the database and manually adding GHz to the units field for that transform. So this really does appear to be a lacking feature of UnDP when creating or editing a transform. I'll make a feature request I guess.