<apex:form>
<apex:pageBlock title="Low Stock Items" id="stock_item_list">
<!-- Stock Item List goes here -->
<apex:pageBlockTable value="{! StockItems }" var="si">
<apex:column value="{! si.ID }"/>
<apex:column value="{! si.Item_Name__c }"/>
<apex:column value="{! si.Item_Stock_is_Low__c }"/>
<apex:column value="{! si.Minimum_Stock_Level__c }"/>
<apex:column value="{! si.Stock_on_Hand__c }"/>
</apex:pageBlockTable>
</apex:pageBlock>
</apex:form>
</apex:page>
public class StockListController {
public List<Stock_Item__c> getStockItems() {
List<Stock_Item__c> results = Database.query(
'SELECT ID, Item_Name__c, Item_Stock_is_Low__c, Minimum_Stock_Level__c, Stock_on_Hand__c ' +
'FROM Stock_Item__c ' +
'WHERE Item_Stock_is_Low__c = true'
);
return results;
}
}
4 respostas
Here it is , try it :
<apex:page lightningStyleSheets="true" standardController=”Account” extensions="StockListController" >
<apex:form>
<apex:pageBlock title="Low Stock Items" id="stock_item_list">
<!-- Stock Item List goes here -->
<apex:pageBlockTable value="{! StockItems }" var="si">
<apex:column value="{! si.ID }"/>
<apex:column value="{! si.Item_Name__c }"/>
<apex:column value="{! si.Item_Stock_is_Low__c }"/>
<apex:column value="{! si.Minimum_Stock_Level__c }"/>
<apex:column value="{! si.Stock_on_Hand__c }"/>
</apex:pageBlockTable>
</apex:pageBlock>
</apex:form>
</apex:page>
public class StockListController {
public StockListController (ApexPages.StandardController acon) { }
public List<Stock_Item__c> getStockItems() {
List<Stock_Item__c> results = Database.query(
'SELECT ID, Item_Name__c, Item_Stock_is_Low__c, Minimum_Stock_Level__c, Stock_on_Hand__c ' +
'FROM Stock_Item__c ' +
'WHERE Item_Stock_is_Low__c = true'
);
return results;
}
}
inform me if it works or not
Stay safe
