You need to sign in to do that
Don't have an account?
Rakesh M
Database.query
Hi,
I have some data posted below in table No#1. When I select value 'TS' through picklist, I'm not getting expected output as in Table No#2. After executing the code mentioned below. My output comes as in image No#1. Please help me in showing the data as expected in Table No#2.
Table No#1
Table No#2
Image No#1
Code for Program:-
public class soql
{
public list<f_97__c> f{set;get;}
public list<selectoption> options{set;get;}
public list<string> selected{set;get;}
public string query {set;get;}
public soql(){
options =new list<selectoption>();
selected=new list<string>();
list<string> types = new list<string>{'TS','BC','VD','BR','AC','AB'};
selectoption n = new selectoption('none','-None-');
options.add(n);
for(string s:types){
selectoption op = new selectoption(s,s);
options.add(op);
}
}
public void method(){
f=[select name_1__c, sap_code__c, assignment__c,type__c,total__c from f_97__c limit 999];
}
public void getdata(){
for(String s: selected)
{
if(s!='none'){
query ='select name_1__c, sap_code__c,assignment__c,type__c,total__c from f_97__c where type__c=:s';
}
}
f=Database.query(query);
}
}
<apex:page controller="soql" tabStyle="lead">
<apex:form >
<apex:pageBlock title="f.97">
<apex:pageBlockButtons location="top">
<apex:commandButton value="Outstanding" action="{!method}"/>
<apex:commandButton value="Filter" action="{!getdata}"/>
</apex:pageBlockButtons>
<apex:pageblocksection >
<apex:pageblocksectionitem >
<apex:outputtext value="Select Type"/>
<apex:selectList multiselect="true" value="{!selected}" size="1" >
<apex:selectOptions value="{!options}" />
</apex:selectList>
</apex:pageblocksectionitem>
</apex:pageblocksection>
<apex:pageBlockTable value="{!f}" var="a">
<apex:column value="{!a.SAP_CODE__c}"/>
<apex:column value="{!a.Name_1__c}"/>
<apex:column value="{!a.Type__c}"/>
<apex:column value="{!a.Assignment__c}"/>
<apex:column value="{!a.Total__c}"/>
</apex:pageBlockTable>
</apex:pageBlock>
</apex:form>
</apex:page>
Thanks in advance.
Warm Regards,
Rakesh Mungelkar.
I have some data posted below in table No#1. When I select value 'TS' through picklist, I'm not getting expected output as in Table No#2. After executing the code mentioned below. My output comes as in image No#1. Please help me in showing the data as expected in Table No#2.
Table No#1
Customer | Name 1 | Type | Assignment | Total |
XKO_1234 | Aarushi Technology | TS | IDC0315131170 | 3,482.19 |
XKO_1234 | Aarushi Technology | TS | ILL0315262295 | 10,435.92 |
XKO_1234 | Aarushi Technology | BC | UTIBR52015081700 | -4,704.41 |
XKO_1234 | Aarushi Technology | VD | CRIDC041636186 | -3,420.00 |
XKO_1234 | Aarushi Technology | VD | VPN0816977251 | 328,477.71 |
XKO_1234 | Aarushi Technology | AB | ETH1012057660 | 37,122.82 |
XKO_1234 | Aarushi Technology | BC | ILL0314200209 | 968.23 |
Table No#2
Customer | Name 1 | Type | Assignment | Total |
XKO_1234 | Aarushi Technology | TS | IDC0315131170 | 3,482.19 |
XKO_1234 | Aarushi Technology | TS | ILL0315262295 | 10,435.92 |
Image No#1
Code for Program:-
public class soql
{
public list<f_97__c> f{set;get;}
public list<selectoption> options{set;get;}
public list<string> selected{set;get;}
public string query {set;get;}
public soql(){
options =new list<selectoption>();
selected=new list<string>();
list<string> types = new list<string>{'TS','BC','VD','BR','AC','AB'};
selectoption n = new selectoption('none','-None-');
options.add(n);
for(string s:types){
selectoption op = new selectoption(s,s);
options.add(op);
}
}
public void method(){
f=[select name_1__c, sap_code__c, assignment__c,type__c,total__c from f_97__c limit 999];
}
public void getdata(){
for(String s: selected)
{
if(s!='none'){
query ='select name_1__c, sap_code__c,assignment__c,type__c,total__c from f_97__c where type__c=:s';
}
}
f=Database.query(query);
}
}
<apex:page controller="soql" tabStyle="lead">
<apex:form >
<apex:pageBlock title="f.97">
<apex:pageBlockButtons location="top">
<apex:commandButton value="Outstanding" action="{!method}"/>
<apex:commandButton value="Filter" action="{!getdata}"/>
</apex:pageBlockButtons>
<apex:pageblocksection >
<apex:pageblocksectionitem >
<apex:outputtext value="Select Type"/>
<apex:selectList multiselect="true" value="{!selected}" size="1" >
<apex:selectOptions value="{!options}" />
</apex:selectList>
</apex:pageblocksectionitem>
</apex:pageblocksection>
<apex:pageBlockTable value="{!f}" var="a">
<apex:column value="{!a.SAP_CODE__c}"/>
<apex:column value="{!a.Name_1__c}"/>
<apex:column value="{!a.Type__c}"/>
<apex:column value="{!a.Assignment__c}"/>
<apex:column value="{!a.Total__c}"/>
</apex:pageBlockTable>
</apex:pageBlock>
</apex:form>
</apex:page>
Thanks in advance.
Warm Regards,
Rakesh Mungelkar.