Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Contact Recorder No Search results

Status
Not open for further replies.

Andhee

Vendor
Dec 9, 2009
103
US
Just installed Server Edition 9.1.5. I can see 846 recordings from the call center for the first day of business. When I search for any recordings for 1,7,or 31 days I get no results. I've modified the search and replay rights to include up to 12 digits and still no luck. Calls are coming in on a PRI and are only showing 11 digits when I add a 9 in the prefix. I'm showing no results whatever I do.
Here is my last search log:
select DISTINCT * from (SELECT calls.calltypeid, calls.nativecallid, callsegments.callid, callsegments.segmentnum, callsegments.startedat as startedat, recordings.inum, recordings.audiochans, recordings.screens, callset_names(callsegments.callid, callsegments.segmentnum) as csnames, callsegments.duration AS duration, parties(callsegments.callid, callsegments.segmentnum, '{51,103}'::int2[]) AS parties_2, ipodirn(calls.callid) AS direction, parties(callsegments.callid, callsegments.segmentnum, '{100,235,263,301,401,80}'::int2[]) AS agents, parties(callsegments.callid, callsegments.segmentnum, '{104}'::int2[]) AS parties_5, parties(callsegments.callid, callsegments.segmentnum, '{102,236,302,402}'::int2[]) AS skills, parties(callsegments.callid, callsegments.segmentnum, '{403}'::int2[]) AS parties_7, calls.nativecallid AS switchcallid, udf_value(callsegments.callid,callsegments.segmentnum,udf_number('origfilename')) AS udf_9 FROM callsegments NATURAL JOIN calls NATURAL JOIN parties NATURAL JOIN recordings WHERE (parties.owner=true) and (((partyname >= '00')and(partyname<='99')and(length(partyname)=2)) or ((partyname >= '000')and(partyname<='999')and(length(partyname)=3)) or ((partyname >= '0000')and(partyname<='9999')and(length(partyname)=4)) or ((partyname >= '00000')and(partyname<='99999')and(length(partyname)=5)) or ((partyname >= '000000')and(partyname<='999999')and(length(partyname)=6)) or ((partyname >= '0000000')and(partyname<='9999999')and(length(partyname)=7)) or ((partyname >= '00000000')and(partyname<='99999999')and(length(partyname)=8)) or ((partyname >= '000000000')and(partyname<='999999999')and(length(partyname)=9)) or ((partyname >= '0000000000')and(partyname<='9999999999')and(length(partyname)=10)) or ((partyname >= '00000000000')and(partyname<='99999999999')and(length(partyname)=11)) or ((partyname >= '000000000000')and(partyname<='999999999999')and(length(partyname)=12))) and (startedat >= 2015/12/06 00:00:00) and (startedat < 2015/12/13 00:00:00) ORDER BY startedat LIMIT 500) as intermediate ORDER BY startedat LIMIT 100


Thanks for any assistance.

If vegetarians love animals so much, why are they eating all of their food?
 
Restart services.
Restart until it works, right?
Its working now.

If vegetarians love animals so much, why are they eating all of their food?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top