ucReportSetFilters adds filters and filter criteria to a report before the query is processed. This method is also called when a Related Issue Display is displayed within an add <\/em>or edit <\/em>screen.<\/p>\n Search & Reporting<\/em> screens<\/p>\n This affects all types of reports (summary, list, charts), allowing data to be segregated efficiently, for example by Customer or Privacy.<\/p>\n Purpose ucReportSetFilters adds filters and filter criteria to a report before the query is processed. This method is also called when a Related Issue Display is displayed within an add or edit screen. Applies To Search & Reporting screens Signature public void ucReportSetFilters ( FilterGroup fg) Notes This affects all types of reports (summary, list,…<\/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-24600","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\n\n\tApplies To<\/h3>\n
\n\tSignature<\/h3>\n
\r\n
public void ucReportSetFilters (\r\n FilterGroup fg)<\/code>\r\n<\/pre>\n\n\tNotes<\/h3>\n
\n\tExample<\/h3>\n
\r\n
public void ucReportSetFilters (FilterGroup fg,\r\n String mode) {\r\n \/\/ requirement: Customer-role user can only see own (originator) issue\r\n \/\/ Get current session and user\r\n SesameSession session = SesameSession.getSession();\r\n String userId = session.getUserId();\r\n String userRole = session.getUserRole();\r\n\r\n if (! \"GUEST\".equals(userRole) )\r\n return;\r\n \r\n \/\/ Get current filters\r\n ArrayList filters = fg.getFilters();\r\n\r\n \/\/ Create originator-specific filter\r\n Filter originator = new Filter(\"ORIGINATOR\");\r\n originator.setOperator(\"in\");\r\n originator.setConjunction(\"AND\");\r\n ArrayList criteria = new ArrayList();\r\n criteria.add(userId);\r\n\r\n try {\r\n originator.setFilterCriteria(criteria);\r\n } catch (Exception e) {}\r\n \r\n \/\/ If no filters exist, then just add originator filter\r\n if (filters.isEmpty() ) {\r\n filters.add(originator);\r\n fg.setFilters(filters);\r\n return;\r\n }\r\n \/\/ When filters already exist, need to add originator filter to all\r\n \/\/ \"AND\" filter sets (standard or advanced)\r\n\r\n \/\/ Iterate through current filters and add the originator filter to\r\n \/\/ the end of \"AND\" only sets, in case\r\n \/\/ any filters have \"OR\" conjuction (which cause groups of \"AND\"\r\n \/\/ filters to be evaluated together due to precedence rules)\r\n ArrayList newFilters = new ArrayList();\r\n\r\n for (int i = 0; i < filters.size(); i++) {\r\n Filter f = (Filter) filters.get(i);\r\n String conjunction = f.getConjunction();\r\n\r\n if (\"OR\".equals(conjunction) ) {\r\n \/\/ Found a filter with an \"OR\" conjunction:\r\n \/\/ add originator filter\r\n newFilters.add(originator);\r\n }\r\n newFilters.add(f);\r\n }\r\n\r\n \/\/ Add originator filter as last filter\r\n newFilters.add(originator);\r\n\r\n \/\/ Set report filters to newly modified ones\r\n fg.setFilters(newFilters);\r\n }<\/code>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"