OBS Mode in Power Filter on Custom Portlet

[Christoph Schubert]

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

[Deactivated User]

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.

[Christoph Schubert]

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)

[David Morton]

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.