| Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-196724 - After upgrade Dashboards are blank|http://helpdesk.irely.com/iRelyi21live/i21/#/HD/Ticket/?ticket=HDTN-196724]
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-196689 - Dashboard panels in 17.1 - showing internal server error|http://helpdesk.irely.com/iRelyi21live/i21/#/HD/Ticket/?ticket=HDTN-196689]
*Using: 17.1.0331.28*
*Issues with Reproduction Steps:*
1. Dashboard panel in Alex's log in, named 'GC POsition (Spot)' is not fetching any record in 17.1 build though this is was fetching in 16.4 builds.
!pastedImage_d73763_0.png!
2. Below is the dashboard query.
Select vyuLGContainerPositionView.dtmEndDate, vyuLGContainerPositionView.strDeliveryMonth, vyuLGContainerPositionView.strItemNo, vyuLGContainerPositionView.strContractNumber, vyuLGContainerPositionView.strCustomerContract, vyuLGContainerPositionView.strEntityName, vyuLGContainerPositionView.strItemDescription, vyuLGContainerPositionView.strContractBasis, vyuLGContainerPositionView.dblBasis, vyuLGContainerPositionView.strFinalPrice, vyuLGContainerPositionView.intNoOfContainers, vyuLGContainerPositionView.intNoOfApprovals, vyuLGContainerPositionView.intNoOfRejects, vyuLGContainerPositionView.intNoOfIntegrationRequests, vyuLGContainerPositionView.intTrucksRemaining, vyuLGContainerPositionView.strRemarks, vyuLGContainerPositionView.intNoOfContainers - vyuLGContainerPositionView.intNoOfApprovals As calc, (vyuLGContainerPositionView.intNoOfContainers + vyuLGContainerPositionView.intNoOfApprovals + vyuLGContainerPositionView.intNoOfIntegrationRequests) / 3 / vyuLGContainerPositionView.intNoOfContainers As calc2 From vyuLGContainerPositionView Where vyuLGContainerPositionView.dtmEndDate < DateAdd(MONTH, 1, GetDate())
3. Please note this is fetching records from database.
!pastedImage_d73763_1.png!
*Expected Results:*
1. This dashboard query should fetch record from dashboard panel also.
|