tag:blogger.com,1999:blog-2641146855810536218.post7377964074791445565..comments2023-12-06T10:35:29.654+00:00Comments on Axapta V/s Me: Extended Query Range in Dynamics AXDeepak Agarwalhttp://www.blogger.com/profile/14791585205262127391noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2641146855810536218.post-43174242982808755532020-12-30T17:59:37.514+00:002020-12-30T17:59:37.514+00:00Hi,
I need to apply multiple extended query range...Hi,<br /><br />I need to apply multiple extended query ranges, somewhat similar to your examples above. <br /><br />When I use DataAreaId to create and apply multiple ranges, I get an OR, which I now understand.<br /><br />I need an AND instead.<br /><br />I think the easy answer is to use different placeholder fields - DataAreaId, as you suggest, and maybe RecId and CreatedDateTime, which are fields that appear in every table. But using these different placeholder fields makes the code a bit harder to understand. Do you know another way to accomplish ANDs?<br /><br />Thank you!cdhttps://www.blogger.com/profile/18426294898268204449noreply@blogger.comtag:blogger.com,1999:blog-2641146855810536218.post-34390350179379910672018-10-30T15:33:30.656+00:002018-10-30T15:33:30.656+00:00Hello, any idea how to add a range to the 'Hav...Hello, any idea how to add a range to the 'Having' field value that matches another field? <br /><br />Essentially this in SQL:<br />having sum(f.receiveNow) != b.receiveNKanoaAzingerhttps://www.blogger.com/profile/15600905618995647687noreply@blogger.com