Get Record(s) by Ids

最新推荐文章于 2023-10-26 14:45:35 发布

感动了超人

最新推荐文章于 2023-10-26 14:45:35 发布

阅读量1.2k

点赞数

CC 4.0 BY-SA版权

分类专栏： Salesforce Developer 文章标签： apex select

本文链接：https://blog.youkuaiyun.com/u014231466/article/details/70227203

Salesforce Developer 专栏收录该内容

0 篇文章

订阅专栏

本文介绍了一种通过解析Salesforce对象ID前缀来获取特定对象记录的方法，并提供了高效的批量查询实现，旨在优化SOQL查询性能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Use this to get record or records by id.

/**
 * Created by mengt on 2017/4/18.
 */

public class sobjectDaoHelper {
    public static Sobject getById(Id recordId){
        String queryStr = 'select ';
        String sObjectName = sobjectDaoHelper.findObjectNameFromRecordIdPrefix(recordId);
        if(sObjectName == ''|| sObjectName == null){ return null;}
        List<Schema.DescribeSObjectResult> sObjectResults = Schema.describeSObjects(new List<String>{sObjectName});
        if(sObjectResults == null || sObjectResults.size() == 0) {
            return null;
        }
        Schema.DescribeSObjectResult sObjectResult = sObjectResults.get(0);
        Map<String,SObjectField> maps = sObjectResult.fields.getMap();
        for(Schema.SObjectField objectField : maps.values()) {
            Schema.DescribeFieldResult fieldResult = objectField.getDescribe();
            if(fieldResult.isAccessible()) {
                queryStr += fieldResult.getName() + ',';
            }
        }
        queryStr = queryStr.substring(0,queryStr.length()-1);
        queryStr += ' from ' + sObjectName + ' where Id = :recordId';
        List<sObject> objects = Database.query(queryStr);
        if(objects == null || objects.size() == 0) {
            return null;
        }
        return objects.get(0);
    }
    /*
    可优化方案：循环查找perfixkey，可用map替换，在数据操作过大的时候计算时间会有所提高
    List<Id>限制 50000
    List对象限制 100
     */
    public static String findObjectNameFromRecordIdPrefix(String recordIdOrPrefix){
        String objectName = '';
        try{
            //Get prefix from record ID
            //This assumes that you have passed at least 3 characters
            String myIdPrefix = String.valueOf(recordIdOrPrefix).substring(0,3);

            //Get schema information
            Map<String, Schema.SObjectType> gd =  Schema.getGlobalDescribe();

            //Loop through all the sObject types returned by Schema
            for(Schema.SObjectType stype : gd.values()){
                Schema.DescribeSObjectResult r = stype.getDescribe();
                String prefix = r.getKeyPrefix();

                //Check if the prefix matches with requested prefix
                if(prefix!=null && prefix.equals(myIdPrefix)){
                    objectName = r.getName();
                    break;
                }
            }
        }catch(Exception e){
            System.debug(e);
        }
        return objectName;
    }

    public static Map<String,List<SObject>> getByIds(List<Id> recordIds){
        if(recordIds == null || recordIds.size()>50000){
            return null;
        }
        Map<String,List<Id>> mapIds = new Map<String,List<Id>>();
        for (Id thisid : recordIds) {
            String objectType = findObjectNameFromRecordIdPrefix(thisid);
            if(objectType == '' || objectType == null){ continue; }
            if(!mapIds.containsKey(objectType)){
                mapIds.put(objectType,new List<Id>());
            }
            mapIds.get(objectType).add(thisid);
        }
        if(mapIds.keySet().size() > 100){
            return null;
        }
        Map<String,List<SObject>> returnMap = new Map<String,List<SObject>>();
        List<String> objectNames = new List<String>();
        objectNames.addAll(mapIds.keySet());
        List<Schema.DescribeSObjectResult> sObjectResults = Schema.describeSObjects(objectNames);
        for (DescribeSObjectResult sObjectResult : sObjectResults) {
            String queryStr = 'select ';
            Map<String,SObjectField> maps = sObjectResult.fields.getMap();
            for(Schema.SObjectField objectField : maps.values()) {
                Schema.DescribeFieldResult fieldResult = objectField.getDescribe();
                if(fieldResult.isAccessible()) {
                    queryStr += fieldResult.getName() + ',';
                }
            }
            List<Id> queryIds = mapIds.get(sObjectResult.getName());
            queryStr = queryStr.substring(0,queryStr.length()-1);
            queryStr += ' from ' + sObjectResult.getName() + ' where Id = :queryIds';
            returnMap.put(sObjectResult.getName(),Database.query(queryStr));
        }
        return returnMap;
    }
}