2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Query for unsorted order:


Query:

SELECT {!.},Account.Id,(SELECT {!OpportunityLineItems/records} FROM OpportunityLineItems) FROM Opportunity where  Opportunity.AVSFQB__Generate_Object__c= 'Invoice' and AVSFQB__Products_Count__c > 0


Solution  

Step 1:

  • Navigate to products under opportunity.  

  • Click on the dropdown present on the rightmost top corner.



  • Select the Sort Products button.  

  • Drag the products into the order you want and save.


Step 2:

    Make the necessary changes mentioned below in the Advanced query builder section 

    for the respective project after logging into your DBSync account.

 

...