Fiel value change markup in structure

[Balázs Ujváry]

Dear All, 

I have a task in structure. I have listed out for a quarterly planning all the involved epics in a structure. What I need to see is, whether the scope of an epic has changed during the planning period. If yes, I would like to mark those. 

My solution for this was the following: 

1, Validation inquiry - I have listed the last change date of the description field for validation: 

history.changes .FILTER($.field = "description").last().changeGroup.time 

2, I wanted to see, if the descriprion field has been updated between 13th September and 3rd October. If yes, I wanted to markup those records with a "red star" 

IF history.changes

.FILTER($.field = "description").last().changeGroup.time > make_date(2022,09,13)&& history.changes .FILTER($.field = "description").last().changeGroup.time < make_date(2022,10,03): "(*r)"

Unfortunately there seems to be some problem, as it's not working properly. Could you please check for me, where do I make misstakes? 

[David Niro · Accepted solution]

Hello @Balázs Ujváry ,

Welcome to the Community!  

For me, the formula works.  However, I would suggest adjusting it to only filter the history once. Like this:

with _changes_ = 
  history.changes 
    .FILTER(
      $.field = "description"
    ).last().changeGroup.time:

IF _changes_ > MAKE_DATE(2022,09,13) AND _changes_ < MAKE_DATE(2022,10,03):
"(*r)"

What version of Structure are you currently using?  Its possible that there is some syntax used which may not be available in the version you are on.

You can check the version by clicking on the info button in the bottom right corner of your structure.  It should show at the top of the menu that appears.

Best,
David