我正在嘗試打印 Salesforce 自定義對(duì)象數(shù)據(jù)庫(kù)并有一個(gè)過(guò)濾器。過(guò)濾器工作正常，但“全部”過(guò)濾器不會(huì)將完整表顯示為默認(rèn)值，或者當(dāng)我從另一個(gè)過(guò)濾器中單擊“全部”時(shí)。我怎樣才能做到這一點(diǎn)？這是相關(guān)的 Apex 代碼：public string itemPickValue{get; set;} public List<QC_Issue__c> issuesList{get; set;} public List<QC_Issue__c> results; public List<QC_Issue__c> getIssues() { results = Database.query( 'SELECT Component_Category__c, Issue_Name__c, Issue_Description__c, Severity_1_Criteria__c, Severity_2_Criteria__c, Severity_3_Criteria__c, File__c FROM QC_Issue__c Order By Component_Category__c, Issue_Name__c' ); return results; } public void getIssuesList() { if(itemPickValue.equals('All')) issuesList = Database.query('SELECT Component_Category__c, Issue_Name__c, Issue_Description__c, Severity_1_Criteria__c, Severity_2_Criteria__c, Severity_3_Criteria__c, File__c FROM QC_Issue__c'); issuesList = Database.query('SELECT Component_Category__c, Issue_Name__c, Issue_Description__c, Severity_1_Criteria__c, Severity_2_Criteria__c, Severity_3_Criteria__c, File__c FROM QC_Issue__c WHERE Component_Category__c =: itemPickValue'); }這是相關(guān)的 Visualforce 代碼：<apex:pageBlock title="QC Glossary" id="qc_issues_list"> <h3>Filter by Component Category:</h3> <br></br> <!-->Start Filter and List<--> <apex:selectList size="1" value="{!itemPickValue}"> <apex:actionSupport event="onchange" action="{!getIssuesList}" rerender="table"/> <apex:selectOption itemLabel="All" itemValue="All"></apex:selectOption> <apex:selectOption itemLabel="Animation/VFX" itemValue="Animation/VFX"></apex:selectOption> </apex:selectList> <br></br> <br></br>
1 回答
Qyouu
TA貢獻(xiàn)1786條經(jīng)驗(yàn) 獲得超11個(gè)贊
我進(jìn)行了以下更改
刪除了代碼重復(fù)，使用 getIssues 方法而不是復(fù)制 SOQL 語(yǔ)句。
添加了一個(gè) if/else 子句；你的主要問(wèn)題是
getIssuesList你有一個(gè) if 語(yǔ)句，如果 true 將存儲(chǔ)完整的結(jié)果issuesList，然后立即在下一行用過(guò)濾列表覆蓋它，嘗試使用類別名稱“全部”
這里還有很多其他的事情需要指出；但我暫時(shí)不說(shuō)了。
結(jié)果：
public String itemPickValue{get; set;}
public List<QC_Issue__c> issuesList{get; set;}
public List<QC_Issue__c> results;
public List<QC_Issue__c> getIssues() {
results = Database.query(
'SELECT Component_Category__c, Issue_Name__c, Issue_Description__c, Severity_1_Criteria__c, Severity_2_Criteria__c, Severity_3_Criteria__c, File__c FROM QC_Issue__c Order By Component_Category__c, Issue_Name__c'
);
return results;
}
public void getIssuesList() {
if(itemPickValue.equals('All')) {
issuesList = getIssues();
} else {
issuesList = Database.query('SELECT Component_Category__c, Issue_Name__c, Issue_Description__c, Severity_1_Criteria__c, Severity_2_Criteria__c, Severity_3_Criteria__c, File__c FROM QC_Issue__c WHERE Component_Category__c =: itemPickValue');
}
}
添加回答
舉報(bào)
0/150
提交
取消