tag:blogger.com,1999:blog-2641146855810536218.post4425955162885249123..comments2023-12-06T10:35:29.654+00:00Comments on Axapta V/s Me: Sample union query from AX 2009Deepak Agarwalhttp://www.blogger.com/profile/14791585205262127391noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-2641146855810536218.post-90373857817089496922014-06-19T17:33:12.893+00:002014-06-19T17:33:12.893+00:00wonderful points altogether, you simply gained a b...wonderful points altogether, you simply gained a brand new reader.<br /><br />What would you suggest about your submit that you just <br />made a few days in the past? Any sure?<br /><br />My webpage ... <a href="http://beatsbydre-australia.rr32.com/" rel="nofollow">Beats By Dre Studio</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2641146855810536218.post-80523058305042574002014-06-12T00:56:21.996+00:002014-06-12T00:56:21.996+00:00I'm truly enjoying the design and layout of yo...I'm truly enjoying the design and layout of your website.<br />It's a very easy on the eyes which makes it much more enjoyable for me to come <br />here and visit more often. Did you hire out a designer to create your theme?<br />Outstanding work!<br /><br />Feel free to surf to my web blog: <a href="http://louisvuittonuk-outlet.x8einc.com/" rel="nofollow">Replica Louis Vuitton</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2641146855810536218.post-37457927953284930792013-03-07T03:57:06.823+00:002013-03-07T03:57:06.823+00:00Hi Prabath,
try this after adding range in query d...Hi Prabath,<br />try this after adding range in query data source<br /><br />qbdsSalesTable1.addGroupByField(fieldnum(Salestable, SalesId));<br /><br />It will group ur datasource table by SalesID field.Deepak Agarwalhttps://www.blogger.com/profile/14791585205262127391noreply@blogger.comtag:blogger.com,1999:blog-2641146855810536218.post-12853817765109356532013-03-04T06:39:03.546+00:002013-03-04T06:39:03.546+00:00Im using above example for getting an union output...Im using above example for getting an union output. I have use salesTable for both querybuilddatasources (with different ranges). Problem is there are some duplicate Sales orders. I want to get a grouped set of sales order. plz help. my example is as follows.<br /><br />static void UnionTestJob(Args _args)<br />{<br /><br /> Query query;<br /> QueryBuildDataSource qbdsSalesTable1;<br /> QueryBuildDataSource qbdsSalesTable2;<br /> QueryRun queryRun;<br /> SalesTable SalesTable;<br /> ;<br /><br /> query = new Query();<br /> query.queryType(QueryType::Union);<br /> qbdsSalesTable1 = query.addDataSource(tableNum(SalesTable));<br /> qbdsSalesTable1.addRange(fieldnum(Salestable, SalesId)).value('SO_0000001');<br /> qbdsSalesTable1.unionType(UnionType::UnionAll);<br /><br /> qbdsSalesTable2 = query.addDataSource(tableNum(SalesTable));<br /> qbdsSalesTable2.addRange(fieldnum(Salestable, SalesTaker)).value('Admin');<br /> qbdsSalesTable2.unionType(UnionType::UnionAll);<br /><br /><br /> queryRun = new QueryRun(query);<br /><br /> while (queryRun.next())<br /> {<br /> SalesTable = queryRun.get(tablenum(SalesTable));<br /> info(SalesTable.SalesId);<br /> }<br />}<br /><br />out put :<br /> SO_0000001<br /> SO_0000001<br /> SO_0000002<br /><br />Prabath Ranasinghehttps://www.blogger.com/profile/00830839327575928086noreply@blogger.com