PureConnect

 View Only
Discussion Thread View
Expand all | Collapse all

Interaction Details

  • 1.  Interaction Details

    Posted 12-20-2020 04:36

    Dear Team

    Can we add the number of rows shown in Interaction Details view more than 1000 rows?


    #SystemAdministration

    ------------------------------
    Sajed Salah
    Fourth Dimension Systems
    ------------------------------


  • 2.  RE: Interaction Details

    GENESYS
    Posted 12-21-2020 01:12

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



  • 3.  RE: Interaction Details

    Posted 12-21-2020 03:11

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



  • 4.  RE: Interaction Details

    Posted 12-21-2020 13:43
    Edited by ryan hedlund 12-21-2020 15:57

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



  • 5.  RE: Interaction Details

    Posted 12-22-2020 05:28

    Thank you Ryan



    ------------------------------
    Sajed Salah
    Fourth Dimension Systems
    ------------------------------



  • 6.  RE: Interaction Details

    GENESYS
    Posted 12-22-2020 08:46

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



  • 7.  RE: Interaction Details

    Posted 12-23-2020 03:25

    Thank you Drew

    No need to modify the SPROC, I chose the database option so can you tell me any table can run the query on it.



    ------------------------------
    Sajed Salah
    Fourth Dimension Systems
    ------------------------------



  • 8.  RE: Interaction Details

    GENESYS
    Posted 12-21-2020 15:06

    If the customer has a monthly recurring business need, perhaps setting up a scheduled output from the DB might be a better approach than doing this through the ICBM UI.



    ------------------------------
    Drew Drew Bisson
    Chief Architect
    Genesys - Employees
    ------------------------------



  • 9.  RE: Interaction Details

    Posted 12-22-2020 05:26

    Thank you Drew

    Can you help me, from any table I can take these information?



    ------------------------------
    Sajed Salah
    Fourth Dimension Systems
    ------------------------------



  • 10.  RE: Interaction Details

    Posted 12-23-2020 13:03

    look at InteractionSummary and Interactiondetails_viw



    ------------------------------
    ryan hedlund
    Stericycle
    ------------------------------



  • 11.  RE: Interaction Details

    Posted 12-24-2020 04:29

    Thank you Ryan



    ------------------------------
    Sajed Salah
    Fourth Dimension Systems
    ------------------------------



Need Help finding something?

Check out the Genesys Knowledge Network - your all-in-one access point for Genesys resources