Hi Friends,

I have observed a strange behaviour when i'm using SmartObjectClientServer.ExecuteSQLQueryDataTable(sqlQuery) method. Actually the smartobject has around 22000 records, but when i call the same smartobject's method  in .Net using above api method it is returning only 6000 records. I also verified with its overlaod method ExecuteSQLQueryDataTable(string sqlString, DbParametere] dbParameters, bool autoAlias, int startRecord, int maxRecords) by passing max records as 10000, but the result is still same. 

To verify other possibilities i tried using SmartObjectClientServer.ExecuteListDataTable(SmartObject) method but still the result is same.

ADO Query Used: SELECT * FROM Process_Instance

SmartObject Name: Process_Instance

Method Name : List

Could any one help me on this?