The keyword "force_placeholder" will force the kernel to select data using a
prepared select. Used to overrule the default forceliterals in join on large
(complex) tables. The kernel default select uses
forceplaceholders when not selecting from large tables.All tables except those
with "TableGroup" property "group" or "parameter" are considered complex by
the AX kernel.
If you want to use the "group by" clause you need to mention the field using
addsortfield, coz otherwise the group by won't work. I get that you want join
between 2 tables one of which you want to sort "group by" and other one "order
by". I am not sure whether this is possible and will get back if I find anything
Cheers
Pathikrit
- Original Message
From: anton_tjiptadi <[EMAIL PROTECTED]>
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Tuesday, May 22, 2007 2:42:25 PM
Subject: [Axapta-Knowledge-Village] select with force_placeholders
does anyone know what is "select with force_placeholder" means?
also is it possible to grouping with QueryBuildDataSourc e without
using key "addSortField" ?
common query is like this for example:
QueryBuildDataSourc e qbds;
Query q = new query();
QueryRun qr;
InventDim Inventdim;
;
qbds = q.addDataSource( tablenum( InventDim) );
qbds.addSortField( fieldnumInventDi m, configid);
qbds.addSortField( fieldnumInventDi m, inventBatchId) ;
qbds.ordermode( ordermode: :groupby) ;
qr = new QueryRun(q);
while (qr.next())
{
...
}
above statement produce grouping by configid ascending and
inventbatchid ascending order.
The problem is I want to join with another table (InventBatch) which
is I want to make order not in InventBatchId, but ExpireDate, so it
will conflict with the firt query (InventBatchId asc) bcoz might be
in second table (Inventbatch) , the ExpDate sorted but not the
inventBatchId.
please help,
thx,
Ton.
Pinpoint
customers who are looking for what you sell.
http://searchmarketing.yahoo.com/
[Non-text portions of this message have been removed]