Task Report on Modern User Experience

[Fernando Rivas]

Hi there,

I´m looking forward to generate a monthly report on a project, which should provide started vs. finished tasks on current month. These tasks should also be grouped by a drop down list generated only on the view options of this project.
Issues so far:

- I cannot use the drop down list for grouping tasks on the status report
- I cannot find the drop down list as a field on task´s database tables to eventually generate a report on Classic UI´s advanced reporting Jaspersoft

Thanks in advance for any hint.
Best Regards,
Fernando

[Martti Kinnunen]

The gable for the lookup values is cmn_lookups

Query
Select
id
,lookup_type
,lookup_code
,lookup_enum
from cmn_lookups
Where
lookup_type =
'prTaskStatus'

Which returns
3397 prTaskStatus 0 0
3399 prTaskStatus 2 2
3398 prTaskStatus 1 1

The displayed values ae in cmn_captions_nls

Query
Select
id
,table_name
,pk_id
,language_code
,name
,description
from cmn_captions_nls
Where language_code = 'en'
and pk_id in ('3397','3398','3399')

Which returns
25501 CMN_LOOKUPS 3397 en Not Started Not Started
25511 CMN_LOOKUPS 3399 en Completed Completed
25506 CMN_LOOKUPS 3398 en Started Started

[Fernando Rivas]

Hi Martti, thanks for the answer

I´ve checked the cmn_lookups and realized it´s not a lookup, but rather a picklist on a Modern UX view what I want to use to group.
Is there a way to access the picklist tables on DB, joining them with tasks´ tables in order to make a report on Jaspersoft?
Thanks

[vtleogal]

Did you ever get a resolution on how to report upon picklists? Especially in joining them on the task table within Jaspersoft?

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

[Martti Kinnunen]

I do not know about the DWH but in the PPM db see

[vtleogal]

oh goodness Marti.. can you believe I never knew you replied? I had this need again and found your reply. 
So, I wanted to formally thank you for your reply  (even though months ago  ) 
thanks!  Better late than never?  :)

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