Flow Designer get the last work note

[Community Alums]

Hello, this is probably really simple but I usually do a quick and dirty GlideRecord Script but thought I'd do it in Flow Designer.

I want to add the last work note to the parent enhancement table, this works for the most part it shows the number and the short description on each individual update however, its pulling through all the worknotes on story opposed to the last update... Anyone point me in the right direction?

[Lisa Goldman]

Hi @OlaN 

I'm trying out the tool you developed, but I got a bit stuck and could use your guidance.

1. What number should I enter to extract only the latest comments or work notes?

2. What number should I use to extract all comments or work notes?

Thanks in advance for your help!

[OlaN]

Hi Lisa,

Sorry for the slow response, I've been busy away at Knowledge the last week.

Basically you should enter the number of journal entries you want to get.

So enter 1 to get the last one (or leave it blank, because getting the last one is the default behaviour).

Continuing that way, enter 2, to get the two most recent journal entries, and so on.
Lastly you can enter -1 to get all of them, regardless of how many entries there are.

Best of luck!

[DeuCh44-ext]

Thank you very much, Olan. It also worked for me. 

For others reading this: The following error appears when loading the update set:  "Could not find a record in sys_hub_category for column category referenced in this update". One could think that a component might miss, but as Olan noted before "ignoring the error will make the install work fine".

[OlaN]

Thank you!
Oh darn. I should have looked at that error and fixed it by now.. hmm, maybe I can squeeze it in during the day. 😀

[OlaN]

And now it's fixed.
Share project v1.1 
Thanks for the reminder. 😀