"SOQL"의 두 판 사이의 차이
둘러보기로 가기
검색하러 가기
잔글 (→Relationship) |
잔글 |
||
152번째 줄: | 152번째 줄: | ||
*Database.rollback(sp); | *Database.rollback(sp); | ||
− | ==참고 문헌== | + | == 참고 문헌 == |
− | |||
− | |||
− | |||
− | [[Category:Salesforce]] | + | *[http://www.salesforce.com/us/developer/docs/api/index_Left.htm#CSHID=sforce_api_calls_soql.htm%7CStartTopic=Content%2Fsforce_api_calls_soql.htm%7CSkinName=webhelp Salesforce Object Query Language (SOQL)] |
− | [[Category:Cloud]] | + | *[http://www.salesforce.com/us/developer/docs/api/index_Left.htm#CSHID=sforce_api_calls_soql_select_agg_functions.htm%7CStartTopic=Content%2Fsforce_api_calls_soql_select_agg_functions.htm%7CSkinName=webhelp Aggregate Functions] |
+ | *[http://www.salesforce.com/us/developer/docs/api/index_Left.htm#CSHID=sforce_api_calls_sosl.htm%7CStartTopic=Content%2Fsforce_api_calls_sosl.htm%7CSkinName=webhelp Salesforce Object Search Language (SOSL)] | ||
+ | [[Category:Salesforce|Category:Salesforce]]<br/>[[Category:Cloud|Category:Cloud]] | ||
+ | |||
+ | == SuiteCRM 지원 업체 == | ||
+ | |||
+ | <span style="color: rgb(102, 102, 102); font-family: Arial, Helvetica, Verdana, sans-serif; font-size: 15px;">아래 담당자에게 연락하여 주시면, 빠르고 친절하게 전문적인 답변을 드리겠습니다.</span> | ||
+ | |||
+ | {| style="box-sizing: border-box; margin: 0px 0px 20px; padding: 0px; border: 0px rgb(225, 225, 225); font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; font-family: Arial, Helvetica, Verdana, sans-serif; vertical-align: baseline; border-collapse: collapse; border-spacing: 0px; width: 98%; background: rgb(252, 252, 252); color: rgb(102, 102, 102);" | ||
+ | |- style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px rgb(225, 225, 225); font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;" | ||
+ | | style="box-sizing: border-box; margin: 0px; padding: 9px 12px; border: 1px solid rgb(225, 225, 225); font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; text-align: center;" | 영업 문의 | ||
+ | | style="box-sizing: border-box; margin: 0px; padding: 9px 12px; border-top: 1px solid rgb(225, 225, 225); border-right: 1px solid rgb(225, 225, 225); border-bottom: 1px solid rgb(225, 225, 225); border-left: none rgb(225, 225, 225); border-image: initial; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; text-align: center;" | sales@obcon.biz | ||
+ | | style="box-sizing: border-box; margin: 0px; padding: 9px 12px; border-top: 1px solid rgb(225, 225, 225); border-right: 1px solid rgb(225, 225, 225); border-bottom: 1px solid rgb(225, 225, 225); border-left: none rgb(225, 225, 225); border-image: initial; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; text-align: center;" | 010-4667-1106 | ||
+ | | style="box-sizing: border-box; margin: 0px; padding: 9px 12px; border-top: 1px solid rgb(225, 225, 225); border-right: 1px solid rgb(225, 225, 225); border-bottom: 1px solid rgb(225, 225, 225); border-left: none rgb(225, 225, 225); border-image: initial; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline;" | 영업 대표 | ||
+ | |- style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px rgb(225, 225, 225); font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; background-color: rgb(255, 255, 255); color: rgb(145, 145, 145);" | ||
+ | | style="box-sizing: border-box; margin: 0px; padding: 9px 12px; border-top: none rgb(225, 225, 225); border-right: 1px solid rgb(225, 225, 225); border-bottom: 1px solid rgb(225, 225, 225); border-left: 1px solid rgb(225, 225, 225); border-image: initial; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; text-align: center;" | 기술 문의 | ||
+ | | style="box-sizing: border-box; margin: 0px; padding: 9px 12px; border-top: none rgb(225, 225, 225); border-right: 1px solid rgb(225, 225, 225); border-bottom: 1px solid rgb(225, 225, 225); border-left: none rgb(225, 225, 225); border-image: initial; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; text-align: center;" | tech@obcon.biz | ||
+ | | style="box-sizing: border-box; margin: 0px; padding: 9px 12px; border-top: none rgb(225, 225, 225); border-right: 1px solid rgb(225, 225, 225); border-bottom: 1px solid rgb(225, 225, 225); border-left: none rgb(225, 225, 225); border-image: initial; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; text-align: center;" | | ||
+ | | style="box-sizing: border-box; margin: 0px; padding: 9px 12px; border-top: none rgb(225, 225, 225); border-right: 1px solid rgb(225, 225, 225); border-bottom: 1px solid rgb(225, 225, 225); border-left: none rgb(225, 225, 225); border-image: initial; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline;" | 구축/컨설팅 담당 | ||
+ | |- style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px rgb(225, 225, 225); font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial;" | ||
+ | | style="box-sizing: border-box; margin: 0px; padding: 9px 12px; border-top: none rgb(225, 225, 225); border-right: 1px solid rgb(225, 225, 225); border-bottom: 1px solid rgb(225, 225, 225); border-left: 1px solid rgb(225, 225, 225); border-image: initial; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; text-align: center;" | 고객 지원 | ||
+ | | style="box-sizing: border-box; margin: 0px; padding: 9px 12px; border-top: none rgb(225, 225, 225); border-right: 1px solid rgb(225, 225, 225); border-bottom: 1px solid rgb(225, 225, 225); border-left: none rgb(225, 225, 225); border-image: initial; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; text-align: center;" | support@obcon.biz | ||
+ | | style="box-sizing: border-box; margin: 0px; padding: 9px 12px; border-top: none rgb(225, 225, 225); border-right: 1px solid rgb(225, 225, 225); border-bottom: 1px solid rgb(225, 225, 225); border-left: none rgb(225, 225, 225); border-image: initial; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; text-align: center;" | | ||
+ | | style="box-sizing: border-box; margin: 0px; padding: 9px 12px; border-top: none rgb(225, 225, 225); border-right: 1px solid rgb(225, 225, 225); border-bottom: 1px solid rgb(225, 225, 225); border-left: none rgb(225, 225, 225); border-image: initial; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline;" | 고객 지원 담당<br/><br/> | ||
+ | |} |
2018년 1월 31일 (수) 13:10 판
Force.com의 SOQL, SOSL, DML을 정리 합니다.
목차
SOQL
Salesforce Object Query Language (SOQL)
SOQL 문법
Savepoint sp = Database.setSavepoint(); SELECT fieldList FROM objectType WHERE conditionExpression WITH [DATA CATEGORY] filteringExpression] GROUP BY fieldGroupByList] | GROUP BY ROLLUP|CUBE (fieldSubtotalGroupByList) HAVING havingConditionExpression ORDER BY fieldOrderByList ASC | DESC ? NULLS FIRST | LAST ? LIMIT ? List<Account> aa = [SELECT id, name, toLabel(name) FROM Account WHERE name = 'Acme' AND LoginTime < 2010-09-21T22:16:30.000Z GROUP BY id, name LIMIT 10 FOR UPDATE]; Database.rollback(sp);
상위/하위 개체 읽기
String name = [select id, name from account where name = 'Singha' limit 1].name SELECT Name, customfield__c, (SELECT OldValue, NewValue FROM foo__history) FROM foo__c //--- child-to-parent SELECT Contact.FirstName, Contact.Account.Name from Contact SELECT Id, FirstName__c, Mother_of_Child__r.FirstName__c FROM Daughter__c WHERE Mother_of_Child__r.LastName__c LIKE 'C%' //--- parent-to-child SELECT Account.Name, (SELECT Contact.FirstName, Contact.LastName FROM Account.Contacts) FROM Account SELECT LastName__c, (SELECT LastName__c FROM Daughters__r) FROM Mother__c
Contact item 또는 List<Contact> data = [SELECT Id, FirstName, LastName, Account.Id, Account.Name, Account.Type, //--- Parent, __r (SELECT Id, Subject, Description //--- Child FROM Cases) FROM Contact WHERE 조건 //--- :var, AND, OR, NOT, LIKE ‘가%’, IN ORDER BY FirstName ASC[DESC] LIMIT 1];
- data[0].Id, data[0].FirstName, data[0].LastName
- data[0].Account.Id, data[0].Account.Name, data[0].Account.Type
- List<Case> caseData = data[0].Cases;
- caseData[0].Subject === data[0].Cases[0].Subject
Relationship
Master-detail (1:n) |
|
Many-to-many (m:n) |
|
Lookup (1:n) | |
Hierarchical |
|
Aggregate
Integer i = [select count() from contact] AggregateResult[] agrData = � [SELECT CampaignId, AVG(Amount) avg� FROM Opportunity� GROUP BY CampaignId]; SUM(~), AVG(~), MAX(~), MIN(~), COUNT_DISTINCT(~), COUNT() Object camp = agrData[0].get('CampaignId'); Object avg = agrData[0].get('avg');
- Aggregate Functions
- count(), count(~) : 레코드의 갯수를 Integer로 반환
- SUM(~)
- AVG(~) : 평균
AggregateResult[] result = [SELECT AVG(Amount) aver FROM Opportunity]; Object avgAmount = result[0].get('aver'); AggregateResult[] result = [SELECT CampaignId, AVG(Amount) FROM Opportunity GROUP BY CampaignId];
- MAX(~), MIN(~)
- COUNT_DISTINCT()
SOSL
Salesforce Object Search Language (SOSL)
- 제약 사항
- Apex Class에서만 사용할 수 있음
SOSL 문법
FIND 'map*' IN ALL FIELDS RETURNING Account (id, name), Contact, Opportunity, Lead WITH ~ = ~ LIMIT 5
SOSL 사례
- Account, Contact, Opportunity, Lead 개체의 모든 필드에서 값이 map로 시작하는 필드를 가지는 모든 개체를 반환
List<List<SObject>> searchList = [FIND 'map*' IN ALL FIELDS RETURNING Account (id, name), Contact, Opportunity, Lead]; Account[] accounts = ((List<Account>)searchList[0]); Contact[] contacts = ((List<Contact>)searchList[1]); Opportunity[] opportunities = ((List<Opportunity>)searchList[2]); Lead[] leads = ((List<Lead>)searchList[3]); List<List<SObject>> dataSet = [FIND 'map*' IN ALL FIELDS RETURNING Account (id, name WHERE ~ LIMIT ~), Contact, Opportunity WITH ~ = ~ LIMIT 5]; List<Account> accounts = (List<Account>)dataSet[0]; List<Contact> contacts = (List<Contact>)dataSet[1];
DML
DML : Data Manipulation Language
- Database.query(~) == [~]
- insert, update, upsert, delete,
(merge, undelete
- Database.SaveResult[] = Database.insert(~, true), update, upsert, delete
- Savepoint sp = Database.setSavepoint();
- Database.rollback(sp);
참고 문헌
- Salesforce Object Query Language (SOQL)
- Aggregate Functions
- Salesforce Object Search Language (SOSL)
SuiteCRM 지원 업체
아래 담당자에게 연락하여 주시면, 빠르고 친절하게 전문적인 답변을 드리겠습니다.
영업 문의 | sales@obcon.biz | 010-4667-1106 | 영업 대표 |
기술 문의 | tech@obcon.biz | 구축/컨설팅 담당 | |
고객 지원 | support@obcon.biz | 고객 지원 담당 |