Salesforce-Inspector-reloaded icon indicating copy to clipboard operation
Salesforce-Inspector-reloaded copied to clipboard

[data-export] Enhancing the structure of the subquery results to make it clearer

Open ashish-rs opened this issue 1 year ago • 2 comments

Currently, when we write an SOQL query with subquery, the result looks like this:

_ Id SBQQ__LineItemCount__c SBQQ__LineItems__r SBQQ__LineItems__r.totalSize SBQQ__LineItems__r.done SBQQ__LineItems__r.records SBQQ__LineItems__r.records.0 SBQQ__LineItems__r.records.0.Id SBQQ__LineItems__r.records.0.SBQQ__Quantity__c SBQQ__LineItems__r.records.0.SBQQ__CustomerTotal__c SBQQ__LineItems__r.records.1 SBQQ__LineItems__r.records.1.Id SBQQ__LineItems__r.records.1.SBQQ__Quantity__c SBQQ__LineItems__r.records.1.SBQQ__CustomerTotal__c SBQQ__LineItems__r.records.2 SBQQ__LineItems__r.records.2.Id SBQQ__LineItems__r.records.2.SBQQ__Quantity__c SBQQ__LineItems__r.records.2.SBQQ__CustomerTotal__c
[SBQQ__Quote__c] a0x8e000000ke8hAAA 0                                
[SBQQ__Quote__c] a0x8e000000vujNAAQ 0                                
[SBQQ__Quote__c] a0x8e00000174itAAA 4 [object Object] 4 TRUE [object Object],[object Object],[object Object] [SBQQ__QuoteLine__c] a0t8e000001UNV8AAO 1 0 [SBQQ__QuoteLine__c] a0t8e000001UNVBAA4 1 0 [SBQQ__QuoteLine__c] a0t8e000001UNVAAA4 1 0

Describe the solution you'd like When we run similar query in workbench, the data in inner query is displayed like this : image

Can you please check if implementing similar layout would be possible in Salesforce Inspector Reloaded, which would makes the results easier to read and understand? Thanks.

Here's the query for reference: select id, SBQQ__LineItemCount__c, (SELECT Id, SBQQ__Quantity__c, SBQQ__CustomerTotal__c from SBQQ__LineItems__r) FROM SBQQ__Quote__c WHERE Id IN ('a0x8e00000174itAAA', 'a0x8e000000ke8hAAA', 'a0x8e000000vujNAAQ')

ashish-rs avatar Feb 12 '24 08:02 ashish-rs

at least remove records, totalsize, and done column. I have done so on my side : https://github.com/dufoli/Salesforce-Inspector-Advanced

dufoli avatar Mar 19 '24 13:03 dufoli

@dufoli I agree that I haven't found any use for the "records" and "done" columns. But totalsize is useful, I use it a lot for counting the number of child records.

hvilminko avatar Sep 17 '24 12:09 hvilminko