Skip to main content
D
dinishkrishna
December 23, 2024
Solved

Removing Period Selection When Data Value is removed from a Text property

  • December 23, 2024
  • 1 reply
  • 1 view

I am attempting to update the "text" property (which varies by time) for my UD1 members using a business rule that pulls data from a custom table. The update process works as expected without any issues. However, when I remove a data value from the table, OneStream removes the value from the text property, but the corresponding period remains selected, showing blanks (see Screenshot 2). I am removing the data value using the "Else" condition as shown below (Screenshot 1).

Can anyone provide insights on how to also remove the period from the selection when there is no value? TIA

Screen Shot 1:



 

Screen Shot 2:



 

Best answer by MarcusH

The values for the Text properties are saved to a separate table. If you use SetStoredValue with a blank property value the database record still exists which is why you are seeing that empty stored value. You need to use RemoveStoredPropertyItem to delete the row from the database.

1 reply

M
MarcusHAnswer
January 6, 2025

The values for the Text properties are saved to a separate table. If you use SetStoredValue with a blank property value the database record still exists which is why you are seeing that empty stored value. You need to use RemoveStoredPropertyItem to delete the row from the database.

Terms & ConditionsAccessibility statement