Profile to invert Channel value in Item

Setup, Configuration and Use Items & Sitemaps
1

I want to create a Number:QuantityType Item whose value is the negative of a specific Channel value. This would be an ideal use for a profile; but apparently OH has no such profile. ?? Or am I missing something.

PS in case someone wants to state the obvious: yes of course I know I could do this with a rule…

2

You could use a script transformation profile

3

Many thanks for the quick response. But could you kindly provide a quick example? :slight_smile:

4

Show me your item’s definition (yaml? .items?). What scripting language do you prefer / have installed?

Using jruby:

Number:SomeDimension MyItem { channel="xxxxxx" [ profile="transform:RB", toItemScript="| QuantityType.new(input).negate" ] }
1 Like
5

The issue is related to the binding which I am writing for the Growatt solar inverter. The inverter is connected to a storage battery. Natively the inverter channels include positive Number:Power values for both the battery charging, and battery discharging power. But I would like my OH item to display the discharge power as a negative value (for nicer y-axis display on a chart).

I am using .items file for the item definitions as below…

// items as currently defined
Number:Power Charge_Power "Charge Power [%.0f W]" <energy> {channel="growatt:inverter:908bf52bdc:XXXX:charge-power"}
Number:Power Discharge_Power "Discharge Power [%.0f W]" <energy> {channel="growatt:inverter:908bf52bdc:XXXX:discharge-power"}

// desired: invert discharge value via profile
Number:Power Discharge_Power "Discharge Power [%.0f W]" <energy> {[profile="pleaseInvertMe"] channel="growatt:inverter:908bf52bdc:XXXX:discharge-power"}

JS

6 
Number:Power Discharge_Power "Discharge Power [%.0f W]" <energy> {channel="growatt:inverter:908bf52bdc:XXXX:discharge-power" [ profile="transform:JS", toItemScript="| Quantity(input).multiply(-1)" ] }
1 Like
7

Brilliant! Many thanks. (but probably you missed a ] at the end…)

8

I’m glad you were paying attention :wink:

1 Like
9

I just tested it in real life and unfortunately the item is not updated (its value remains null) … I guess due to a syntax error in the item’s profile config parameters => Is this documented anywhere?

EDIT: perhaps the syntax should be something like…

  • | Quantity(input).multiply(BigDecimal.valueOf(-1)), or
  • | QuantityType.new(input).multiply(BigDecimal.valueOf(-1)), or
  • | QuantityType.new(input).multiply(-1), or
  • | QuantityType.new("0 W").subtract(input), or
  • | QuantityType.valueOf(0, Units.WATT).subtract(input), etc…
10

Try | console.log(input) what’s the input value like?

11 
2023-09-12 14:44:06.011 [INFO ] [org.openhab.automation.script       ] - 70 W
12

Oh I remember JS Quantity is a bit different. Try

Number:Power Discharge_Power "Discharge Power [%.0f W]" <energy> {channel="growatt:inverter:908bf52bdc:XXXX:discharge-power" [ profile="transform:JS", toItemScript="| Quantity(input).multiply(-1).toString(); " ] }
13

Thanks for the suggestion.

I was changing the Item configuration parameters on the fly in my running system, and not noticing any change in the item state results. I think I am still suffering from the recently reported bug where on the fly changes in .things or .items files are not automatically implemented. Aargh!

So I tried your above suggestion again with intervening system restarts.

I am also suffering from the current bug where after a restart the JS module is sometimes loaded after the bindings’ things and items. So initially the transforms (sometimes) did not work. However once the system is running stable they do indeed start to work. Aargh!

With intervening restarts and waits for the system to settle, I tried out a whole load of alternate scripts, and it seems that the following do indeed work.

Many thanks for your help. :slight_smile:

// your revised suggestion
Number:Power Discharge_Power "Discharge Power [%.0f W]" <energy> {channel="growatt:inverter:908bf52bdc:XXXX:discharge-power" [ profile="transform:JS", toItemScript="| Quantity(input).multiply(-1).toString();" ] }

// alternate approach also works
Number:Power Discharge_Power "Discharge Power [%.0f W]" <energy> {channel="growatt:inverter:908bf52bdc:XXXX:discharge-power" [ profile="transform:JS", toItemScript="| Quantity(\"-\" + input).toString();" ] }
}
14

Does someone know how this inverting the value of a Contact works?

Contact Sensoren_Badezimmer_Duschsensor {channel="hue:device:PhilipsHue_System_Bridge2:Sensoren_Badezimmer_Duschsensor:security-contact" [profile="transform:JS", toItemScript="| Quantity(input).multiply(-1)"]}
throws the exception
org.graalvm.polyglot.PolyglotException: Error: Failed to create QuantityType from OPEN: java.lang.NumberFormatException: Invalid BigDecimal value: OPEN

15

But use OPEN/CLOSE for contact instead of ON/OFF (for switch)…

1 Like