Description
To validate the Upload/Pending/Processed/Not Processed routes
Query :
To validate the Upload/Pending/Processed/Not Processed routes
Query :
SELECT su.Username, rh.UserName,rh.OutletCode,rh.RouteDate,rh.RouteEndDate,rh.CreatedOn FROM RouteMDHistory rh JOIN Security_User su ON su.UserId = rh.CreatedByUserId WHERE rh.ClientId = '100' ANd rh.CreatedOn >= '2025-05-02 20:00:00.000' AND su.Username = 'Oscar_AdminVision' --------------------------------------------------