ucReportSetUdfMultiSql is used to override the SQL statement used to look up multi-value UDF\u2019s.<\/p>\n
Search & Reporting<\/em> screens<\/p>\n This can be used to retrieve arbitrary information to display, using the multi value UDF list handling.<\/p>\n Purpose ucReportSetUdfMultiSql is used to override the SQL statement used to look up multi-value UDF\u2019s. Applies To Search & Reporting screens Signature public String ucReportSetUdfMultiSql ( String[] udfName, \/\/ database name of the UDF String sqlStatement, \/\/ standard sql statement String problemKey, \/\/ alias for the problem id String idList, boolean doTitleMap) \/\/ in clause…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":24510,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"","_lmt_disable":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-24601","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\n\n\tSignature<\/h3>\n
\r\n
public String ucReportSetUdfMultiSql (\r\n String[] udfName,\t\t\/\/ database name of the UDF\r\n String sqlStatement,\t\/\/ standard sql statement\r\n String problemKey,\t\/\/ alias for the problem id\r\n String idList,\r\n boolean doTitleMap) \t\/\/ in clause for problem ids<\/code>\r\n<\/pre>\n\n\tNotes<\/h3>\n
\n\tExample<\/h3>\n
\r\n
public String ucReportSetUdfMultiSql(\r\n String[] udfName, \/\/ database name of the UDF\r\n String sqlStatement, \/\/ standard sql statement\r\n String itemKeyAlias, \/\/ alias for the item id\r\n String idList, \/\/ in clause for item ids.\r\n boolean doTitleMap) {\r\n if (udfName == null || udfName.length() == 0)\r\n udfName = \"RELATED_ISSUES\";\r\n\r\n if (!\"RELATED_ISSUES\".equalsIgnoreCase(udfName) )\r\n return sqlStatement ;\r\n\r\n return \"select i.item_id \" + problemKey + \", '\" + udfName \r\n + \"' UDF_NAME, i2.item_id TITLE \" +\r\n \" from (select item_id from item where item_id in \" + idList + \") i, \r\n item i2, \" +\r\n \" (select item_id, value_number from udf, item_udf \" +\r\n \" where udf.name = 'PARENT_ID' and item_udf.udf_id = udf.udf_id) iu, \" +\r\n \" (select item_id, value_number from udf, item_udf \" +\r\n \" where udf.name = 'PARENT_ID' and item_udf.udf_id = udf.udf_id) iu2\" +\r\n \r\n \/\/ include dummy parameter bind condition which will do nothing\r\n \" where ? = '\" + udfName + \"'\" +\r\n \r\n \/\/ exclude the current bug from the list\r\n \" and i2.item_id != i.item_id \" +\r\n \" and (\" +\r\n \" (i2.item_id = iu.item_id and iu.value_number \r\n = i.item_id and iu2.item_id \r\n = iu.item_id and iu2.value_number= iu.value_number) \" +\/\/ direct children\r\n \r\n \"or (i2.item_id = iu.value_number and iu.item_id \r\n = i.item_id and iu2.item_id = iu.item_id \r\n and iu2.value_number= iu.value_number) \" +\/\/ parent\r\n \"or (i2.item_id = iu2.item_id and iu2.value_number \r\n = iu.item_id and iu.value_number = i.item_id) \" + \/\/ direct grandchildren\r\n \" or (i2.item_id = iu2.item_id and iu2.value_number \r\n = iu.value_number and iu.item_id = i.item_id) \" + \/\/ peers\r\n \" or (i2.item_id = iu2.value_number and iu2.item_id \r\n = iu.value_number and iu.item_id = i.item_id) \" + \/\/ grandparent\r\n \" ) order by \" + problemKey + \",UDF_NAME, TITLE\" ;\r\n }\r\n return sqlStatement;\r\n }<\/code>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"