Recipient List not Displaying in Smartweb - 7x

Overview

When Adding Groups or individuals to the recipient list section of Smartweb it will Hang/Stop and require a refresh of the smartweb instance.

This is being caused by Listing of type Function and can be resolved by applying below Patch

Resolution/Topic

Apply DE27825

Summary of changes - Making sure to back up all files changed

Replacing

 /opt/amcom/webapps/stage/smartweb/WEB-INF/classes/com/amcomsoft/smartweb/messaging/dao/impl/MessagingDaoImpl.class

And
 /opt/amcom/webapps/stage/smartweb/WEB-INF/classes/com/amcomsoft/smartweb/messaging/backingbean/MessagingSearchBackingBean.class

Also Updating statements in query_config.properties located

/opt/amcom/webapps/stage/smartweb/WEB-INF/classes/com/amcomsoft/smartweb/common/

Updating this query

From

msg_template_mg_query=select m.msg_template_id, m.title, m.print_label_flag from message_template m, group_template_assignment mg where mg.msg_template_id = m.msg_template_id and mg.group_number = :msg_group_number and UPPER(m.remark) like  upper(:remark) order by upper(title)

to

msg_template_mg_query = select msg_template_id,title,print_label_flag from ( select m.msg_template_id,m.title,m.print_label_flag from message_template m,group_template_assignment mg where mg.msg_template_id = m.msg_template_id and mg.group_number = :msg_group_number union select m.msg_template_id,m.title,m.print_label_flag from message_template m where UPPER(m.remark) like  upper(:remark) ) order by upper(title)
 

Adding this

msg_templatenum_listing_query=select m.msg_template_id, m.title, m.print_label_flag from message_template m, message_template_assignment ma where ma.msg_template_id = m.msg_template_id and ma.listing_id = util.get_l_id(:assigned_list_id) and UPPER(m.remark) like  upper(:remark)

Commit changes via weblogic for smartweb deployment