Show a list of QUEUES where a selected User doesn’t belong to, excluding QUEUES where other users belong to

apexlightning-duallistboxqueueuser

I'm working on a Dual Picklist where in left column I need to show a list of Queues where a selected user belongs to and in the right column a list of Every Queue that exist on the org besides the Queues that belong to the selected user.

Queues from the ORG	Arrows	Queues from User
All queues from org excluding the Queues from selected User	add> & OR <remove	Queues from selected User

However I'm struggling to show the Queues from the Org where the User doesn't belong to, with the query: select id, groupId,group.Name, group.Type from GroupMember where userorGroupId !='00509000007qMJHAA2' and group.type='queue'I get in return the queues where this person belongs to, but because that Queue belongs to other users too.
To show the Queues where the user belongs to I am using the following queue in Apex class

@AuraEnabled (cacheable=true)
public static List<GroupMember>getGroups(string userId, string type){
    List<GroupMember> groupList = new List<GroupMember>();
    if(userId !=''){
        String userIdModal= userId;
        groupList=[select id, groupId,group.Name from GroupMember where userorGroupId !=:userIdModal and group.type=:type];
        
        return groupList;
    }
    return groupList;
}

and my JS looks like this

@track showModal = false;
@track dataShow;
@api selectedUser;


@wire (getGroups,{userId:'$selectedUser', type:'queue'})
    retrieveGroups ({error, data}) {
       if (data) {
           this.groupList=data;
           
        }else if(error){
            console.log('Sorry,nothing was found');
        }
    }

//use @api because we are accesing info from a parent component
    @api show(){
        this.showModal=true;
    
        console.log(allData);
    }

    handleDialogClose(){
        this.showModal=false
    }

Thanks

Best Answer

This can quickly get more difficult depending on your need. The reason is explained well with this question (Get all queue users), but it comes down to the fact that there's other ways users may be part of a queue without them explicitly being a GroupMember:

User Role
User Role & Subordinates
Other Public Groups (ex. All Internal Users)

I'm going to assume you're only leveraging/assigning users directly into queues for your use case. In that case, the problem with your query is that you looking at GroupMember which pulls all members across all queues.

You'll want to take a different approach for your SOQL query. What you attempted is just going to give you every GroupMember that isn't your user which would be any Group that has "other" members - which could be queues they're apart of or not.

Get Queues the User is not explicitly assigned to (as a GroupMember):

SELECT Id,Name 
FROM Group 
WHERE Type = 'Queue' AND ID NOT IN 
(SELECT GroupId FROM GroupMember WHERE UserOrGroupId =: userIdModal)

Get Queues the User is explicitly assigned to (as a GroupMember):

SELECT Id,Name 
FROM Group 
WHERE Type = 'Queue' AND ID IN 
(SELECT GroupId FROM GroupMember WHERE UserOrGroupId =: userIdModal)

The where criteria in both queries above specifically excludes or includes those groups whose group Id is found in the query against GroupMember looking for your specific user.

Related Solutions

[SalesForce] Assign a case to a queue in Apex (Test class)

Rather than setting the Case.OwnerId to the Queue ID you need to set it to the Group ID. As OwnerId is a lookup to User and Group rather than User and Queue as displayed in the UI.

You can check it yourself using Workbench > Info > Standard & Custom Objects > Case, Fields > OwnerId > Reference To.

Workbench

However by doing this you will receive a MIXED_DML_EXCEPTION due to executing DML on a setup object (inserting QueuesObject) between DML on non-setup objects (Group and Case) to get around this you need to execute the DML on setup objects in a different context, this can be done using System.runAs(...).

If you change it to the following it should work:

Group testGroup = new Group(Name='test group', Type='Queue');
insert testGroup;

System.runAs(new User(Id=UserInfo.getUserId()))
{
    QueuesObject testQueue = new QueueSObject(QueueID = testGroup.id, SObjectType = 'Case');
    insert testQueue;
}

Case aCase = new Case(OwnerId = testGroup.Id);
insert aCase;

[SalesForce] Pre selected Rows with Pagination not working in Datatable in Saleforce LWC

You need to keep a separate list of all selections in one variable, then update this variable accordingly as you navigate pages (and also keep track of any changes).

allSelectedRows = [];
preselectedRows = [];
changePage(pageNumber) {
    let pageData = this.getPageData();
    this.allSelectedRows = this.allSelectedRows
        .filter((rowId) => !pageData.find((record) => record.UserId === rowId)) // Preserve rows outside current page
        .concat(this.template.querySelector('lightning-datatable').selectedRows); // and add rows from current page
    this.page = pageNumber;
    pageData = this.getPageData();
    this.preslectedRows = this.allSelectedRows.filter(
        (rowId) => pageData.find((record) => record.UserId === rowId) // And now find records in current page
    );
}
onFirst() {
    this.changePage(1);
}
onNext() {
    this.changePage(this.page + 1);
}
// ... etc ...

Also, some general notes...

First, don't use await and then() together:

try {
// other code here
  let userList = await getUserList();
  // rest of code here
} catch(error) {
  this.error = error;
}
this.showLoadingSpinner = false;

Or:

getUserList().then(
  userList => {
    // success logic here
  })
  .catch(error => this.error = error)
  .finally(() => this.showLoadingSpinner = false);

Second, you really didn't need to JSON.serialize and JSON.parse, you can return the wrappers directly.

Best Answer

Related Solutions

[SalesForce] Assign a case to a queue in Apex (Test class)

[SalesForce] Pre selected Rows with Pagination not working in Datatable in Saleforce LWC

Related Topic