Skip to main content
New
Stack Overflow Jobs powered by Indeed: A job site that puts thousands of tech jobs at your fingertips (U.S. only). Search jobs

Questions tagged [nested]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
79 views

Nested query doesn't work

EDIT: I am using simple-salesforce with the REST API to make requests. I'm trying to get for each Case all the EmailMessages, and for each EmailMessage, all its ContentDocumentLinks (from which I can ...
Labo's user avatar
  • 111
0 votes
1 answer
51 views

Nested AND/OR Statement in a Validation Rule on the Case Object

I've tried following other resources, but decided to share this one to see if anyone could help me get the syntax correct: I need to display an Error message on the Case Record when someone tries to ...
Patrick Fuller's user avatar
0 votes
0 answers
33 views

In GTL datasource can I have conditional content appear based on the first instance only?

I'm using Amspscript and GTL datasource to extract information from a field in a data extension called: cancelled. This field has multiple items in there and within cancelled there is another field ...
T01's user avatar
  • 9
-1 votes
1 answer
292 views

Salesforce LWC nested for each loops with if condition

I am trying to implement a listbox in LWC. The list box is showing values from a picklist in Account object. On click the value of the selected item is adding to an array. But on the UI it is not ...
Hasan Zubairi's user avatar
0 votes
1 answer
59 views

Extract Particular value from the result list and store them in another list

