Questions tagged [nested]
The nested tag has no usage guidance.
88
questions
0
votes
1
answer
47
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&...
- 11
1
vote
1
answer
65
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 ...
- 589
0
votes
1
answer
176
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 ...
- 1
0
votes
1
answer
30
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 ...
- 1
-1
votes
1
answer
121
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, ...
- 97
0
votes
0
answers
49
views
Dom.XmlNode Query Not Working As Expected for Map
Let me preface this by saying I am not a developer. I'm simply trying to reuse existing code that we have in our system to expand its functionality to another object.
That said, I have an Apex class ...
- 11
0
votes
1
answer
236
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 ...
- 5
0
votes
1
answer
56
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 ...
- 3,391
0
votes
2
answers
467
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.
...
1
vote
1
answer
591
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} ...
- 45
0
votes
1
answer
210
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 ...
- 1,539
-3
votes
1
answer
238
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,
( ...
0
votes
1
answer
292
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> ...
0
votes
1
answer
507
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 <&...
0
votes
1
answer
273
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 ...
- 143
2
votes
1
answer
941
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 ' ...
- 61
0
votes
1
answer
453
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 ...
- 223
0
votes
1
answer
124
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 ...
0
votes
1
answer
191
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 ...
- 107
1
vote
1
answer
3k
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 ...
-2
votes
1
answer
756
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>> ...
- 1
0
votes
1
answer
309
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 ...
- 601
0
votes
1
answer
66
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 ...
- 39
2
votes
0
answers
182
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
...
- 21
0
votes
1
answer
356
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 ...
- 815
0
votes
2
answers
28
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(
(...
- 127
0
votes
2
answers
9k
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 ...
- 2,294
3
votes
2
answers
228
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....
- 140
0
votes
0
answers
41
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 ...
- 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 ...
- 1
0
votes
2
answers
939
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 ...
- 25
0
votes
1
answer
3k
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 ...
- 19
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?
// ...
- 815
1
vote
1
answer
694
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 ...
- 101
0
votes
1
answer
478
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 ...
- 447
0
votes
1
answer
408
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="...
- 3
1
vote
1
answer
669
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 ...
- 13
3
votes
1
answer
767
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. ...
- 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/"), ...
- 1,296
0
votes
1
answer
402
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, ...
- 2,294
0
votes
1
answer
331
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 ...
- 15
2
votes
1
answer
169
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 ...
- 137
1
vote
1
answer
548
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) ...
- 425
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 ...
- 37
0
votes
1
answer
36
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 ...
- 2,294
-4
votes
1
answer
157
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 ...
-1
votes
1
answer
749
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 ...
0
votes
1
answer
360
views
Nested AMPScript in Email HTML
I'm trying to make the following code work:
If you can't see the images in the email below %%=CONCAT(“<a href="%%view_email_url%%">click here</a>”)=%%…
The Concat function is to stop the ...
0
votes
1
answer
2k
views
How to parse nested objects in JSON response
Im trying to parse the below JSON response:
{
"preferredLanguage":"en",
"preferredLocale":"en_GB",
"languages":{
"en":{
"langCountry":"en-bn",
...
- 666
1
vote
1
answer
17
views
Avoid specifying an outer class when using its nested class outside
How can I avoid specifying an outer class when using its nested class outside the outer?
For example, I have the following:
public with sharing class ClassA {
public class NestedInA {
}
}
...
- 113