Salesforce-Inspector-reloaded
Salesforce-Inspector-reloaded copied to clipboard
[data-export] Enhancing the structure of the subquery results to make it clearer
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 :
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')
at least remove records, totalsize, and done column. I have done so on my side : https://github.com/dufoli/Salesforce-Inspector-Advanced
@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.