Hi I have a list type of List which is returned from the invocable action. List<Invocable.Action.Result> results = action.invoke(); I am getting the data as below in the form of result. (Result&...
Shekher's user avatar
  • 19
1 vote
1 answer
147 views

Nested SOQL is working but nested joins are not working

With Summer '23 release we can query upto 5 levels down in Parent-Child Relationships. See this Salesforce release notes My sandbox is on Summer '23 release and I was able to test my custom objects ...
Json Bourne's user avatar
0 votes
1 answer
581 views

Multiple IF AND ELSE statements

I am trying to create a formula with several specific requirements to calculate call contact rates. The first IF section of my formula works on its own, however adding the additional IF statements ...
Mike's user avatar
  • 1
0 votes
1 answer
34 views

Nested Query for Attachment

I need to retieve the Manager Parent Task id in Attachment query. Can we query the grantParent Id in the same query , below query is giving me id of employee and manger but I need task id also which ...
User 123's user avatar
-1 votes
1 answer
181 views

Nested Query for LWC [duplicate]

public static List<WrapperToLWC> getList(String namee){ Id cleanId = (Id) namee; List<SObject> membersList = new List<SObject>(); membersList = [SELECT Id, SObject1, Rol, ...
TechGuy's user avatar
  • 97
0 votes
1 answer
489 views

Iterating over nested template for:each lwc, use key from outer for in inner template for

I am iterating over a wrapperList to display list of fields in lightning-record-edit-form. This wrapperlist is a list of questions. Each question has files attached which i am querying in a separate ...
swat's user avatar
  • 5
0 votes
1 answer
113 views

Nested Query Dot Notation or Name Casting

Quick question - I am unable to find any documentation on the dot notation when using nested queries. I assume they are name casting but I was hoping someone could point me in the direct of actual ...
Olivia's user avatar
  • 3,461
0 votes
2 answers
711 views

Create Master-Detail Object via Rest-API

I have created a custom object which is connected to the Account Object via Master-Detail. The custom object stores reviews for the Accounts. The reviews are given on a website and saved via REST API. ...
Fewture's user avatar
1 vote
1 answer
865 views

Invalid key error, when clicking on a combobox from a nested component

I have an lwc that displays content differently based on data type, filterField.html (simplification): <template> <div if:true={isText}> <lightning-input value={_value} ...
Arhael's user avatar
  • 45
0 votes
1 answer
256 views

External Services - Nested object in response appears to be blank in Flow but is populated in Postman

There is already a question asking the same, however it is still not responded. I am using an external service and in the response, I am supposed to receive a nested object as per the following ...
Gabriel Serrano Salas's user avatar
-3 votes
1 answer
310 views

SOQL nested query not working

I want to save the following query but it given me errors: Query: Set<Id> extUserIdSet = new Set<Id>(); List<Object1> obj1= [ SELECT Id, ExternalId, Name, Address, ( ...
Manto Kebab's user avatar
0 votes
1 answer
545 views

Write SOQL nested query

I have two objects. Object2 has lookup relationship to Object1. I want to write a SOQL query to fetch some data of Object1 where the territory field of Object2 is equal to UK. Set<Id> ...
Manto Kebab's user avatar
0 votes
1 answer
548 views

Error: Incorrect number of parameters for function 'IF()'. Expected 3, received 2

The title says it all. I know I am missing my 3rd parameter per the error, but I can't determine where. IF ( Not_Final_Destination__c = TRUE, IF (AND(SCMC__Customer_Account__r.ShippingCountry <&...
Scott Hendrix's user avatar
0 votes
1 answer
334 views

How could I avoid nested for each in a HTML (LWC component)?

I'm starting to create a modal like in this picture, but I only got it doing nested for each (line 42 and 43 of the .html) for the table. That's not good practice, right? So how could avoid it? I ...
Cline's user avatar
  • 143
2 votes
1 answer
2k views

Dynamic nested soql - how to loop through subquery?

Struggling with building a nested for-loop to parse through the following scenario : String table = 'Account'; String subtable = 'Contacts'; String soql = 'Select id, (id from ' + subtable + ') from ' ...
Pete's user avatar
  • 81
0 votes
1 answer
525 views

SOQL nested query on object related to parent?

I have a query on CampaignMember and I would like to get some Tasks for the Contact or Account that is associated with the CampaignMember record. I'm guessing I can't do that since the Tasks ...
kd7iwp's user avatar
  • 233
0 votes
1 answer
194 views

How to use maps to get list of grand child records for a parent object

I have a parent object (Account), child object(Contract) and a grand child object(contract exceptions). Contract exceptions has master detail relationship with contract. My requirement is to fetch ...
Sudhir Balijepalli's user avatar
0 votes
1 answer
207 views

System.NullPointerException: Attempt to de-reference a null object on a Collection

I have a nested Collection like this : public class EntityReportsSearch { public Data_Contract.ArrayOfEntityReports_EntitySearchCriteria Entities; public String ReferenceID; } public ...
user3444999's user avatar
1 vote
1 answer
5k views

Nested tables with different headers and data LWC for:each

I have a requirement to create a component that is essentially 2 tables, parent/child. The parent table is Subscriptions, and the child table is Subscription Products that are related to that ...
Carryonplease's user avatar
-2 votes
1 answer
949 views

HOW TO Avoid three or more nested LOOPS [duplicate]

for(String objectName : jsonMap.keySet()){ // List<map<String,String>> listObjects=jsonMap.get(objectName); List<Map <String, String>> ...
ABC's user avatar
  • 1
0 votes
1 answer
481 views

Create component used to include other components or static resources

In a custom lightning aura component app, I have a component where I want to include a static resource. I have successfully created the static resource (a JavaScript file) and included it in the ...
jbyrd's user avatar
  • 641
0 votes
1 answer
72 views

Formula field with 4 IF statements and 2 False statements

I need to make a formula field work, unfortunately, I cannot figure out how to place statements so that I can include 2 False options (False options have been bolded) The logic behind the formula: If ...
kikalz's user avatar
  • 39
2 votes
0 answers
195 views

LWC Component cannot see Nested query

I'm having an issue showing nested apex query inside LWC result. return [SELECT Id, Name, Last_Maintenance_Date__c, Location__c,(SELECT Id, Date__c FROM Maintenances__r) FROM Car__c ...
tihi's user avatar
  • 21
0 votes
1 answer
478 views

SOQL UserName and UserRole

Line: 5, Column: 1 System.SObjectException: SObject row was retrieved via SOQL without querying the requested field: User.UserRole In the debug statement if I add UserRole.DeveloperName i get the ...
GroundToCloud's user avatar
0 votes
2 answers
37 views

Advance formula field nested condition not working

I want a formula like this: IF ( (Field1 = 'Value1' AND Field2 = 'Value2') OR ( NOT (ISBLANK (Field3))) ), "Output1", "Output2") This is my actual formula: IF( (...
Hari Ha's user avatar
  • 127
0 votes
2 answers
13k views

Json Unexpected character (':' (code 58)): was expecting comma to separate ARRAY entries at [line:1, column:83]

I have a Json string to do some testing on nested Json but get te error:Unexpected character (':' (code 58)): was expecting comma to separate ARRAY entries at [line:1, column:83] I can seem to figure ...
Thomas's user avatar
  • 2,298
3 votes
2 answers
321 views

How to deserialize object with nested query in a simply way

I have a JSON of object with nested query and I do not want to use JSON.deserializeUntyped and map values manually. Is there any easy way to do it? For example: Sobject object = (Sobject) JSON....
Ferhat Özsavran's user avatar
0 votes
0 answers
43 views

Create map for unrelated objects

We have a object named Quote which is parent object in Lookup relationships with Quote Line object and Internal Calculation object. On Quote Line object we have From Currency, To Currency and ...
Rahul's user avatar
  • 19
0 votes
1 answer
2k views

Nested IF AND formula: Error when encoding row-level formula: Syntax error. Extra ','

I'm trying to create a row-level formula to calculate the following: I have a custom object called 'Car Transaction', with the following fields: 'Sign Up Fee' and 'Success Fee' Here is what I want the ...
wycliff's user avatar
0 votes
2 answers
1k views

Help with SOQL Query to fetch all records with a combination of where and Limit

I am new to Salesforce . I'm faciing an issue to form a query to use it in a Apex class . Example Query : /*Set with all the LookupField__c lookup field id's */ Set<Id> LookupField ...
Tarun teja's user avatar
0 votes
1 answer
4k views

Inner SOQL Queries

I would like to know if there are any limitations to inner(nested) SOQL Queries. The reason i am asking is that lately when i get a soql 101 error it leads me to queries that have multiple inner ...
JM Luttrell's user avatar
0 votes
0 answers
31 views

Compare two Set <String> and return list<String> that does'nt exist in Set2 [duplicate]

I am getting the desired result, but I want to avoid the nested FOR in my code. However my attempt failed. This is the best I could do. Can someone please guide me how I can avoid the nested FOR? // ...
GroundToCloud's user avatar
1 vote
1 answer
798 views

VF page render as pdf not working properly

I am trying to display some HTML(stored as HTML text in rich text field) in to vf page via output text tag. This HTML text has unordered list inside an unordered list(like a nested unordered list). It ...
Sisir's user avatar
  • 111
0 votes
1 answer
523 views

Share CSS Styles Among Lightning Web Components (Nested CSS) - not working

I'm trying to create a consistent look and feel for Lightning web components by using a common CSS module. For this, I have followed the solutions given in the summer 20 release notes and the LWC ...
user43598's user avatar
  • 487
0 votes
1 answer
454 views

formula field with lots of nested Ifs and Ands - confusion

having a little trouble following the necessary logic to get this formula field syntax correct. i need to accomplish the following: If source_system__c="Adobe" AND If type__c="...
nueve's user avatar
  • 3
1 vote
1 answer
764 views

SOQL API query with custom objects and relationships. Returning a flat result - Not nested

I am working with a third party software solution that consumes Salesforce API data via WDSL. I can run queries on any of the tables to return the result object - this works fine. I need to get ...
Ali Brown's user avatar
3 votes
1 answer
802 views

How can i create a Map for unrelated objects?

Background We create shadow records for Contacts that are Inactive (record type) and I am working on building a UI for the user to Activate one or more shadow records associated to that Account. ...
SunnyG's user avatar
  • 421
0 votes
3 answers
3k views

What happens with an IF formula with multiple TRUE conditions?

I have a multi nested IF statement like below - what happens if a field meets more than one condition - is there a rule to determine which value gets returned? IF(CONTAINS( Custom__Name__c , "/cs/"), ...
jaw999's user avatar
  • 1,315
0 votes
1 answer
546 views

Hot to get value of relationship dynamic Soql

I am using the following string in a dynamic soql: SELECT id, name, orderdate__c, status__c, sold_To_Customer__r.id, sold_To_Customer__r.name, sold_To_Customer__r.customerreference__c, ...
Thomas's user avatar
  • 2,298
0 votes
1 answer
352 views

Mastering Maps: Help needed for bulkifying a simple Opp Trigger Handler

As a beginner I'm currently learning how to bulkify my Apex Classes. I wrote an Apex Class with the following logic: When an Opportunity's stage is changed to Closed Won ... 1. Create an Asset for ...
Daniel's user avatar
  • 15
2 votes
1 answer
187 views

Only the first IF condition works, and the rest doesn't when nested in Process Builder formula

GOAL: I'm trying to create this criteria in Process Builder where I can detect phone number like (000) 000-0000, 000-000-0000 and 000.000.0000 and turn them into +1 0000000000 format. I tried to ...
il0v3d0g's user avatar
  • 137
1 vote
1 answer
621 views

SFDX FORCE:DATA:TREE:EXPORT Nested __r Relationship Query

I am attempting to export data using the FORCE:DATA:TREE:EXPORT CLI command, using a nested query like the following (for use in our Scratch-Orgs): SELECT ...,(SELECT ... FROM My_Custom_Object__r) ...
Mr. B's user avatar
  • 435
0 votes
2 answers
2k views

How to save record from a different object using nested recordEditForm

I have managed to get fields from two different objects to display in one lighting component but I am having a few problems off the back of this. When saving it will only save the main record and ...
JackDower's user avatar
0 votes
1 answer
38 views

How to nest a map to get a related structure

I want to display a relation Account>property__c>Booking__c>Order>OrderItem in a visualforce page. I want to nest the objects to represent these as parent>grandchildren> grand grandchildren>etc. I am ...
Thomas's user avatar
  • 2,298
-4 votes
1 answer
161 views

Trigger not creating a new record [closed]

If case status got change for certain record type, new support record should get created. I configured status and record type combination in custom setting I am trying to avoid nested loop in my ...
Rajni Bhagat's user avatar
-1 votes
1 answer
806 views

How to avoid nested loop in the trigger [closed]

We have a trigger if case status got change new support record should get created. but in my case it is creating more than one record, I am thinking it might be because of a nested loop can someone ...
Rajni Bhagat's user avatar