Relationship Queries in SOQL | Parent to Child | Learn Salesforce Development

แชร์
ฝัง
  • เผยแพร่เมื่อ 11 ธ.ค. 2024

ความคิดเห็น • 13

  • @akshayphadnis
    @akshayphadnis 2 ปีที่แล้ว

    And how to fetch data from the inner query? Maybe I want to store inner query data into some variable

    • @megheshshenoy
      @megheshshenoy 2 ปีที่แล้ว

      List Med = new List();
      Med = [SELECT id, (SELECT Review_Submission_Date__c,
      Comments__c, Media__c, Member__c, Rating__c FROM Reviews__r) FROM Media__c
      WHERE id =:recId LIMIT 50];
      List Rev = new List();
      //This record will now have the correct type to be added to the list
      Rev.add(Med[0].Reviews__r[0]);

  • @karanammaheedhar3595
    @karanammaheedhar3595 3 ปีที่แล้ว

    Is their any possible way to Get child fields from parent obj using single select keyword in SOQL

    • @megheshshenoy
      @megheshshenoy 2 ปีที่แล้ว

      Select id, (Select Name__c from childs__r) from parent__c

  • @DharmendraKumar-wp4ur
    @DharmendraKumar-wp4ur 3 ปีที่แล้ว

    Suppose we have two custom accounts Object Parent and Child, and we want to fetch name of child account from parent account..what is the query for that ??

    • @shubhammali8
      @shubhammali8 3 ปีที่แล้ว

      select id,(select name__c from childs__r) from parent__C;
      let me know if this is working.

  • @KumarNaveennaveen
    @KumarNaveennaveen 3 ปีที่แล้ว

    If have created a report and report type contains Accounts, Custom object lets say B.
    I am filtering in report using Account record type and record type from B.
    COULD YOU PLEASE TELL ME HOW CAN WE WRITE A SOQL QUERY FOR THIS?? PLEASE

    • @megheshshenoy
      @megheshshenoy 2 ปีที่แล้ว

      SELECT Id,(SELECT Id from ChildrelationshipName WHERE RecordTypeId='recordTypeId') FROM Account where RecordTypeId=''recordTypId'

  • @shivanibabbar8232
    @shivanibabbar8232 2 ปีที่แล้ว +2

    so many ads in your videos , after every 2-3 mins there are ads
    it becomes irritating sometimes pls remove it
    only add it in the beginning and end

  • @masulusravani8356
    @masulusravani8356 3 ปีที่แล้ว +1

    🙌🙌

  • @ramireddygarivinaykumarred7261
    @ramireddygarivinaykumarred7261 3 ปีที่แล้ว +3

    Bro We want interview trigger scenarios
    Please do it bro