Skip to Content
0
Former Member
Jun 09, 2011 at 06:12 PM

Facing data type error when changing the order of fields in a query

36 Views

Hello Experts

I am working on E sourcing 5.1.

I have a query with some filters . I want to change the position of a particular filter.

Basically I want to move a filter of type date to the top , so that it is the 1st parameter.

I was able to do this by reorder option.

However at runtime it gives me an error saying that "error u201CORA-00932: inconsistent datatypes: expected NUMBER got date."

Later I reverted back my changes so that the date filed is at its original position and faced no issues.

Query worked fine.

Is the order of filters important when executing a query.

Please suggest how can I move the date filter to the top of the query's filter list.

Regards

Vikas