Soql Questions

I am running the nested query select id, name, account.name, (select id, orderitemnumber, product2.name from orderitems)

// i have a custom metadata object named boatnames__mdt and i'm using two methods to get a list of picklist values in a

When i run the following soql statement against the salesforce api, it works: select id, typeof parentrecord when workorder then

I faced a strange issue that the app can be executed successfully in mule dev/qa server but throws salesforce:invalid_input in the prd server

How can we sweep through all code in our salesforce or and config in order to make inventory of where specific system admin users are being

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

I have a sql like this in my apex code: public static list<fb_employees__c> getrecords() { return [

I am trying to get just get the permissionsetgroupcomponents for test users in salesforce with this query. select assigneeid,

I am new to salesforce and soql so sorry in advance if the question has already been answered, if yes link it to me. the

The records in the book object are such, that one book can be the parent of other books, and it isn't necessary that each book has a parent

I'm trying to get a jenkins job to run sfdx force:data:soql:query commands in order to migrate configuration data sets between our production org

I need an equivalent soql query to this sql query: sql query: select id, username, (select username from users where id =

Does make sense to check on malicious sql input from an authenticated user?

I am trying to use custom label value in soql query. query is not accepting custom label value. it is expecting number. integer num_days =

I would like to implement a service that takes a lastmodifieddate as input and returns all contentnote records which were modified after the given

Assuming the query looks like this: select id from contact where <some filter here> and i want to add

I try to write something to the database soql in js, but it not works. when i click to the button 'add to cart' then is called handleplaceorder().

i have a custom commission table which has a master detail relationship with contact. i have a list of accountids being passed into

I'm completely new to salesforce and have inherited a report that's not working. please excuse any incorrect terminology, since i'm learning

i created a commission object with field called commission_amount__c, this object has a master detail relationship with contact.

I would like to add results from database to the list. but there is a bug. string str = '\'aoc\',\'bpd\',\'cre\'';

What is wrong at this code in apex? string states = 'california,new york'; list<account> lstacc = [select id, name,

In developer console in soql i try to select product, but that is not possible. select id from product error:

I would like select query from soql, and add to the list of contacts and return it. public class contactsearch { public static

I am trying to run a select in salesforce as follows: select [account].* from [account] where [account].id in

I have a free account in salesforce and learning to program in apex. i was looking back at sample data and have a question regarding how to write

I can select all apex triggers by using select id, name from apextrigger and classes by using

I'm trying to combine 3 separate soql queries into one, but still end up with 3 separate lists for ease of use and readability later.

I am trying to retrieve all the column names from salesforce by soql query that i get via pentaho as well with the following code

I'm a little stuck. i am trying to generate a report that determines whether anyone has made a manual change to certain fields within our

Is there a way i can customize this soql query to include all records after 6am from today? select case__c, level_1__c,

Hi salesforce developers, i am exporting standard contact fields with salesforce soql. i need to import it to other tool

I am using simplesalesforce library for python to query salesforce. i am looking at two different object in salesforce: account and backend

I am trying to fetch records from a scratch org using the tooling api provided by salesforce and user access token. lets say

I am trying to represent environment variables in the salesforce codebase and came across custom metadata types. so based on which sandbox i am

I'm trying to select all records from the opportunity object that are greater than a variable datetime. however, i can't figure out how. this is

Occasionally salesforce object have polymorphic relationships with other salesforce objects. in a polymorphic relationship, the referenced object

Following query returns an error: query: select id, firstname, lastname, ownerid, personemail from account

I'm struggling to get the right soql query in a way that i can search and filter by url addresses, through the api. we have a custom field

I want to access custom field of owner (user) fields where owner is polymorphic relation it can be either user or group. i tried following

I would like to get the application name of a specific sobject. for example: i have a custom object called candidate__c. how to get the

I execute a soql request to get all available record ids of the sobject 'objectpermissions'.

I got a problem.i made a new class for my controller, in this class i do that to connect to salesforce require_once

I am currently using the salesforce rest api to fetch the records from salesforce by passing the query via the query parameter in the get