add range.value in a query

Hi
I want to add a range in a query where the value of the field must not be
empty.
like in this example we added a range where salesstatus cannot be canceled
or invoiced.
newQueryRun.query().dataSourceNo(1).addRange(fieldNum(salesTable,
salesStatus)).value('!Canceled, !Invoiced');

similarly is there a way tto define a range so that the only records which
have some value in there project field are selected.
Thanks in advance

VG

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

Messages in this topic (1) Reply (via web post) | Start a new topic

.

Hi

You have the option to define the range status as rangestatus::Locked.

queryBuildRange.value(<some value>)

queryBuildRange.status(RangeStatus::Locked)

regards

/Bruno

From: development-axapta%40yahoogroups.com">development-axaptayahoogroups.com
[mailto: development-axapta%40yahoogroups.com">development-axaptayahoogroups.com] On Behalf Of V G
Sent: 1. august 2007 22:34
To: Axapta-Knowledge-Village%40yahoogroups.com">Axapta-Knowledge-Villageyahoogroups.com;
development-axapta%40yahoogroups.com">development-axaptayahoogroups.com
Subject: [development-axapta] add range.value in a query

Hi
I want to add a range in a query where the value of the field must not be
empty.
like in this example we added a range where salesstatus cannot be canceled
or invoiced.
newQueryRun.query().dataSourceNo(1).addRange(fieldNum(salesTable,
salesStatus)).value('!Canceled, !Invoiced');

similarly is there a way tto define a range so that the only records which
have some value in there project field are selected.
Thanks in advance

VG

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

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

Messages in this topic (0) Reply (via web post) | Start a new topic

.

Hi VG,

you can use sysquery::valueNotEmptyString() as the value of the range.

newQueryRun.query().....value(sysquery::valueNotEmptyString());


Regards,


Kris

V G < learnaxapta%40gmail.com">learnaxaptagmail.com> wrote:
Hi
I want to add a range in a query where the value of the field must not be
empty.
like in this example we added a range where salesstatus cannot be canceled
or invoiced.
newQueryRun.query().dataSourceNo(1).addRange(fieldNum(salesTable,
salesStatus)).value('!Canceled, !Invoiced');

similarly is there a way tto define a range so that the only records which
have some value in there project field are selected.
Thanks in advance

VG

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

---------------------------------
Boardwalk for $500? In 2007? Ha!
Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.

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

Messages in this topic (0) Reply (via web post) | Start a new topic

.

I guess you need that :

SysQuery::valueNotEmptyString();

Steeve...

--- In development-axapta%40yahoogroups.com">development-axaptayahoogroups.com, "V G" <learnaxapta...>
wrote:
>
&gt; Hi
> I want to add a range in a query where the value of the field must
not be
> empty.
&gt; like in this example we added a range where salesstatus cannot be
canceled
> or invoiced.
> newQueryRun.query().dataSourceNo(1).addRange(fieldNum(salesTable,
> salesStatus)).value('!Canceled, !Invoiced');
>
>
> similarly is there a way tto define a range so that the only
records which
&gt; have some value in there project field are selected.
> Thanks in advance
>
> VG
>
>
> [Non-text portions of this message have been removed]
>

Messages in this topic (0) Reply (via web post) | Start a new topic

.

Hi V G

For this use

sysQuery::valueNotEmptyString();

I think it will be helpful.

--- In development-axapta%40yahoogroups.com">development-axaptayahoogroups.com, "V G" <learnaxapta...>
wrote:
>
&gt; Hi
> I want to add a range in a query where the value of the field must
not be
> empty.
&gt; like in this example we added a range where salesstatus cannot be
canceled
> or invoiced.
> newQueryRun.query().dataSourceNo(1).addRange(fieldNum(salesTable,
> salesStatus)).value('!Canceled, !Invoiced');
>
>
> similarly is there a way tto define a range so that the only
records which
&gt; have some value in there project field are selected.
> Thanks in advance
>
> VG
>
>
> [Non-text portions of this message have been removed]
>

Messages in this topic (0) Reply (via web post) | Start a new topic

.

Thanks guys
It helped

VG

On 8/6/07, EISAxapta < kumardeewakar%40yahoo.com">kumardeewakaryahoo.com> wrote:
&gt;
> Hi V G
>
> For this use
>
> sysQuery::valueNotEmptyString();
>
> I think it will be helpful.
>
>; --- In development-axapta%40yahoogroups.com">development-axaptayahoogroups.com<development-axapta%40yahoogroups.com>,
> "V G" <learnaxapta...>
> wrote:
&gt; >
>; > Hi
> > I want to add a range in a query where the value of the field must
>; not be
> > empty.
&gt; > like in this example we added a range where salesstatus cannot be
> canceled
> > or invoiced.
> > newQueryRun.query().dataSourceNo(1).addRange(fieldNum(salesTable,
> > salesStatus)).value('!Canceled, !Invoiced');
> >
>; >
>; > similarly is there a way tto define a range so that the only
>; records which
&gt; > have some value in there project field are selected.
> > Thanks in advance
> >
>; > VG
> >
>; >
>; > [Non-text portions of this message have been removed]
> >
>;
>
>

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

Messages in this topic (0) Reply (via web post) | Start a new topic

.