Dynamic Multivalue lookup error in new UX

[Vit Posel]

Did somebody reach the same problem and find a solution?

Steps to reporduce:

1. Create custom lookup (name: SPP Prvky, id: C_L_SPP_PRVKY) from query

SELECT  @SELECT:RESOURCES.ID:ID@,

        @SELECT:RESOURCES.FULL_NAME:FULL_NAME@,

        @SELECT:RESOURCES.LAST_NAME:LAST_NAME@,

        @SELECT:RESOURCES.FIRST_NAME:FIRST_NAME@,

        @SELECT:RESOURCES.UNIQUE_NAME:UNIQUE_NAME@,

        @SELECT:RESOURCES.UNIQUE_NAME:UNIQUE_CODE@,

        @SELECT:RESOURCES.LAST_UPDATED_DATE:LAST_UPDATED_DATE@

FROM    SRM_RESOURCES RESOURCES              

WHERE   @FILTER@ 

AND     case when resources.user_id is null then 0 else resources.user_id end != -99            

AND     RESOURCES.RESOURCE_TYPE = 3

2. Create custom attribute on object Project
   3. Create custom lookup (name: SPP Prvky Task, id: C_L_SPP_TASK) from query

select

                  @SELECT:RESOURCES.ID:ID@,

        @SELECT:RESOURCES.FULL_NAME:FULL_NAME@,

        @SELECT:RESOURCES.LAST_NAME:LAST_NAME@,

        @SELECT:RESOURCES.FIRST_NAME:FIRST_NAME@,

        @SELECT:RESOURCES.UNIQUE_NAME:UNIQUE_NAME@,

        @SELECT:RESOURCES.UNIQUE_NAME:UNIQUE_CODE@,

        @SELECT:RESOURCES.LAST_UPDATED_DATE:LAST_UPDATED_DATE@

from ODF_MULTI_VALUED_LOOKUPS mv

left join PRTASK tsk on tsk.PRPROJECTID = mv.PK_ID

left join SRM_RESOURCES RESOURCES on RESOURCES.ID = mv.VALUE

where mv.OBJECT = 'project' and mv.attribute = 'c_prj_spp'

and (tsk.PRPROJECTID = @WHERE:PARAM:USER_DEF:INTEGER:PRJ_ID@ or @WHERE:PARAM:USER_DEF:INTEGER:PRJ_ID@ is null)

4. Create custom attribute on object Task
   1. Name: SPP Prvky
   2. Id: c_tsk_spp_prvky
   3. Data type: Multi Valued Lookup
   4. Map parameter prj_id to prprojectid

4. Add custom task attribute to detail view in New UX and try to select some values

Expected result: values are selected and saved

Actual result: Values are not saved, error message in browser console

API Response:

{"resourceId":"5015002","httpStatus":"400","errorMessage":"CMN-0009: Attribute 'SPP Prvky' has invalid Lookup Value '[5010002, 5010003]'","errorCode":"validation.lookupValueInvalid"}

------------------------------
Consultant
Catta Consulting
Czech Republic
------------------------------

[Vit Posel]

Even original lookup was correct for older version now my colleagues find a way how to make it correct for 15.8.1

select
@SELECT:RESOURCES.ID:ID@,
@SELECT:RESOURCES.FULL_NAME:FULL_NAME@,
@SELECT:RESOURCES.LAST_NAME:LAST_NAME@,
@SELECT:RESOURCES.FIRST_NAME:FIRST_NAME@,
@SELECT:RESOURCES.UNIQUE_NAME:UNIQUE_NAME@,
@SELECT:RESOURCES.UNIQUE_NAME:UNIQUE_CODE@,
@SELECT:RESOURCES.LAST_UPDATED_DATE:LAST_UPDATED_DATE@
from ODF_MULTI_VALUED_LOOKUPS mv
left join PRTASK tsk on tsk.PRPROJECTID = mv.PK_ID
left join SRM_RESOURCES RESOURCES on RESOURCES.ID = mv.VALUE
where mv.OBJECT = 'project' and mv.attribute = 'c_prj_spp' and @FILTER@
and (tsk.PRID = @WHERE:PARAM:USER_DEF:INTEGER:PRJ_ID@ or @WHERE:PARAM:USER_DEF:INTEGER:PRJ_ID@ is null)


Lookup mapping on atrribute to OBJECTID
------------------------------
Consultant
Catta Consulting
Czech Republic
------------------------------