Apex Code Development You need to sign in to do that
Don't have an account?
1542VeMan getCompleteResult on setControllers using a database queryLocator with a LIMIT clause
I have a setController where I'm using a database.queryLocator entering a query string that ends with a LIMIT clause under 10000.
When I set the LIMIT clause in the query string, the setCon.getCompleteResult() method reports as TRUE - that is all the records were found. The problem is that we have over 10000 records of this object, so I would expect the setController response to be FALSE.
If I remove the LIMIT clause in the query string, the system returns a too many rows error.
I don't see any examples on the board, in the documentation, or anywhere else where the getCompleteResult() method on the setController is used in a situation where there are too many records in the database, so I don't see when the getCompleteresult() method would ever return a value of FALSE. If you add a LIMIT clause to the query, getCompleteResult() says I got all the records, which I know isn't true. If I don't, I get the query error.
When I set the LIMIT clause in the query string, the setCon.getCompleteResult() method reports as TRUE - that is all the records were found. The problem is that we have over 10000 records of this object, so I would expect the setController response to be FALSE.
If I remove the LIMIT clause in the query string, the system returns a too many rows error.
I don't see any examples on the board, in the documentation, or anywhere else where the getCompleteResult() method on the setController is used in a situation where there are too many records in the database, so I don't see when the getCompleteresult() method would ever return a value of FALSE. If you add a LIMIT clause to the query, getCompleteResult() says I got all the records, which I know isn't true. If I don't, I get the query error.
// this is supposed to tell the user that the result is incomplete and to apply a filter
public boolean resultComplete {get; set;}
public ApexPages.StandardSetController SetCon {
get {
if(SetCon == null) {
System.debug('SetCon is null; loading');
String query = getQuery(); //returns query string ending with 'LIMIT 5000'
SetCon = new ApexPages.StandardSetController(Database.getQueryLocator(query));
}
setCon.setPageSize(pageSize);
numAvailableLogs = setCon.getResultSize(); // this = 5000
System.debug('numAvailableLogs is '+numAvailableLogs);
numPages = (math.mod(numAvailableLogs,pageSize) == 0)? (numAvailableLogs/pageSize) : ((numAvailableLogs/pageSize)+1);
resultComplete = setCon.getCompleteResult(); // this returns true (there are more records)
System.debug('setCon resultComplete is '+resultComplete);
hasNext = setCon.getHasNext();
hasPrevious = setCon.getHasPrevious();
pageNumber = setCon.getPageNumber();
return SetCon;
}
set;
}
Just to clarify, when you remove the LIMIT clause, you get the debug output for resultComplete as TRUE? or it just throws too many rows error.