Genesys CTI User Forum > Genesys-related Development
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.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version