This discussion is archived
2 Replies Latest reply: Nov 21, 2012 10:33 PM by 947349 RSS

Unresolved column error

947349 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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"

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points