SCALE ICONS FOR FEEDBACK

Execute below steps to make Scale(Rating) icons available for Feedback Module.

Insert Query for DIGX_CM_CONTENT Table

Enter a Unique ID, the same ID would be used to update in digx_fd_scale table.

Insert into DIGX_CM_CONTENT (ID,PARTY_ID,DOCUMENT_CHECKLIST_ID,TITLE,MIME_TYPE,CONTENT_CATEGORY,CONTENT_TYPE,FILE_CONTENT,CONTENT_SIZE,

SHARED_FLAG,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,OBJECT_STATUS) 

values (‘${contentId1}’,null,null,'heart-fill.svg','image/svg',null,null, null,'','Y',1,'superadmin',sysdate,'superadmin',sysdate,null)

 

Insert into DIGX_CM_CONTENT (ID,PARTY_ID,DOCUMENT_CHECKLIST_ID,TITLE,MIME_TYPE,CONTENT_CATEGORY,CONTENT_TYPE,FILE_CONTENT,CONTENT_SIZE,

SHARED_FLAG,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,OBJECT_STATUS) values (‘${contentId2}’,

null,null,'star.png','image/jpeg',null,null, null,'','Y',1,'superadmin',sysdate,'superadmin',sysdate,null);

 

Insert into DIGX_CM_CONTENT (ID,PARTY_ID,DOCUMENT_CHECKLIST_ID,TITLE,MIME_TYPE,CONTENT_CATEGORY,CONTENT_TYPE,FILE_CONTENT,CONTENT_SIZE,

SHARED_FLAG,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,OBJECT_STATUS) values (‘${contentId3}’,null,

null,'thumbs-up.svg','image/jpeg',null,null, null,'','Y',1,'superadmin',sysdate,'superadmin',sysdate,null);

Execute Procedure:

For more info refer:

Oracle Banking Digital Experience Content Upload Configuration Guide.docx

to complete perquisite steps.

• This Procedure updates the BLOB Column for that specific content ID
• Pass the same content ID for respective image as a parameter.

begin

load_file_to_content('CONTENT_FILES','heart-fill.svg', ‘${contentId1}’);

end;

/

begin

load_file_to_content('CONTENT_FILES','star.png ', ‘${contentId2}’);

end;

/

begin

load_file_to_content('CONTENT_FILES','thumbs-up.svg ', ‘${contentId3}’);

end;

/

Execute Update Query: digx_fd_scale Table

• Update the contentId in respective table to be used.

update  digx_fd_scale set content_id=‘${contentId1}’ where determinant_value in  ('*','OBDX_BUBusiness Unit') and  id='1';

update  digx_fd_scale set content_id=‘${contentId2}’ where determinant_value in  ('*','OBDX_BU') and  id='2';

update  digx_fd_scale set content_id=‘${contentId3}’ where determinant_value in  ('*','OBDX_BU') and  id='3';

Home