[development-axapta] Re: Newbie Question - Range Syntax

[letron_brantley]

I'm not sure of the syntax I need to use.  When I try the following, 
it doesn't work.

public void init()
{
    date ed;
    ;
    super();

    ed = today() + 192;

    this.query().dataSourceTable(tablenum(InventBatch)).addrange
(fieldnum(
    InventBatch, ExpDate)).value(queryRange(Today(),ed)));
}

//I get:  Syntax Error.


--- In development-axapta@yahoogroups.com, kristanto surjadi 
<[EMAIL PROTECTED]> wrote:
>
> You can add x++ code add the report Init metod
> &nbsp;
> &nbsp;&nbsp;&nbsp; transdate td;
> &nbsp;&nbsp;&nbsp; ;
> &nbsp;&nbsp;&nbsp; 
> &nbsp;&nbsp;&nbsp; td = today() + 192;
> 
> this.query().dataSourceTable(tablenum(datasourcetablename)).addrange
(fieldnum(
> datasourcetablename, ExpDate)).value(queryRange(datenull(),td)));
> &nbsp;
> this.query().dataSourceTable(tablenum(datasourcetablename)).addrange
(fieldnum(
> datasourcetablename, ProdType)).value(queryValue(xx1));
> &nbsp;
> this.query().dataSourceTable(tablenum(datasourcetablename)).addrange
(fieldnum(
> datasourcetablename, ProdType)).value(queryValue(xx2));
> &nbsp;
> this.query().dataSourceTable(tablenum(datasourcetablename)).addrange
(fieldnum(
> datasourcetablename, ProdType)).value(queryValue(xx3));
> 
> 
> --- On Fri, 6/6/08, letron_brantley [EMAIL PROTECTED] wrote:
> 
> From: letron_brantley [EMAIL PROTECTED]
> Subject: [development-axapta] Newbie Question - Range Syntax
> To: development-axapta@yahoogroups.com
> Date: Friday, June 6, 2008, 8:50 PM
> 
> 
> 
> 
> 
> 
> Hello everyone,
> 
> My company is going through an implementation of Dynamics AX 4 and I
> have been tasked with writing some reports. It's coming along pretty
> well, but I am running into little things that are blocking me.
> 
> One question that I have has to do with Ranges in the AOT. When I
> create a new range based on a date field, what syntax do I use in 
the
> properties pane when I want to say "ExpDate &lt; Today + 192"?
> 
> Also how do I create a range that says "= xx1 or xx2 or xx3"? In SQL
> I can do "ProdType in ('XX1', 'XX2', 'XX3').
> 
> Thanks
> Letron
> 
>  
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>       
> 
> [Non-text portions of this message have been removed]
>