Not able to get the result while passing the parameter in Where Clause

Not able to get the result while passing the parameter in Where Clause

  
 Hi Everyone, I have a advance query, which is getting the result Perfectly if not passing any parameter in where clause, but not getting Result while passing the parameter, the Records in the table from which we are getting the data is approx 80 lac. Sometime i am getting the result, but its taking a long time.i am using rownum<=1000 in where clause

Thanks 
Rajendra Netlink
Hi,

we cannot answer this without showing the actual sql.

In order to troubleshoot this we would need to see the entity structure, the query, the parameter and some data.  This could all be done by exporting your eSpace as an OML file assuming there is nothing in there that you don't want others to see.  You can attach the file to this thread.

Some questions before you do that though.

1) Why are you using an advanced query for something that a simple query or aggregate can do?
2) Are you sure that the parameter type and entity attribute type in the where clause are the same?
3) Do you have an index on the field in the where clause?
4) You said you don't get the result when passing a parameter but then you say the result is slow.  This is confusing.  Does it return the records you expect?

This should get you started troubleshooting.

Curt