VERIFIED SOLUTION i

Portrait Dialogue - "Fetch Next" in Telemarketing module not ordering

Product Feature: Telemarketing

 

Issue

The Fetch next function in Telemarketing (TM) in Portrait Dialogue 5.2 (with the roll-up Patch) is missing the ordering clause.  
The default SQL to fetch participants is missing the order by clause.
 

Cause

The bug was introduced by the 5.2 Roll-up Patch

The query used in TM to fetch next participant to call should contain an order by clause with the following fields:
 
CCPA_LOCKED_BY_USER_NAME, CCPA_ASSIGNED_USER_NAME and CCPA_NEXT_CALL_DATETIME.

"ORDER BY ccpa_locked_by_user_name desc, ccpa_assigned_user_name desc, ccpa_next_call_datetime"

This is missing from the SQL generated by the dialogue server.
 

Resolution

UPDATED: April 4, 2017
The bug is: “Bug 32403 : Correct ordering missing from TM participant queries”. 

Our Engineers determined that there is an easy workaround in 5.2 with the rollup patch, to just add the 'order by' clause back manually. 

There is no patch to fix this issue.
 
This has been fixed in Dialogue 6.1 (6.1.0.238), according to the bug report.