salesforce - 要分配给变量的字段值的 SOQL 结果

Question

如何从此查询中获取单个字段值

String query='Select Title,Question__c,Answer__c,Summary, TestField__c From Know__kav Where Articlenumber = '----';

需要变量中的汇总值？

标签： salesforceapex

Answer 1

我假设摘要是字符串类型。查询是

List<Know__kav> knowkaves = [Select Title,Question__c,Answer__c,Summary, TestField__c From Know__kav Where Articlenumber = '----'];

如果你知道，那么它会返回一行

String Summary = null;
if(knowkaves.size(0 > 0)
{
    Summary = knowkaves[0].Summary;
} 

否则，您有很多摘要，对。然后您可以将其保存在列表中。

List<String> Summaries = new List<String>();
if(knowkaves.size() > 0)
{
    for(Know__kav k : knowkaves){
       Summaries.add(k.summary);
    } 
}