Hi,
do you mean something like this?
criteria1.value(strfmt('%1, %2', queryValue(value1),eryValue(value2)));
criteria1.value(strfmt('%1.. %2', queryValue(value1),eryValue(value2)));
etc.
Or you can use SQL-like query:
Query q = new Query();
QueryBuildDataSource qbr1, qbr2, qbr3, qbr4, qbr5;
QueryRun qr;
ProjTable tb;
;
qbr1 = q.addDataSource(tablenum(ProjTable), "tab1");
qbr2 = qbr1.addDataSource(tablenum(ProjTable), "tab2");
qbr2.addRange(fieldNum(ProjTable,recid)).value(
strFmt('((%5.%3 == %4.%1)) && ((%4.%1 != "")) || ((%4.%1 == "") && ((%5.%2
== "%6"))))',
fieldStr(ProjTable,ParentId),
fieldStr(ProjTable,Type),
fieldStr(ProjTable,ProjId),
qbr1.name(),
qbr2.name(),
ProjType::FixedPrice
));
info(qbr1.toString());
--- In Axapta-Knowledge-Village@yahoogroups.com, [EMAIL PROTECTED] wrote:
>
>
> How can i include two or more than 2 criterias in a query?
>
> i.e; for one criteria I am going like this
>
> QueryBuildRange criteria1;
> criteria1 =
this.query().dataSourceTable(tablenum(Table1)).addRange(fieldnum(Table1,field1));
> criteria1.value(strfmt('%1', queryValue(value1)));
>
> Now how can I use the same query for 2 or more than 2 criteria?
>
> I will be thankful if any of u can guide me.
>
> --
> This message was sent on behalf of [EMAIL PROTECTED] at openSubscriber.com
> http://www.opensubscriber.com/messages/axapta-knowledge-
[EMAIL PROTECTED]/topic.html
>
