2022
Page History
...
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.
...
The Query for sorted order:
Query:
| Code Block |
|---|
SELECT {!.},Account.Id,(SELECT {!OpportunityLineItems/records} FROM OpportunityLineItems Order By SortOrder) FROM Opportunity where Opportunity.AVSFQB__Generate_Object__c= 'Invoice' and AVSFQB__Products_Count__c > 0 |
...
Overview
Content Tools