Approving field is empty

[a2gupta]

Hi,

                                                                                                                                           

I noticed today that in some of the approval records generated, the Approving field is coming empty in some cases,which is stopping the approvers from getting info by clicking the approving field. I also noticed that for all the records in which Approving field is empty,the Source Table field is also coming empty. What could be the reason for this? and possible ways to counter this problem?

Thanks,

[Kalaiarasan Pus · Accepted solution]

Adding a custom business rule such as this will solve the issue (Sample from my instance)

if(current.sysapproval.sys_class_name=='sc_req_item')

  {

  current.document_id=current.getValue('sysapproval');

  current.source_table=current.sysapproval.sys_class_name;

}

[a2gupta]

Hi Kalai,

Will try this. This is a before Insert business rule??

[a2gupta]

And is any condition required?

[Kalaiarasan Pus]

Yes - Before insert

Condition can be this

current.document_id=='' && current.source_table=='' && current.sysapproval!=''

[a2gupta]

Hi kalai,

Thanks.It worked. created a request and now the Approving fields are getting filled and also the source table fields. One more question, What about the previous records that are still empty? is there any way to populate them as well?

Thanks,