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. <!-- #ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;} #ygrp-mlmsg table {font-size:inherit;font:100%;} #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;} #ygrp-mlmsg pre, code {font:115% monospace;} #ygrp-mlmsg * {line-height:1.22em;} #ygrp-text{ font-family:Georgia; } #ygrp-text p{ margin:0 0 1em 0;} #ygrp-tpmsgs{ font-family:Arial; clear:both;} #ygrp-vitnav{ padding-top:10px;font-family:Verdana;font-size:77%;margin:0;} #ygrp-vitnav a{ padding:0 1px;} #ygrp-actbar{ clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;} #ygrp-actbar .left{ float:left;white-space:nowrap;} .bld{font-weight:bold;} #ygrp-grft{ font-family:Verdana;font-size:77%;padding:15px 0;} #ygrp-ft{ font-family:verdana;font-size:77%;border-top:1px solid #666; padding:5px 0; } #ygrp-mlmsg #logo{ padding-bottom:10px;} #ygrp-vital{ background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;} #ygrp-vital #vithd{ font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;} #ygrp-vital ul{ padding:0;margin:2px 0;} #ygrp-vital ul li{ list-style-type:none;clear:both;border:1px solid #e0ecee; } #ygrp-vital ul li .ct{ font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;} #ygrp-vital ul li .cat{ font-weight:bold;} #ygrp-vital a { text-decoration:none;} #ygrp-vital a:hover{ text-decoration:underline;} #ygrp-sponsor #hd{ color:#999;font-size:77%;} #ygrp-sponsor #ov{ padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;} #ygrp-sponsor #ov ul{ padding:0 0 0 8px;margin:0;} #ygrp-sponsor #ov li{ list-style-type:square;padding:6px 0;font-size:77%;} #ygrp-sponsor #ov li a{ text-decoration:none;font-size:130%;} #ygrp-sponsor #nc { background-color:#eee;margin-bottom:20px;padding:0 8px;} #ygrp-sponsor .ad{ padding:8px 0;} #ygrp-sponsor .ad #hd1{ font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;} #ygrp-sponsor .ad a{ text-decoration:none;} #ygrp-sponsor .ad a:hover{ text-decoration:underline;} #ygrp-sponsor .ad p{ margin:0;} o {font-size:0;} .MsoNormal { margin:0 0 0 0;} #ygrp-text tt{ font-size:120%;} blockquote{margin:0 0 0 4px;} .replbq {margin:4;} --> ____________________________________________________________________________________Pinpoint customers who are looking for what you sell. http://searchmarketing.yahoo.com/ [Non-text portions of this message have been removed]