Parameterized Lookup empty in New UX

[Uwe Kerntopf]

I have a lookup (in Classic) where I need to know in which instance of a subobject of object Project I am. I want to link to the tasks of this project (multi).

I have used in Classic this construct:

SELECT 

@SELECT:task.prid:ID@,

@SELECT:task.prexternalid:AUFGABENID@,

@SELECT:task.prname:NAME@,

@SELECT:task.prstatus:STATUS@,

@SELECT:lup.name:STATUSF@,

@SELECT:task.prstart:ANFANG@,

@SELECT:format(task.prstart,'dd.MM.yyyy'):ANFANGF@,

@SELECT:task.prfinish:ENDE@,

@SELECT:format(task.prfinish,'dd.MM.yyyy'):ENDEF@,

@SELECT:task.prIsMilestone:MEILENSTEIN@,

@SELECT:case task.prismilestone when 0 then 'Nein' else 'Ja' end:MEILENSTEINF@,

@SELECT:task.prIsKey:BERICHTSRELEVANT@,

@SELECT:case task.prIsKey when 0 then 'Nein' else 'Ja' end:BERICHTSRELEVANTF@,

@SELECT:task.prname + ' (' + task.prexternalid + ')':ANZEIGENAME@

  FROM [niku].[PRTASK] task

  inner join odf_ca_project odf on odf.id = task.prprojectid

  inner join odf_ca_d_lieferobjekte lief on lief.odf_parent_id = odf.id

  left join cmn_lookups_v lup on lookup_type = 'prTaskStatus' and language_code = 'de' and lup.lookup_enum = task.prstatus

  where 1=1 and @FILTER@

  and lief.id = @where:param:xml:integer:/data/odf_pk/@value@

In New UX this lookup is empty because the URL is different.

I have seen In the New UX Parameterized Lookups show no values (broadcom.com), but do not see the solution. We are on 15.8.1. (OnPremise).

------------------------------
Uwe Kerntopf
Senior Technical Consultant
Fujitsu Technology Solutions GmbH
Germany
------------------------------

[Martti Kinnunen]

I take it that you get values displayed in Classic.
The Tech doc says

• Starting in 15.7, parameterized lookups are now supported, so the API Attribute ID is automatically populated for the respective attributes such as Project Category

Does that not suggest that no special action or solution is needed?

If that is the case the support for parametrized lookup is buggy.

[Martti Kinnunen]

See also Issues Fixed in 15.9.2.1

• DE60278: Parameterized Lookup Shows No Values in the Drop-Down List in Clarity

[vtleogal]

This was my defect:)  it is actually fixed in 15.9.2 PATCH 1-- not fixed in 15.9.2 so that might be a document mistake.  The issue was around having a constraint (where clause) in the lookup
However, please note that I have another lookup, parameterized with a where clause and it does NOT work in the patch. The only difference I see is that this one also uses a case statement. We are working through ours to figure it out, but I wanted to pass that along

------------------------------
Lynn
------------------------------

[Christoph Schubert]

Hi Uwe,

for me the issue was resolved when changing the query of the parameter to:
  and lief.id = @where:param:USER_DEF:integer:lief_id@

and then made a parameter mapping at the attribute on the object from "lief_id" to "[--Object-ID--]"

Then the values were available in Classic UI and New UX.

Regards
Christoph

------------------------------
...
------------------------------