A piece of code that is sent to a database to get information back from the database.
2
votes
1answer
82 views
REST API QueryOptions.batchSize
is it possible to set the batch size for queries via REST API? The REST API Query documentation
http://www.salesforce.com/us/developer/docs/api_rest/Content/resources_query.htm
states For more ...
0
votes
2answers
38 views
How do you query an item from a pick list
Any query against a pick list causes the query to fail.
For example the Priority Column has the following options.
Priority
-Critical
-High
-Medium
-Low
The following query results ...
0
votes
1answer
28 views
Query multiple 'where' clauses
How do you write a query that allows for multiple WHERE clauses?
This is a valid query
SELECT CaseNumber, AccountId, IsClosed
FROM Case
WHERE IsClosed = false
This is not a valid query
...
1
vote
2answers
137 views
Is is safer (limitwise) to call Database.getQueryLocator() with SOQL String than Static SOQL?
In my Apex Batch start() method I am returning a Query Locator to get the full 50 million records and not be limited to 50k.
Is there a difference between calling
...Database.getQueryLocator('SELECT ...
1
vote
1answer
46 views
Query count accumulates toward limit while Visualforce page is active?
If you're sitting on a Visualforce page and doing various methods that execute SOQL queries in the controller, does the query count accumulate across all the methods towards the limit until you leave ...
3
votes
1answer
63 views
How to escape < in querystring
I have a batch class with a query string in which I want to limit the query to records last modified before a datetime, but the '<' char seems to need escaping and I can't find any documentation to ...
1
vote
1answer
28 views
How to searching result dependent on query Result
I have a problem. In my scenario, I want to search something in my query result.
list<Account> acc = Database.query(select id, name from account);
And i want to search somethings in this ...
1
vote
0answers
31 views
Single items are all in on XML field when using PHP SOAP API
That's the snippet from it.
$query = "SELECT Id, Body, Status from Idea";
//print_r($query."</br>");
$response = $mySforceConnection->query($query);
// QueryResult ...
2
votes
3answers
185 views
Nested SOQL query?
so, the following query is pretty self explanatory:
SELECT p.Accountid, p.Name, (select name FROM Account where id = p.Accountid) FROM Contact p order by accountid'
is there any way to do this in a ...
0
votes
1answer
80 views
displaying only contacts from account
I need to display only the contacts from the particular account. If I give the contact Id in the get statement I should display only the contacts of the respective account.
Here is my code:
...
1
vote
2answers
101 views
SOQL query for text in the middle of text
Usually in SQL when you do a search on the lines of
... where blah like 'tony%'
You can index blah column and then get a B Tree search.
When you search for
'%tony'
You don't get a B tree ...
