No need to modify the SPROC, I chose the database option so can you tell me any table can run the query on it.
Original Message:
Sent: 12-22-2020 08:46
From: Drew Drew Bisson
Subject: Interaction Details
If you modify the SPROC, be aware that each time you upgrade and run the DB upgrade scripts, I think the SPROC will need to be re-modified. Might want to save it with any other customizations and make a note.
------------------------------
Drew Drew Bisson
Chief Architect
Genesys - Employees
Original Message:
Sent: 12-22-2020 05:28
From: Sajed Salah
Subject: Interaction Details
Thank you Ryan
------------------------------
Sajed Salah
Fourth Dimension Systems
Original Message:
Sent: 12-21-2020 13:42
From: ryan hedlund
Subject: Interaction Details
I think you just need to modify these 2 SPROCS:
spinin_execute_search
spinin_execute_search2
Just set if = 1000 then adjust to higher.
Not 100% sure so test it out in DEV but it looks like there is hard coded time out in ICBM of 60 seconds:
TransactionClient.BuildRequest: Building transaction request string with the following Transaction settings:
TransactionScope:
UserId:
FormatVersion: 1
ClientNet: {EC724FF-B9B5-445e-8927-EB329EE35F8E}
Provider: ININ.TrackerTranProvider.1
ConnectionInformation:
Catalog:
Schema:
Timeout: 60
RequestType: Supported
IsolationType: ReadCommitted
ReadOnly: False
IncludeParameterMetadata: False
RowLimit: 1000
IncludeRowSetMetadata: False
TransactionId:
ServerInfo:
AdditionalInformation:
GlobalScope:
UserId:
FormatVersion: 1
ClientNet: {EC724FF-B9B5-445e-8927-EB329EE35F8E}
Provider: ININ.I3DBTranSPProvider.1
ConnectionInformation:
Catalog:
Schema:
Timeout: 60
RequestType: Supported
IsolationType: ReadCommitted
ReadOnly: False
IncludeParameterMetadata: False
RowLimit: 1000
IncludeRowSetMetadata: True
TransactionId:
ServerInfo:
AdditionalInformation:
Here is what ICBM passes on the search:
I3DbTranProvider.GetInteractions: Getting interactions matching: SITEID=19;MAXROWS=1000;DATETIMERANGE=[2020-12-14 05:00:00.000,2020-12-22 05:00:00.000];LINEDURATIONRANGE=[0,863999999000];DNIS=%7777777;
TransactionClient.BuildRequest: Request String is: 19|314484753||SearchIntxSummary||ININ.TrackerTranProvider.1|ICDS:IC Tracker|||60||1|2|0|0|1|0|6|SITEID=1;MAXROWS=1000;DATETIMERANGE=[2020-12-14 05:00:00.000,2020-12-22 05:00:00.000];LINEDURATIONRANGE=[0,863999999000];DNIS=%7777777;|1000|1||
------------------------------
ryan hedlund
Stericycle
Original Message:
Sent: 12-21-2020 03:11
From: Sajed Salah
Subject: Interaction Details
Thank you Drew
The customer take these rows and put it in excel sheet, but number of rows each month around 20000, so can't take it thousand by thousand.
------------------------------
Sajed Salah
Fourth Dimension Systems
Original Message:
Sent: 12-21-2020 01:12
From: Drew Drew Bisson
Subject: Interaction Details
What are you ultimately trying to accomplish? Pulling back more than 1,000 rows seems... unnecessary. Perhaps there is a better way to achieve your end goal. Or maybe not, but I think that context would help me (and others) better understand.
------------------------------
Drew Drew Bisson
Chief Architect
Genesys - Employees
Original Message:
Sent: 12-20-2020 04:36
From: Sajed Salah
Subject: Interaction Details
Dear Team
Can we add the number of rows shown in Interaction Details view more than 1000 rows?
#SystemAdministration
------------------------------
Sajed Salah
Fourth Dimension Systems
------------------------------