MUX Custom Uservalue1 lookup shows blank after timesheet submission

Products

• Clarity PPM SaaS

Issue/Introduction

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.

Environment

Release : 16.1.1

Cause

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@

Resolution

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@

Additional Information

User-defined Lookup with Time Entry User Value 1 for Timesheet Entries - How to Create