[SalesForce] LWC Pass variable to Apex SOQL

I'm trying to get the list of users in a Branch office. I have the following Apex performing two selections one based on a passed Id and the other based on a passed Office name.

    public with sharing class Top100 {
    @AuraEnabled(cacheable=true)
    public static List<User> getMktUsers(String usrId) {
        System.debug('theuserid:'+usrId);
        User ThisUser = [SELECT Id, Name, Office__c FROM User WHERE Id = :usrId LIMIT 1];
        System.debug('TheUserOfficeis: ' + ThisUser.Office__c);
        return [SELECT Id, Name FROM User WHERE Office__c = :ThisUser.Office__c and IsActive = True];
    }

    @AuraEnabled(cacheable=true)
    public static List<User> getUserList(String TheOffice) {
        System.debug('TheOfficeIs:' + TheOffice);
        return [SELECT Id, Name FROM User WHERE Office__c = :TheOffice and IsActive = True LIMIT 5];
    }
}

The JS looks like this:

import { LightningElement, api, track, wire } from "lwc";
import getMktUsers from "@salesforce/apex/Top100.getMktUsers";
import getUserList from "@salesforce/apex/Top100.getUserList";

import Id from "@salesforce/user/Id";

console.log(window.location.href);
let url_string = window.location.href;
let url = new URL(url_string);
let rid = url.searchParams.get("Id");
console.log(rid);

export default class Top100 extends LightningElement {
  @api recordId;
  @api objectApiName;

  @wire(getMktUsers, { usrId: { Id } }) MktUsers;
  @wire(getUserList, { TheOffice: "Orlando" }) accounts;

  userId = Id;
  recordId = rid;
  objectApiName = "lda_Opportunity__c";
}

Results from the second query (hard coded office) work fine, but the first query (passing the user id) do not work. Debug statement displaying the user id doesn't even fire. No errors. Can anyone help me figure out what is going on?

Best Answer

Try this:

import { LightningElement, api, track, wire } from "lwc";
import getMktUsers from "@salesforce/apex/Top100.getMktUsers";
import getUserList from "@salesforce/apex/Top100.getUserList";

import Id from "@salesforce/user/Id";

console.log(window.location.href);
let url_string = window.location.href;
let url = new URL(url_string);
let rid = url.searchParams.get("Id");
console.log(rid);

export default class Top100 extends LightningElement {
  @api recordId;
  @api objectApiName;
  userId = Id;

  @wire(getMktUsers, { usrId: '$userId' }) MktUsers;
  @wire(getUserList, { TheOffice: "Orlando" }) accounts;

  recordId = rid;
  objectApiName = "lda_Opportunity__c";
}

You have to pass the value dynamically using the $ symbol before the variable name.

https://developer.salesforce.com/docs/component-library/documentation/lwc/lwc.data_wire_example

Related Solutions

[SalesForce] Pass JavaScript Variable To Apex Controller in LWC

You need to create a parameter in the Apex function as below

public static Contact fetchContact(Id[] contactIds){
    return [SELECT Id,Name, LastName FROM Contact where Id IN :contactIds];
}

From the wired Apex method pass the parameter. Please note that the API name of the parameter should be the same in both js and apex code.

@wire(fetchContact, { contactIds: '$contactIdList' })
contacts;

Where contactIdList is the list of contact ids.

If you need to get a single record then use Id type instead of Id[] and pass the record Id as below.

public static Contact fetchContact(Id contactId){
    return [SELECT Id,Name, LastName FROM Contact where Id = :contactId];
}


@wire(fetchContact, { contactId: '$recordId' })
contact;

See more examples here.

Note: If you want to get only a single record with Id, always prefer the getRecord wired adapter.

[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] Pass JavaScript Variable To Apex Controller in LWC

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

Related Topic