How we can filter out Task which have hop count >1

[Piyush Dwivedi]

How we can filter out Task which have hop count >1

[Chaitanya ILCR · Accepted solution]

Hi @Piyush Dwivedi ,

OOB there is a field called reassignment count on the task table which calculates how many times a task has been reassigned

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[FolushoO]

.

[folusho]

@Piyush Dwivedi 

You can do this either from list view or use a simple script below:

var gr = new GlideRecord('task');
gr.addQuery('reassignment_count', '<=', 1); // Only include tasks with  Reassignment count 0 or 1
gr.query();

while (gr.next()) {
    gs.info('Task: ' + gr.number + ' | Reassignment Count: ' + gr.reassignment_count);
}

[Chaitanya ILCR · Accepted solution]

Hi @Piyush Dwivedi ,

OOB there is a field called reassignment count on the task table which calculates how many times a task has been reassigned

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[PratikshaKate · Accepted solution]

@Piyush Dwivedi go on table and in filter give reassignment count greater than 1 and you will get the records which has hop count greater than 1.

Please find the screenshot attached. If you want to get this via code, then write glide record and give encoded query and copy past the filter in encoded query. Let me know if you need help with the code. 

Mark my answer helpful if it helped you 🙂