SUMMARY:
When using a custom lookup for User Value 1 on the timesheet the value chosen on the timesheet is blank once the timesheet is submitted. The value is in the database and will show if the timesheet is returned.
Release : 16.1.1
One line was missing from the query.
In order for the values to show correctly in MUX we need a line in the lookup with DISPLAY VALUE@
The whole query would be similar to
select @SELECT:te.prid:prtimeentryid@,
@SELECT:po.code:uservalue@,
@SELECT:po.code:DISPLAYVALUE@
from prtimesheet ts
inner join prtimeentry te on te.prtimesheetid = ts.prid
inner join PRASSIGNMENT ass on ass.prid = te.PRASSIGNMENTID
inner join prtask task on task.prid = ass.prtaskid
inner join odf_ca_svcs_po po on po.ODF_CNCRT_PARENT_ID = task.prprojectid
and po.PO_ROLE = ass.role_id
and po.BLOCKDEL = 0
inner join srm_resources res on res.id = ts.PRRESOURCEID
WHERE ts.prid = @where:param:user_def:integer:userdeftsid_param@
and @FILTER@