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

Thu, 12 Jun 2008 01:58:09 -0700 

Dear All,

my answer is 

queryBuildRange = dsInventTable.addRange(fieldNum(InventTable, ItemType));

queryBuildRange.value(strFmt('((%1 == %2) || ((%1 == %3) && (%4 == 
"%5")))',
    fieldStr(InventTable, ItemType),
    any2int(ItemType::Service),
    any2int(ItemType::Item),
    fieldStr(InventTable, ProjCategoryId),
    queryValue("Spares")));

using strfmt for set range in OR ..

Thanks,

Ivan Widjaksono

--- On Tue, 6/10/08, kristanto surjadi <[EMAIL PROTECTED]> wrote:
From: kristanto surjadi <[EMAIL PROTECTED]>
Subject: Re: [development-axapta] Newbie Question - Range Syntax
To: [email protected]
Date: Tuesday, June 10, 2008, 6:09 PM










    
            You can add x++ code add the report Init metod

 

     transdate td;

     ;

     

     td = today() + 192;



this.query() .dataSourceTable (tablenum( datasourcetablen ame)).addrange( 
fieldnum(

datasourcetablename , ExpDate)).value( queryRange( datenull( ),td)));

 

this.query() .dataSourceTable (tablenum( datasourcetablen ame)).addrange( 
fieldnum(

datasourcetablename , ProdType)).value( queryValue( xx1));

 

this.query() .dataSourceTable (tablenum( datasourcetablen ame)).addrange( 
fieldnum(

datasourcetablename , ProdType)).value( queryValue( xx2));

 

this.query() .dataSourceTable (tablenum( datasourcetablen ame)).addrange( 
fieldnum(

datasourcetablename , ProdType)).value( queryValue( xx3));



--- On Fri, 6/6/08, letron_brantley <letron_brantley@ yahoo.com> 
wrote:



From: letron_brantley <letron_brantley@ yahoo.com>

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

To: development- [EMAIL PROTECTED] ps.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 < 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]




      

    
    
        
         
        
        








        


        
        


      

[Non-text portions of this message have been removed]

Reply via email to