[SalesForce] How to query records

In Account object I have 1000 records.i need to query first 100 records,next i need to query after 101 records.how it is possible.my first query is like that

[select id,name from Account LIMIt 100];

i want query like this[select id,name from Account LIMIT 101];

Best Answer

Use OFFSET

When expecting many records in a query’s results, you can display the results in multiple pages by using the OFFSET clause on a SOQL query. For example, you can use OFFSET to display records 51 to 75 and then jump to displaying records 301 to 350. Using OFFSET is an efficient way to handle large results sets.

Use OFFSET to specify the starting row offset into the result set returned by your query. Because the offset calculation is done on the server and only the result subset is returned, using OFFSET is more efficient than retrieving the full result set and then filtering the results locally. OFFSET is available in API version 24.0 and later.

[select id,name from Account LIMIT 100 OFFSET 100 ];

this will return all the records except starting 100 records

you need to query like [select id,name from Account OFFSET 100 LIMIT 100];

each time you need to increase OFFSET value like to get the first 100 use offset = 0 and limit 100, this will return first 1-100 records.

2nd time set OFFSET 100 and limit 100 this will return 101 to 200 records.

3rd time set OFFSET 200 and limit 100 this will return 201 to 300 records ...

this way you can use till 2000 records but after that you can't because OFFSET have limit of 2K. We can use more than 2k value in OFFSET

Related Solutions

[SalesForce] How to query distnict opportunity records

There will not be direct SOQL query which can meet your requirement.

Here is the approach.

Put ORDER BY AccountId,Number_of_Units__c Desc in SOQL

Since you are retrieving records in DESC, so highest value for an Account will be displayed first and that will be added to the map.

Now, next time, for the same account, if Opportunity record is coming then that will be ignored.

finally take the mapAccountWithOpporty.values() which will have Opportunity with highest Number_of_Units__c, perform whatever you want to do.

//this map holds AccountId with that Opportunity which has highest Number_of_Units__c
Map<Id, Opportunity> mapAccountWithOpporty = new Map<Id, Opportunity>();

List<Opportunity> lstOppty = [Select Id, AccountId, Number_of_Units__c,Name,StageName,Type,Billing_City__c,Opp_Sic_Code__c 
                                from Opportunity 
                                where Billing_City__c=:cityset 
                                AND Opp_Sic_Code__c=:Sicset 
                                AND StageName='Closed Won' 
                                ORDER BY AccountId,Number_of_Units__c Desc];
for(Opportunity opty:lstOppty)
{
    if(!mapAccountWithOpporty.containsKey(opty.AccountId))
    {
        mapAccountWithOpporty.put(opty.AccountId, opty);
    }
}

[SalesForce] Soql query field value starts with

the expression 'comp%' will bring everything that starts with 'comp' and ends with anything

if you want to always guarantee 4 letters after 'comp' you can use it as follows LIKE 'comp____' use 4 underscore to ensure 4 characters after 'comp'

Best Answer

Related Solutions

[SalesForce] How to query distnict opportunity records

[SalesForce] Soql query field value starts with

Related Topic