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, DbParameter[] 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?
