nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Fieldtype "Last Public Comment" in calculation returns null to a "Number Field"

dahu_9oo24s

Hello,

I got a Field of the type "Last Public Comment Date" with the Name "VorgangDatumLetzerÖffentlicherKommentar" where the timestamp from the last comment (not last public comment?!?!) is saved.

Then I want to calculate how long ago (in days) the last comment was set.

I use this:

That worked fine with a field from type "Date Time Picker", where I saved the timestamp of the last comment with a rule when a comment was set.

But we have to save rule executions now and because of that I want to use the "Last Public Comment" - Fieldtype to calculate the age of the last comment.

The result of the calculation then is set as value of a field of type "Number Field" called "VorgangLetzterKommentarAlter". In the .json view the value of this field always is "null".

Has somebody an idea how to handle this?

Best Regards,

Daniel

Accepted answers

dahu_9oo24s

Hi @Kai Becker ,

the Problem was not solved.

I did what I needed with SLA.

Thank you for your help!

Best Regards,

Daniel

All comments

Kai Becker

Hi @dahu

on your second screenshot the custom field has the value 0.0.

How did it get this value? Does it work sometimes?

Does the Automation rule report errors in the audit log?

dahu_9oo24s

Hello Kai,

thank you for your answer.

Because of value 0.0. I can not tell from where or when the 0.0 value came from.

Always when I do it again, I got "null".

No, there is no error in the audit log of the rule.

Best Regards,

Daniel

Kai Becker

Could you try to add a log action to your rule and log the value of your smart value:

{{now.diff(VorgangDatumLetzerÖffentlicherKommentar).days.abs}}

dahu_9oo24s

Hello @Kai Becker ,

thank you for your advice with the log action.

For

{{now.diff(VorgangDatumLetzerÖffentlicherKommentar).days.abs}}

I dont get a result in log action or if I set the result as value of a field the value is still "null"

But I had a look at the time-formats of {{now}} and {{VorgangDatumLetzerÖffentlicherKommentar}} and they are different:

{{now}}: 2024-02-20T07:31:33.7+0000
{{VorgangDatumLetzerÖffentlicherKommentar}}: 2024-02-15 14:31:27.648

Maybe that is the problem?

But I am not able to get the same time-format for them.

When I want to change the format like {{VorgangDatumLetzerÖffentlicherKommentar.jqlDateTime}} I get no result.

I can change the time-format of {{now}} like e.g. {{now.jqlDateTime}} but there is no time-format given at smart values date and time in the first table that matches with the time-format of {{VorgangDatumLetzerÖffentlicherKommentar}}.

Do you think that this could be the problem and if yes do you have an idea how to bring them to the same format?

Thank you very much!

Best Regards,

Daniel

dahu_9oo24s

Hi @Kai Becker ,

the Problem was not solved.

I did what I needed with SLA.

Thank you for your help!

Best Regards,

Daniel

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management