topic Re: Customizing Job Reports -- Empty in Workato Pros Discussion Board

Customizing Job Reports -- Empty

mstuy — Wed, 01 Nov 2023 21:44:07 GMT

Hello!

I have customized my job reports by adding some fields by using datapills from my recipe's steps to add columns to the report. However, after starting my recipe there have been no values in any of the columns. I have looked through one of the jobs and for a datapill that I've entered as a column and verified it was not null, so I am confused as to why it wasn't shown on the job report. None of the datapills I've entered as columns are populating which I think is strange.

Why could this be happening, and is there a way to fix it?

Thanks!

Re: Customizing Job Reports -- Empty

rachelnatik — Thu, 02 Nov 2023 13:54:17 GMT

The Job Report will not retroactively populate the fields/columns for any jobs that previously ran. It is only forward moving.

If it is for new jobs, I would suggest you check the data pills again. Oftentimes, I have selected the datapill from the wrong step since they can be similar.

Re: Customizing Job Reports -- Empty

mstuy — Thu, 02 Nov 2023 20:03:14 GMT

Thanks for the response!

The columns for the recipe were set up a while ago, but no job report has populated the columns for some reason. One of the fields is mapped to a Workato property from the recipe, so I don't think I could have mapped the wrong datapill for that column. The Workato property column is not populated either. It is strange, because I have double checked the datapills and they seem to be correct but the columns are still not populating.

I'm not sure what else the problem could be.

Re: Customizing Job Reports -- Empty

pavan-narayan — Mon, 06 Nov 2023 08:58:46 GMT

Do you have any data pills configured in Formula mode ? if one column has error in formula mode configuration it wont print for the rest of the columns.

Re: Customizing Job Reports -- Empty

mstuy — Mon, 06 Nov 2023 22:20:13 GMT

Thanks for the reply!

Oh if one column has an error then none of the other columns will populate? Hmm I will triple check the formulas then.

Re: Customizing Job Reports -- Empty

marlon-muela — Tue, 07 Nov 2023 07:05:43 GMT

Hi @mstuy ,

This is Marlon from the Workato support team.

Can you please share what formula you are trying to use on the job report customized column? Also, have you tested it as an action in the recipe? Also, for newly added columns on the job report, it will only populate for new or repeated jobs.

Re: Customizing Job Reports -- Empty

GrailAutomation — Wed, 08 Nov 2023 00:20:02 GMT

Can you share a screenshot of the formulas you have set up?