soql Questions
4
I want to do something that could be done in SQL:
select * from table
How can this be achieved using SOQL?
I won't be able to use Apex Code, because I run SOQL queries from a PHP page.
Matriarchate asked 20/6, 2014 at 11:37
3
Solved
I'm trying to query information from salesforce using the simple_salesforce package in python.
The problem is that it's nesting fields that are a part of a parent-child relationship into an order...
Seamstress asked 17/12, 2017 at 22:34
3
Currently we are taking SalesForce data in to CSV file and reading this CSV file in Pandas using read_csv, to_csv methods. Do we have any other way to get data from SalesForce to pandas dataframe.
...
Mention asked 31/8, 2018 at 14:30
3
Solved
I want to know what all the existing values of a field are.
In SQL that would be something like:
SELECT DISTINCT foo
FROM bar
How might I do this with salesforce's SOQL?
Prune asked 2/3, 2018 at 0:12
2
Solved
I am using the Salesforce SOQL snap in a SnapLogic integration between our Salesforce instance and an S3 bucket.
I am trying to use a SOQL query in the Salesforce SOQL snap field "SOQL query*" to...
Noellenoellyn asked 4/2, 2020 at 22:59
3
Solved
I am looking for way to get fields and picklists for a salesforce object. I can do it with a REAT API call using /describe after the object name. But sometimes the returned JSON data is really big ...
Lye asked 7/8, 2021 at 3:22
5
Solved
I am trying to get the Contact/Lead email from the Task object using SOQL (I am creating an interface in PHP to back up messages with a specific subject). Here is my query right now:
SELECT Subjec...
Punic asked 4/2, 2013 at 18:7
7
Solved
How do I make a SOQL query like this?
SELECT id FROM Account WHERE LastActivityDate = 30_DAYS_AGO
This produces an error:
MALFORMED_QUERY:
Account WHERE LastActivityDate = 30_DAYS_AGO
^
Gilstrap asked 8/3, 2011 at 22:9
4
Solved
Is it possible to put comments in SOQL?
The Force.com explorer doesn't support basic operations like undo/redo and I can't find any way to enter comments so experimenting with queries is painful. ...
Kep asked 23/11, 2012 at 11:2
1
Solved
I am trying to run a select in Salesforce as follows:
SELECT [Account].* FROM [Account] WHERE [Account].Id IN ('123456789012345678')
but gives an error: "Unknown error parsing query"
Ho...
Chalcopyrite asked 10/2, 2021 at 1:40
3
Solved
I execute a SOQL request to get all available record ids of the SObject 'ObjectPermissions'.
Then I use the request to GET /services/data/v48.0/sobjects/ObjectPermissions/{id} to fetch all the nec...
Sawyor asked 26/5, 2020 at 21:4
2
Solved
I am using simpleSalesforce library for python to query SalesForce.
I am looking at two different object in SalesForce: Account and Opportunity (parent-child). There is an accountId inside the opp...
Mesmerism asked 8/1, 2020 at 12:4
6
Solved
I was going through the SOQL documentation , but couldn't find query to fetch all the field data of an entity say , Account , like
select * from Account [ SQL syntax ]
Is there a syntax like th...
Fanchon asked 8/1, 2012 at 19:15
1
The trigger below is built to pull the most recent "assigned to" user (or OriginalActorId) from the approval process list, the Approval_started__c field is checked as an initial submission action f...
Indigence asked 14/7, 2018 at 23:10
1
I'm using Simple_Salesforce to grab a chunk of data using the salesforce api. I was wondering if there was anyway to specify a date range when making calls. I keep getting the following error.
que...
Spector asked 21/7, 2017 at 15:23
3
Solved
My final aim is to extract data from Salesforce accounts for general use in R. I spotted the RForcecom package (https://hiratake55.wordpress.com/2013/03/28/rforcecom/) which looks very useful indee...
Staats asked 24/9, 2015 at 10:12
3
We are using Jitterbit to query records from Salesforce, but we are running into an issue. In the query condition statement I am comparing two fields from the Salesforce table. When I go to test th...
Afterpiece asked 25/7, 2014 at 15:45
2
I'm querying ActivityHistory, and it seems that you can only query it as the object of a SUBQUERY against some other object. That's fine - I changed my query to query against the Account object, wi...
Huberthuberto asked 7/6, 2012 at 21:0
4
Solved
Is there a way to fetch a list of all fields in a table in Salesforce? DESCRIBE myTable doesn't work, and SELECT * FROM myTable doesn't work.
Haemolysin asked 25/9, 2012 at 15:23
4
Solved
I am attempting to retrieve the owner of a case, based on a partial match, where we choose the most recent case that matches the partial match.
This is the query I am attempting:
SELECT User.Cust...
Legault asked 17/11, 2011 at 10:4
1
I'm trying to query all Opportunities that have a Price that's not a whole number (no decimals) or if its price is not multiple of 10.
Im trying to find prices like: U$S 34,801.23 - U$S 56,103.69 ...
Tameika asked 28/11, 2012 at 13:41
2
Solved
I have a custom date field for accounts in SalesForce: LastCheckedDate (API Name: LastCheckedDate__c)
I'm trying to use the SalesForce Enterprise API to query accounts based on that field. It retu...
Mckenziemckeon asked 23/5, 2011 at 23:3
3
Solved
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...
Undermine asked 10/12, 2010 at 12:28
2
Solved
Is there a way (without creating a formula datevalue(datetime) field) to aggregate a SOQL query on the date portion of a datetime field? For example, I'd like to do something like:
select dateval...
Undoing asked 8/2, 2012 at 4:8
1
Solved
I am trying to retrieve opportunities created between 01-01-2011 and 06-30-2011.
Select o.CreatedDate, o.Id, o.LastModifiedDate
from Opportunity o
where o.CreatedDate > '1/1/2011' and o.Create...
Madai asked 12/7, 2011 at 7:9
1 Next >
© 2022 - 2024 — McMap. All rights reserved.