soql
How can i extract attachments from salesforce?
I need to extract开发者_JAVA技巧 attatchments out of salesforce? I need to transfer some notes and attachments into another environmant. I am able to extract the notes but not sure how to go about ext[详细]
2023-03-02 01:29 分类:问答Checking for Blank Date field in Salesforce
How do I check if 开发者_如何转开发a field is Blank in Salesforce using SOQL. ThanksSOQL has support for NULL values, so you should be able to query as you do with regular SQL. For example:[详细]
2023-02-28 12:11 分类:问答Can anyone explain to me this SOQL query?
I have one a SOQL query. Field list can i开发者_Go百科nclude a subquery if the query traverses a relationship. For example:[详细]
2023-02-21 18:07 分类:问答Hierarchial SOQL Query
Does anyone know how to retrieve the hi开发者_StackOverflowerarchical model of a account based on it\'s id?[详细]
2023-02-20 21:28 分类:问答Name query in SQL/SOQL with " ' " as a part of the name
I need to write a soql/sql query which needs to look up for a name that has an apostrophes in it, Like shaquel o\'Neil. The problem is that the where clauses dops the Neil part as that is considered a[详细]
2023-02-20 02:08 分类:问答Salesforce SOQL Query for "Notes And Attachments" of a site
Basically, I need a single SOQL query, executable using the web service API, that will return all NoteAndAttachment items that would normally show in the Notes And Attachments section of an Account pa[详细]
2023-02-09 09:17 分类:问答How do I request a single random row from a force.com database in SOQL?
Total row-count is in the range 10k-100k rows. Can I use RAND() on force.com? Unfortunately although all the rows have a unique numeric identifier, there are many gaps, and I\'d often want to select a[详细]
2023-01-29 16:48 分类:问答I use the SELECT query to download contacts from Salesforce.com. As it is given below and i am getting "MALFORMED_QUERY" exception
I use this select query and i am not getting what\'s the wrong with this. Select Id,Contact.FirstName,Contact.LastName,Contact.Title,Contact.Department,Contact.Birthdate,[详细]
2023-01-28 21:27 分类:问答Salesforce SOQL Queries and Tags
I\'m just getting started with the Salesforce Web Services API and I\'m surprised that there isn\'t an obvious way to do a query for all e.g. Account objects that contain certain tags.[详细]
2023-01-26 15:05 分类:问答Linq to Salesforce "SQL" provider
So, I have this new project. My company uses the SalesForce.com cloud to store information about day-to-day operations. My job is to write a new application that will, among other things, more seamles[详细]
2023-01-23 15:31 分类:问答