soql
Salesforce SOQL To Get Case Owner In One Hit
Using Salesforce SOQL I can get the Owner\'s Id using the following: SELECT Case.OwnerId FRO开发者_StackOverflowM Case[详细]
2023-04-10 22:13 分类:问答Error while executing query for custom object Work Order
I am executing the query for my custom object created in SFDC. but i am getting the following error: {\'[{\"message\":\"\\nSELECT FS_Account_Name__c from FS_Work_Order__c\\ERROR at Row:1:Column:34\\n[详细]
2023-04-06 01:36 分类:问答Salesforce SOQL relationship query question
I want to get the field userhomepage fr开发者_运维问答om the custom table WebsiteUser via a SOQL query on the Account table. I tried about 10 different queries but i\'m not getting it working...[详细]
2023-04-02 03:00 分类:问答Complex query possible?
I have 3 tables, a parent table and 2 child tables.Lets say Mother_c is the parent. Then Child_c and Pet_c are the 2 child tables that have master-detail relationship pointer to Mother_c.[详细]
2023-03-29 11:29 分类:问答Salesforce API: How to retrieve a Case using a partial Case Id
I\'d like to retrieve a Case record from the Salesforce API. I only have the beginning of the Case Id (don\'t ask why) so I\'ve tried the following query:[详细]
2023-03-22 19:33 分类:问答Strange Salesforce.com SOQL relationship syntax
I\'m looking at an SOQL qu开发者_如何转开发ery that may either be hideously out of date or using some facet of their magical field__r.foreign_table join syntax, the code contains a reference to[详细]
2023-03-18 20:44 分类:问答How do you parse a SOQL AggregateResult column with no value?
Let\'s say you run a SOQL aggregate query that looks like this: select OwnerId, sum(ExpectedRevenue)val from Opportunity GROUP BY ROLLUP(OwnerId)[详细]
2023-03-14 05:08 分类:问答Salesforce SOQL return all partners of single account
I am trying to find all the account that have the same partner. I am new to SOQL and I cannot do a join so I am at a loss. Here is the closest I have gotten:[详细]
2023-03-09 23:06 分类:问答SOQL Type conversion (SalesForce.com)
The problem is that I need to compare two fields of different types in a SOQL query. TextField is a Picklist (so really text) and IntField is a Number(2, 0).Changing the types of these fields is not[详细]
2023-03-04 09:53 分类:问答Update opportunity when lead is inserted via trigger in salesforce
I want to write a bulk trigger (keeping governer l开发者_开发问答imits in mind) such that when a new lead is inserted whose \'x\' field value is same as \'y\' field value of some opporunity, It update[详细]
2023-03-03 11:43 分类:问答