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?
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?