Shane.Steeves

Multi Select Filters on Portlet

Discussion created by Shane.Steeves on Sep 12, 2013
Latest reply on Sep 17, 2013 by Atul.Kunkulol
I know these are possible, but with my Portlet, I don't see any options to make my "resource" filter a multi-select filter.

Would it be related to how I've written my NSQL? I'm using the Lookup "Resources For Search" for this filter.


SELECT @SELECT:DIM:USER_DEF:IMPLIED:RESOURCE:ROWNUM:ROWNUMBER@,
@SELECT:METRIC:USER_DEF:IMPLIED:A."User_ID":UserID@,
@SELECT:METRIC:USER_DEF:IMPLIED:A."Full_Name":FullName@,
@SELECT:METRIC:USER_DEF:IMPLIED:A."ResourceIsActive":ResourceIsActive@,
@SELECT:METRIC:USER_DEF:IMPLIED:A."DepartmentID":DepartmentID@,
@SELECT:METRIC:USER_DEF:IMPLIED:A."Department":Department@,
@SELECT:METRIC:USER_DEF:IMPLIED:A."Project":Project@,
@SELECT:METRIC:USER_DEF:IMPLIED:A."ProjectID":ProjectID@,
@SELECT:METRIC:USER_DEF:IMPLIED:A."ProjectIsActive":ProjectIsActive@,
@SELECT:METRIC:USER_DEF:IMPLIED:A."Task":Task@,
@SELECT:METRIC:USER_DEF:IMPLIED:A."Hours":Hours@,
@SELECT:METRIC:USER_DEF:IMPLIED:A."SliceDate":SliceDate@,
@SELECT:METRIC:USER_DEF:IMPLIED:A."Employee_Type":EmployeeType@,
@SELECT:METRIC:USER_DEF:IMPLIED:A."Time_Sheet_Status":TimeSheetStatus@,
@SELECT:METRIC:USER_DEF:IMPLIED:A."Input_Type":InputType@,
@SELECT:METRIC:USER_DEF:IMPLIED:A."Note":Note@,
@SELECT:METRIC:USER_DEF:IMPLIED:A."Manager_Name":ManagerName@,
@SELECT:METRIC:USER_DEF:IMPLIED:A."PM_Name":PMName@,
@SELECT:METRIC:USER_DEF:IMPLIED:A."System":System@,
@SELECT:METRIC:USER_DEF:IMPLIED:A."CostCode":CostCode@,
@SELECT:METRIC:USER_DEF:IMPLIED:A."Service":Service@
FROM CLARITY.FSS_ALL_DATA A
WHERE (@WHERE:PARAM:USER_DEF:INTEGER:UserID@ IS NULL OR @WHERE:PARAM:USER_DEF:INTEGER:UserID@ = A."User_ID")
AND (@WHERE:PARAM:USER_DEF:STRING:ResourceIsActive@ = 'All' OR @WHERE:PARAM:USER_DEF:String:ResourceIsActive@ = A."ResourceIsActive")
AND (@WHERE:PARAM:USER_DEF:STRING:ProjectIsActive@ = 'All' OR @WHERE:PARAM:USER_DEF:String:ProjectIsActive@ = A."ProjectIsActive")
AND (@WHERE:PARAM:USER_DEF:INTEGER:Dept@ IS NULL OR EXISTS
(SELECT 1 FROM prj_obs_associations ASSOC, prj_obs_units_flat FLAT
WHERE A."srm_resources.id" = ASSOC.record_id AND ASSOC.table_name ='SRM_RESOURCES'AND ASSOC.unit_id = FLAT.unit_id AND FLAT.branch_unit_id = @WHERE:PARAM:USER_DEF:INTEGER:Dept@))
AND @FILTER@

Outcomes