To copy variable's value into a journal type field

[Poorva Bhawsar]

Hi Community,

I have few select box variables, if user selects the value of those variables as rejected, rejection reason field will populate. I want to copy the value of those variables if they are rejected along with the rejection reason from sctask to another table's journal type field.

I am thinking about the logic like if xyz == rejected && rejection reason != '' then need to add them in that journal field. If those are not rejected, those i approved i dont want to add them in this journal field.

Thanks,

Poorva Bhawsar

[Poorva Bhawsar]

Here i have an another issue. If i am using cmdb_ci table for the gliderecord, its not working for its child tables. I mean its not updating the deviation notes field for this. Thats why i did gliderecord on cmdb_ci_server table but if i use this table it will not work for server child tables.

What we need to do in this case?

And what if i need to gliderecord it on server table only. What should be the query for this?

[Harish KM]

Hi @Poorva Bhawsar  you need a relationship between your server table and catalog task table for the query to work.

If you dont have a relationship then you need to find a unique value between server and task table and use that field in your query so that it can provide correct update.

What is your requirement exactly? How is the task generated? Do you have any workflow or flow designer?

[Poorva Bhawsar]

i have a workflow for this.

[Harish KM]

Hi @Poorva Bhawsar what is the reason behind to update deviation notes on Server table? are you selecting any servers in your catalog form and in return your updating the selected servers in server table?

[Poorva Bhawsar]

Yes i have server names field. Whatever servers i am selecting there, it should update deviation notes with the request item no and the reason user selected and mentioned if its failed.