Where clause

[Anonymous]

Trying to filter but the error prevails.Please advice thanks

[tresesco]

Check if the date in the DB field format is same as 'YYYY-MM-DD' or not. May be the different date format comparison causing the error.

[Clever_Anjos]

ORA-12801 usually has another error associated, please scroll right the screen and check

It seems to start with ORA-018....

[Clever_Anjos]

If its a date formatting issue you could try

MAN_ITEM_REPORT_DATE > TO_DATE('2010-01-01','YYYY-MM-DD')

[Anonymous]

This is the full error message displayed;

ErrorSource: OraOLEDB, ErrorMsg: ORA-12801: error signaled in parallel query server P179

ORA-01861: literal does not match format string

MANIFEST:

FIRST 1000

SELECT * from MANIFEST_ITEMS

WHERE MAN_ITEM_REPORT_DATE > '2010-01-01'

[Anonymous]

This is how QV displays it when the filter is rem out

[Clever_Anjos]

Try

Where

MAN_ITEM_REPORT_DATE > TO_DATE('2010-01-01','YYYY-MM-DD')

[VishalWaghole]

Hi Adotey Kwame,

Its not only Date Format, Its Date with Timestamps format

so you will need to do Query Like this..

MANIFEST:

FIRST 1000

SELECT * from MANIFEST_ITEMS

WHERE MAN_ITEM_REPORT_DATE > to_date('2010-01-01 00:00:00', 'YYYY:MM:DD HH24:MI:SS')

Thanks and Regards,

Vishal Waghole

[Anonymous]

See my old document here, maybe it helps: http://community.qlik.com/docs/DOC-1321