Wrong mapping for Task Status when creating a new dashboard data source of type Opp/Proj Tasks >> this is mapped as Task priority instead of Task Status

Version 1

    Details

    Wrong mapping for Task Status when  creating a new dashboard data source of type Opp/Proj Tasks >>  this is mapped as Task priority instead of Task Status


    [STEPS TO REPRODUCE]
    1. Go To >> Dashboards
    2. Right Click >> New in the Dash board tree (or at the bottom >> New Dashboard hyperlink)
    3. Press New Data Source hyperlink (at the bottom left)
    4. Select in Type of data's drop down list >> Opp/Proj Tasks



    5. Leave Creation Method as default to Start with a blank data source
    6. Name = Dashboard Test
    7. Leave all other settings in General properties page as default


    8. In Choose the fields to be used in creating dashboards with this data source >> Add Button
    9. Field drop down Task status >> review the resulting Column name (before OK)
    >> RESULT 1
    Task status shows as column name Task_priority (which lets assume that this is wrong but should be instead something like Task_status)


    10. OK >> review the resulting Column name (before OK)
    >> RESULT 2

    Also in the final field selection this appears now as Column Name Task_priority instead of something like Task_status



    Even when the user thinks to made a mistake initially and/or both are mixed up within the application and the user would try to add also Field  drop down Task priority, the assignment between Task Priority and the field Task_priority is correct in the  background mapping and therefore cannot be added a second time



    Resolution

    [CAUSE]
    This is RM # 218626


    [WORKAROUND]
    1. Proceeding with the new Data Source Wizard as desired until you get to the Query Window


    2. Activate the checkbox Edit manually
    3.  Replace in the query the incorrect field mapping ts.STAGE and the incorrect column header with the correct/desired values (field value ts.STAGE into ts.STATUS and [Task_priority] into [Task_status] and verify with the Check and Preview Buttons that the results  are now as expected.

    Incorrect query: 


    Corrected query:



    Additional Note: It may require several replacements or/and even amendments depending on the complexity of the desired Data Source