Clarity PPM

Expand all | Collapse all

OBS Mode in Power Filter on Custom Portlet

Jump to Best Answer
  • 1.  OBS Mode in Power Filter on Custom Portlet

    Posted 04-16-2019 12:07 PM

    Hi,

     

    is it possible to have the OBS Mode field appearing, when the Parameter OBS is selected in the Power Filter on a custom portlet?

     

    I see this behaviour on objects, like project (and also custom objects):

    --> "unit only" etc. is popping up after select "OBS Unit" in the dropdown

     

    also on custom objects:

     

    But on a custom portlet it will not appear, even if the attribute is linked with OBS:

    note: id is linked to the OBS in the Query, so you can select an OBS Unit into the Right-Field. But there is no dropdown appearing below to select the Unit Mode.

     

     

    Isn't this possible on Portlets? Or how can I achieve this?

     

    Business Case behind this is, that we want to select multiple OBS Units (just possible in Power Filter)

    and use the feature to dynamical select whether with descendents or just for the unit. (This is just possible in the normal filter)

     

    Thanks

    Christoph



  • 2.  Re: OBS Mode in Power Filter on Custom Portlet

    Posted 04-16-2019 03:45 PM

    It depends...

    If you have something like

    AND (@WHERE:PARAM:USER_DEF:INTEGER:obs_res@ IS NULL
    OR SRM_RESOURCES.ID IN
    (SELECT   s_res.id
    FROM     SRM_RESOURCES s_res
             INNER JOIN prj_obs_associations oass
                ON oass.table_name = 'SRM_RESOURCES'
               AND oass.record_id = s_res.id
             INNER JOIN obs_units_flat_by_mode flat
                ON oass.unit_id = flat.linked_unit_id
    WHERE    flat.unit_id = @WHERE:PARAM:USER_DEF:INTEGER:obs_res@
    AND      flat.unit_mode = @WHERE:PARAM:USER_DEF:STRING:obs_res_mode@
    ))

     

    in your query and have respective lookup for the  obs_res_mode parameter.



  • 3.  Re: OBS Mode in Power Filter on Custom Portlet

    Posted 04-23-2019 09:17 AM

    Hi urmas,

     

    thanks. But I guess your code provided is, to achieve it, to make both OBS fields available in the normal filter.

    This I already have.

     

    I was wondering, why the dropdown field "OBS mode" is not appearing in the Power Filter of a custom portlet, when I choose the OBS as the first attribute.

    As you see in the original post. The first 2 screenshots are made from objects. The third screenshot is from a portlet Power filter (where "id" is linked to the OBS)



  • 4.  Re: OBS Mode in Power Filter on Custom Portlet
    Best Answer

    Posted 04-23-2019 09:23 AM

    I was wondering, why the dropdown field "OBS mode" is not appearing in the Power Filter of a custom portlet,

    "Objects" have a lot of built-in functionality.

    Custom NSQL-based portlets we have to "code in" everything ourselves into the NSQL.