3 Replies Latest reply: Feb 10, 2017 11:36 AM by Andy Weir RSS

    Can not run an sql query on qlik sense data loader

    victor onyebuchi

      stalwar1 need help in running an SQL query, the query runs perfectly fine on my SQL developer but not on my QLIK SENSE  data load. Please who might know what I am doing wrong??

       


      SQL select PROBLEM_ID
             ,CREATE_DATE
             ,TO_CHAR(TO_DATE(ARADMIN.GET_REM_DATE(CREATE_DATE), 'MONTH DD, YYYY HH12:MI:SSAM'), 'YYYY') AS CREATE_YEAR
             ,TO_CHAR(TO_DATE(ARADMIN.GET_REM_DATE(CREATE_DATE), 'MONTH DD, YYYY HH12:MI:SSAM'), 'MON') AS CREATE_MONTH_
             ,TO_CHAR(TO_DATE(ARADMIN.GET_REM_DATE(CREATE_DATE), 'MONTH DD, YYYY HH12:MI:SSAM'), 'MONTH') AS CREATE_MONTH
             ,TO_CHAR(TO_DATE(ARADMIN.GET_REM_DATE(CREATE_DATE), 'MONTH DD, YYYY HH12:MI:SSAM'), 'Mon-YY') AS CREATE_Time
             ,BUSINESS_UNIT
             ,Decode(STATUS ,0,'Unknown Error'
                            ,1,'Work around Provided'
                            ,2,'Root cause Identified'
                            ,3,'Request For Change'
                            ,4,'Closed')  AS STATUS
             ,COUNTRY
             ,WORKING_HOURS
             ,PRIORITY
             ,WORKLOG
             ,SERVICE_OWNER
             ,INCIDENT_COUNT
             ,CLOSED_DATE
             ,TO_CHAR(TO_DATE(ARADMIN.GET_REM_DATE(CLOSED_DATE), 'MONTH DD, YYYY HH12:MI:SSAM'), 'YYYY') AS CLOSED_YEAR
             ,TO_CHAR(TO_DATE(ARADMIN.GET_REM_DATE(CLOSED_DATE), 'MONTH DD, YYYY HH12:MI:SSAM'), 'MON') AS CLOSED_MONTH_
             ,TO_CHAR(TO_DATE(ARADMIN.GET_REM_DATE(CLOSED_DATE), 'MONTH DD, YYYY HH12:MI:SSAM'), 'MONTH') AS CLOSED_MONTH
             ,TO_CHAR(TO_DATE(ARADMIN.GET_REM_DATE(CLOSED_DATE), 'MONTH DD, YYYY HH12:MI:SSAM'), 'Mon-YY') AS CLOSED_Time
             ,SUMMARY
             ,SOLUTION
             ,ROOT_CAUSE_DETAIL
      FROM PROBLEM_MANAGEMENT

      WHERE to_date(ARADMIN.get_rem_date(CREATE_DATE), 'Month DD, YYYY HH:MI:SSAM') > to_date('01/01/2016', 'MM/DD/YYYY')
        and to_date(ARADMIN.get_rem_date(CREATE_DATE), 'Month DD, YYYY HH:MI:SSAM') < to_date('01/01/2018', 'MM/DD/YYYY')
       
        AND SERVICE_OWNER in ( 'Mark');