Making an attachment mandatory in a catalog task

[gnunez]

Hello all,

So in a catalog item I created there are attachments that need to be mandatory based on the catalog tasks in the workflow. In the request the first catalog client script works correctly, but the other ones I created for the catalog tasks don't show and instead shows the initial attachment. It basically asks to attach the same attachment over and over again.

Does anyone know how I can make it mandatory only on specific catalog tasks. I already tried checkmarking "Apples on Catalog Tasks" and that didn't work.

This is what I have for the one that does work but keeps showing repeatedly:

Thanks in advance!!

[gnunez]

Hi Vladimir,

Thank you but I tried it and it didn't make the attachment mandatory.

-Grace

[rafael_merces2]

Instead of:

attachment.addQuery('table_sys_id','sys_id');

could you please try with:

attachment.addQuery('table_sys_id',sys_id);

Also, please check this thread: Catalog service making Mandatory Attachment both application and SP

[gnunez]

Hi Rafael,

I tried it and it didn't make a difference. Should I be including a script in the catalog task as well?

Thanks,

Grace

[shloke04 · Accepted solution]

Hi Grace,

An update on my existing post, you can use Glide Aggregate on Server side which is a Best Practice for better System Performance rather than using Glide Record on Client Side. Write an Before Insert/Update Business Rule on Catalog Task Table as below:

Condition: You can specify the Catalog Item for which you want to configure this validation by dot walking as mentioned below:

Select "Show Related Fields" option from the filter condition first and then dot walking as "Request Item-->Requested Item fields"

Post which you can select the field as "item" is "Your Item Name" as shown below:

Script:

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

  var att = new GlideAggregate('sys_attachment');

  att.addAggregate('COUNT');

  att.addQuery('table_name', current.getTableName());

  att.addQuery('table_sys_id', current.sys_id);

  att.query();

  var count = 0;

  if (att.next()) {

  count = att.getAggregate('COUNT');

  if (count<1) {

  gs.addInfoMessage("Please attach Attachment");

  current.setAbortAction(true);

  }

  }

})(current, previous);

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

Regards,

Shloke

[gnunez]

This worked, thank you!