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)
If you have something like
AND (@WHERE:PARAM:USER_DEF:INTEGER:obs_res@ IS NULLOR SRM_RESOURCES.ID IN(SELECT s_res.idFROM 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_idWHERE 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.
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)
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.