RE: [development-axapta] How to filter data when lookup?

[Girish Bhatkal]

Hi Amar,
 if you need to give filter condition for multiple customers then it is always adviced 
to allow to choose in a query and not a dialog box. if you do choose the dialog box 
then for say customers 4000..4020 u then should write code to fetch each of this data 
before getting the same in the fetch
cheers,
Girish
-----Original Message-----
From: Amar Kumar Senapati [mailto:[EMAIL PROTECTED]
Sent: 30 October 2003 03:50
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] How to filter data when lookup?
Hi All,
I am trying to give filter(Customer) conditions to my reports. So I used dialog fileld 
(wrote in class). Then calling this in my report fetch method. I wrote this piece of 
code in fetch method.
this.query().dataSourceTable(tableNum(Custtable)).addRange(fieldNum(CustTable,accountnum)).value(iNNSO_SalesOrderGraphPerCust.parmCustAccount());
but this works for one customer . But when I enter more than customer using comma for 
the filtering , its not working. It takes the first one only.
Can it be possible. Whats I need to modify in my code.
Regards
AMAR
-----Original Message-----
From: Sherif Metwally [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 29, 2003 8:17 PM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] How to filter data when lookup?

You should use this
queryBuildDataSource.addRange(fieldNum(CustTrans, Invoice)).value(">"+queryvalue(""));
-----Oorspronkelijk bericht-----
Van: oreobizkitja [mailto:[EMAIL PROTECTED]
Verzonden: woensdag 29 oktober 2003 10:34
Aan: [EMAIL PROTECTED]
Onderwerp: [development-axapta] How to filter data when lookup?
and how to do that i don't wanna show Lookup record that not have 
value in field 'Invoice' of table 'CustTrans'
if i override lookup method of StringEdit in below

public void lookup()
{
   Query                   query   = new Query();
   QueryBuildDataSource    queryBuildDataSource;
   SysTableLookup          sysTableLookup;
   ;
   
   sysTableLookup  = SysTableLookup::newParameters(tableNum
(CustTrans),this);
   sysTableLookup.addLookupfield(fieldNum(CustTrans, Invoice));
   sysTableLookup.addLookupfield(fieldNum(CustTrans, TransDate));
   sysTableLookup.addLookupfield(fieldNum(CustTrans, Duedate));
   sysTableLookup.addLookupfield(fieldNum(CustTrans, AmountCur));

   queryBuildDataSource = query.addDataSource(tableNum(CustTrans));
//    queryBuildDataSource.addRange(fieldNum(CustTrans, 
Invoice)).value("");
   
   sysTableLookup.parmQuery(query);
   sysTableLookup.performFormLookup();

}

Thank,
OreoBizkit




Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 





Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 

Yahoo! Groups Sponsor	 
	 
	

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.