2 Replies Latest reply: Nov 22, 2012 12:33 AM by 947349 RSS

    Unresolved column error

    947349
      I have month date prompt like
      01/31/2012
      08/31/2012
      ......

      based on date i am calling some columns(each month date as result diff columns)

      Now think i am selecting 8/31/2012(aUGUST)


      iin answers i have given like below
      "Ledger"."@{pvdate1}"


      Alias i have given for particular column like 2012-08-31 OR 08/31/2012

      But i receive below error,

      Unresolved column: "Ledger"."date '2012-08-31'".
      later i tried giving like this still same error
      "Ledger"."date '@{pvdate1}'"

      Note:Column which i expect in result is of DOUBLE data type
        • 1. Re: Unresolved column error
          Srini VEERAVALLI
          You suppose to use '@{pvdate1}'
          soemthing like "Ledger"."day"= date '@{pvdate1}'

          In criteria to date column->filter icon->Advanced->Convert it to SQL filter
          and use "Ledger"."day"= date '@{pvdate1}'

          this should work since you are casting it to date.

          If helps pls mark as correct else update with error message
          • 2. Re: Unresolved column error
            947349
            Veeravalli,

            My request is similar to below link,but i use date in prompt there it was month name

            Performance Tuning


            I received below error,i tried filter as you said

            Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P
            State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27005] Unresolved column: "Ledger N"."date '2012-08-31'". (HY000)
            SQL Issued: {call NQSGetQueryColumnInfo('SELECT "Ledger N"."date ''2012-08-31''" FROM "Profitability"')}

            SQL Issued: SELECT "Ledger N"."date '2012-08-31'" FROM "Profitability"