I am using OOB data certification. While certifying CIs , user should not be able to certify empty elements. Please see image in the description.

Sachin Gavhane
Giga Guru

find_real_file.png

As shown in above pic, user should not be able to certify empty elements as marked in yellow. There should be some error when user tries to certify these empty elements.

Please help

1 ACCEPTED SOLUTION

Business Rule which you need to set up will look like below:

BR Details;

Table: Certification Element:

Condition: State Changes to Certified

Script :

(function executeRule(current, previous /*null when async*/) {

	// Add your code here
	if(current.certified_value == ''){
		gs.addErrorMessage('Empty Field Values cannot be certified');
		current.setAbortAction(true);
	}

})(current, previous);

find_real_file.png

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

View solution in original post

16 REPLIES 16

Hi,

You can add a filter for an empty string. just change to the correct field.

find_real_file.png

but am not sure which table should be used to restrict data certification

Hi,

When user certifies their cert task, record for that cert task is updated in cert_element table with state of certified.

find_real_file.png

You need to configure business rules on cert_element table to abort transaction for any non filled values and check if state is being updated to "certified" with no value in "Certified value" field.

 

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Also @Sachin Gavhane 

I see you have created duplicate thread in community for the same purpose, please request to delete one of them and continue on one thread only.

Regards,

Shloke

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Business Rule which you need to set up will look like below:

BR Details;

Table: Certification Element:

Condition: State Changes to Certified

Script :

(function executeRule(current, previous /*null when async*/) {

	// Add your code here
	if(current.certified_value == ''){
		gs.addErrorMessage('Empty Field Values cannot be certified');
		current.setAbortAction(true);
	}

})(current, previous);

find_real_file.png

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke