Building The Search Functionality

[Kubig]

Send export of database table for metadata (relation between columns and KVP) from UCS database.

This function works ok and without any errors, except errors within deployment or post-configuration.

[upk_singhm]

Here it is,
I am not sure if it is readable enough. If not let me know I will try and provide in another format or better yet let me know how to send an attachment.

Id,TheName,DisplayName,TheType,TenantId,Active,ModifiedDate,Format,IsSortable,MappingColumnName
----------------------------------------------------------------------------------------------------------------------------------------------------------
00001a5GBQR4002F,Priority,Priority,0,1,1,2009-11-20 00:12:55.483,,0,NULL
00001a5GBQR4002G,ReasonCode,Reason Code,0,1,1,2009-11-20 00:12:55.483,,0,NULL
00001a5GBQR4002H,Category,Category,0,1,1,2009-11-20 00:12:55.483,,0,NULL
00001a5GBQR4002J,InteractionType,Interaction Type,0,1,1,2009-11-20 00:12:55.483,,0,NULL
00001a5GBQR4002K,MediaType,Media Type,0,1,1,2009-11-20 00:12:55.483,,0,NULL
00001a5GBQR4002M,Language,Language,0,1,1,2009-11-20 00:12:55.483,,0,NULL
00001a5GBQR4002N,StopProcessingReason,StopProcessing Reason,0,1,1,2009-11-20 00:12:55.500,,0,NULL
00001a5GBQR4002P,InteractionSubtype,Interaction Subtype,0,1,1,2009-11-20 00:12:55.500,,0,NULL
00001a5GBQR4002Q,ServiceType,Service Type,0,1,1,2009-11-20 00:12:55.500,,0,NULL
00001a5GBQR4002R,DispositionCode,Disposition Code,0,1,1,2009-11-20 00:12:55.500,,0,NULL
00043a67DR2M10UE,survey_answer_Overall,Survey Overall,0,1,1,2010-09-07 18:08:35.777,,1,StrAttribute3
00043a67DR2M10UU,survey_answer_ByAgent,Survey by Agent,0,1,1,2010-09-07 18:07:35.650,,1,StrAttribute2
00043a67DR2M10V8,survey_answer_Recommend,Survey Recommend,0,1,1,2010-08-31 01:21:09.047,,1,StrAttribute1
0006Da6R2VRS000W,FacebookCommentId,FacebookCommentId,0,1,1,2011-03-17 02:34:05.887,,1,StrAttribute4
0006Da6R2VRS000X,FacebookOutboundCommentId,FacebookOutboundCommentId,0,1,1,2011-03-17 02:34:05.887,,1,StrAttribute5
0006Da6R2VRS000Y,TwitterMsgId,TwitterMsgId,0,1,1,2011-03-17 02:34:05.887,,1,StrAttribute6
0006Da6R2VRS0010,FacebookPostId,FacebookPostId,0,1,1,2011-03-17 02:34:05.903,,1,StrAttribute7
000FWaAA2HWA000K,PFS_id,PFS ID,0,1,1,2015-01-05 11:48:19.607,,1,StrAttribute8
000FYaAAT1N1000K,EmailAddress,E-mail Address,0,1,1,2015-01-07 12:59:02.173,,1,StrAttribute9
000G0aAAVKNC000K,StrAttribute8,PFS ID Str,0,1,0,2015-01-08 20:32:07.327,,0,NULL

Thanks for the help.

[upk_singhm]

Hi Cavagnaro/Kubig,
I am trying to search on StrAttribute9 which is mapped to EmailAddress

Id,[u][b]TheName[/b][/u],DisplayName,TheType,TenantId,Active,ModifiedDate,Format,[u][b]IsSortable,MappingColumnName[/b][/u]
----------------------------------------------------------------------------------------------------------------------------------------------------------
000FYaAAT1N1000K,[u][b]EmailAddress[/b][/u],E-mail Address,0,1,1,2015-01-07 12:59:02.173,[u][b],1,StrAttribute9[/b][/u]

Hope it helps.

Thanks

[Kubig]

And if you add the parameter StrAttribute9 to the where condition, what is the result?

[upk_singhm]

Hi Kubig,
Here's the query and the result:

SELECT *
FROM IxnAttributeMetaData
Where MappingColumnName = 'StrAttribute9'

Id,TheName,DisplayName,TheType,TenantId,Active,ModifiedDate,Format,IsSortable,MappingColumnName
----------------------------------------------------------------------------------------------------------------------------------------------------------
000FYaAAT1N1000K,EmailAddress,E-mail Address,0,1,1,2015-01-07 12:59:02.173,0,1,StrAttribute9

Let me know if it helps.

[upk_singhm]

Hi Kubig,
I thought this might help as well, here's what it shows in the logs:
05:19:18.387 Trc 21126 [SvcSrvW-10] <844> 'OMInteractions.GetInteractions' (request id 844) handling duration : 9 ms.
05:19:21.356 Trc 21124 [ESP:4400] Request (queued for 0 ms): Id=2|Type=Request|AppName=UCS_Provider|AppType=|Service=Index|Method=Search.
05:19:21.356 Dbg 21291 [SvcSrvW-6] Thread 'SvcSrvW-6' registers to shutdown notification.
05:19:21.358 Trc 21124 [SvcSrvW-6] <2> Request (queued for 1 ms):
  Id=2
  Type=Request
  AppName=UCS_Provider
  AppType=
  Service=Index
  Method=Search
  Parameters=
    [
      IndexName="interaction"
      MaxResults=100
      Query="StrAttribute9:"thompson@demosrv.genesyslab.com""
      tkv.multibytes="false"
    ]
  UserData=
    [
    ].
05:19:21.361 Trc 21000 [SvcSrvW-6] <2 tcp://192.168.60.1:51233> Service 'Index' method 'Search' started.
05:19:21.393 Trc 21001 [SvcSrvW-6] <2> Service 'Index' method 'Search' ended, processing time (ms): 32.
05:19:21.394 Trc 21125 [SvcSrvW-6] <2> Response:
  Id=2
  Type=Response
  AppName=ContactServer
  AppType=CONTACT_SERVER
  Service=Index
  Method=Search
  Parameters=
    [
      Documents=
      [
      ]
      FoundDocuments=0
      ReturnedDocuments=0
    ]
  UserData=
    [
    ].
05:19:21.395 Trc 21126 [SvcSrvW-6] <2> 'Index.Search' (request id 2) handling duration : 40 ms.

[upk_singhm]

Hi Kubig/Cavagnaro,
Did you find out anything about this?

Appreciate any help. Still struggling with this.

[Kubig]

I will try to make a test in my lab env today and let you know with a result

[upk_singhm]

Thanks Kubig,
Appreciate your help.

[Kubig]

Did you follow this link http://docs.genesys.com/Documentation/ES/8.1.4/Admin/UCSSearchMake ? I am not at my PC yet, so still without my tests

[upk_singhm]

Hi Kubig yes we did follow the instructions in that manual and if you look at some of the replies that I have mentioned above you will see that the fields from Interaction entity are mapped to the searchable columns and when I query the interaction table I do see the string attribute columns getting populated with the values as well so I hope and believe that I have configured, so I hope and believe that I have configured it as per that document unless this document in itself is missing something. And this brings me to think if there's something while installing the UCS App or DB server if we have to do something to enable this search functionality, which I i am pretty sure is configured already as otherwise i will not see the index attributes created and being enabled at the ucs level.

[cavagnaro]

Using IWS does it works?

[upk_singhm]

Hi Cavagnaro iWS only supports looking for contacts primarily and then for that contact it brings History from Interaction table. Correct me if I am wrong. So in essence I can look for contacts from the contact entity using iWS.

[Kubig]

You are not right, IWS allows to search by any available interaction data within UCS database.

[upk_singhm]

Hi Kubig,
Please correct my understanding, when I go into iWS and click the Contact button in the iWS toolbar, I get 2 panels one for the Contact Search and another for the Interaction History, now if I provide anything directly into the Interaction History panel, nothing comes up but when I search for a particular contact and then it brings along the history for that contact and then I can search within those Interactions for that contact.

Secondly: I have let's StrAttribute9 mapped to PFS_id, and under the options for the iWS application in the GA I provide the PFS_id to be a column to be listed in the Interaction History panel and then search for the records that have content for the PFS_id, it brings up those records, but when I do it for mapped column which is StrAttribute9 it doesn't bring up anything.

Hope it helps.

Let me know if you need anything else in this regard,

By the way were you able to test it out in your environment.