@AuraEnabled
public static List<Object> fetchDataByListviewName(String listviewId,
String searchTerm,
String area,
String province) {
if (listviewId != 'Lead') {
Listview listView = [
SELECT Id, DeveloperName
FROM ListView
WHERE Id = :listviewId
];
String soql = 'SELECT Id, Name, Province_City__c, Area__c, Street__c FROM Account WHERE Name Like \'%' +
(searchTerm != null ? searchTerm : '') + '%\' ';
if (area != null && area != '') {
soql += 'AND Area__c = \'' + area + '\' ';
}
if (province != null && province != &
apex 拼接sql
最新推荐文章于 2024-08-09 17:58:01 发布
本文详细介绍了如何在Apex应用中动态拼接SQL查询语句,包括使用 bind variables 避免SQL注入,以及优化查询性能的技巧。
摘要由CSDN通过智能技术生成