pegros / peg_misc Goto Github PK

Is your feature request related to a problem? Please describe.
Using a text custom field to store the id can compromise data integrity if the contentDocument is deleted.
To avoid this, it would be great if we could use the related list relation name instead of a custom field to store the ContentDocumentId

Describe the solution you'd like
We can have parameters on the LWC to store the relatedList relation name and a filter.

Describe alternatives you've considered

Use wire api to retrieve relatedList records

// Related list Data Fetch
    error;
    records;
    @wire(getRelatedListRecords, {
        parentRecordId: "$recordId",
        relatedListId: 'ListEmails',
        fields: ['ListEmail.Id'],
        where: "{ and: [{ Name: { like: \"Bob%\" }}] }"
    }) listInfo({ error, data }) {
        console.log('wiredRelated: wired');
        if (data) {
            this.records = data.records;
            this.error = undefined;
        } else if (error) {
            this.error = error;
            this.records = undefined;
        }
    }

Use apex soql to retrieve the related list record

@AuraEnabled(cacheable=true)
	public static Id getContentDocumentId(Id sobjectId, String relationName, String fieldName, String title){

		String sobjectName = sobjectId.getSobjectType().getDescribe().getName();

		String query = 'SELECT Id, (SELECT ' + fieldName + ' FROM ';
		query+= relationName +  ' WHERE Title LIKE \'' + title + '\') FROM ' + sobjectName + ' WHERE Id=:sobjectId';
		SObject sobj = Database.query(query);
		List<SObject> sobjList = sobj.getSObjects(relationName);
		return objList.get(0).get(fieldName);
	}

Additional context
WARNING:
All the related list are not available through the wire service, for example AttachedContentDocuments on Campaign

Describe the bug
When selecting "ActivityHistories" for a Related List, there following error message when component is displayed by a non administrator user.
"There is an implementation restriction on ActivityHistories. When you query this relationship, security evaluation is implemented for users who don't have administrator permissions, and you must specify a LIMIT with a maximum of 500"_

To Reproduce
Steps to reproduce the behavior:

1. Go to 'Lightning App Builder'
2. Add component "sfpegRelatedListKpisCmp"
3. Select "ActivityHistories" for a "Related list"
4. Save
5. Logon as a non admin user
6. Display the lightning page (for a record)

Expected behavior
The KPI should be displayed without error message.

Screenshots

Desktop (please complete the following information):

• OS: MacOS
• Browser: Chrome

Describe the bug
Master-Detail relations do not appear in "Related list #" while configuring the component in Lightning App builder. Seems that only related lists are displayed.

To Reproduce
Steps to reproduce the behavior:
0. Having Objet A and Object B, with a Master-Detail relation (A is master of B, field A__r on Object B)

1. Go to a, Object A record
2. Launch 'Lightning App Builder'
3. Add "SP PEG Related List KPIs" component
4. Click on "Related List #1" picklist
5. Related relation "A__r" does not appear

Expected behavior
Related relation "A__r" to appear (like other related lists).

Screenshots
n/a

Desktop (please complete the following information):

• OS: MacOs
• Browser Chrome

Is your feature request related to a problem? Please describe.
Currently, KPIs are generated server side and not automatically updated if the related lists change.
The refresh button may be provided but requires user intervention to trigger KPI updates.

Describe the solution you'd like
LWC framework provides the uiRelatedListApi
wire service which could be leveraged to automatically refresh the KPIs if an update occurs on a related list
(e.g. the getRelatedListCount wire adapter).

Describe alternatives you've considered
N/A

Additional context
N/A