SV: [Axapta-Knowledge-Village] tricky query
That page was good. Gonna
have to bookmark it. I put it all in one value but then it doesnt quite
work:
qbrFamily.value(strFmt('(((noOfChildren
2) (Persons.Income 3000)) || ((noOfChildren 5)
(Persons.Income 9000)))'));
It gives the right amount
of posts but some are correct and others are only partially correct and should
not have been included. Also that makes correct ones not being included. But
maybe I ll just have to work a bit on it but if u see the problem just post
the solution.
Thomas.
Från:
Axapta-Knowledge-Village@yahoogroups.com
[mailto:Axapta-Knowledge-Villa[EMAIL PROTECTED]] För Sonny Wibawa Adi
Skickat: den 15 november 2005
02:11
Till: Axapta-Knowledge-Village@yahoogroups.com
Ämne: Re:
[Axapta-Knowledge-Village] tricky query
Hi, Askeryd Thomas,
When writing the range criteria of the query, put the value using _expression_ in
query range.
For more detailed explanation about how to use _expression_ in query range, you
may point to this article:
http://www.axaptapedia.com/index.php/Expressions_in_query_ranges
So, one of the solution of your problem, write these two ranges in the range
criterias:
((income 3000) (noOfChildren 2))
((income 9000) (noOfChildren 5))
Askeryd Thomas [EMAIL PROTECTED]
wrote:
If
there are two fields in different tables, say income and noOfChildren, and you
have to set up a Query and not write it in code, i.e. use a Query with ranges
and values and not write a select. How would one solve this problem:
Selecting persons with (income 3000
noOfChildren 2) || (income 9000 noOfChildren 5) ?
Simply putting in income.value ( 3000 ||
9000) and noOfChildren.value ( 2 || 5) will not do it since that will
also include persons with income 3000 and noOfChildren 5 and vice
versa. So how can this be solved? Please help me out with this. If you know the
answer it will not take you much time to answer.
__
Thomas
Askeryd
WM-data Affärssystem
Axapta
Sandhamnsgatan 65
Box
270 30, 102 51 Stockholm
08-6710474
0733-988686
[EMAIL PROTECTED]
http://www.wmdata.se
The information transmitted is intended only for the
person or entity
to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this
information by persons or entities other than the intended recipient
is prohibited. If you received this in error, please contact the
sender and delete the material from any computer.
Best regards,
Sonny Wibawa Adi
MBS Certified Professional - Axapta 3.0 Technical
MCSD.NET
MCAD.NET
Yahoo!
FareChase - Search multiple travel sites in one click.
Sharing the knowledge on Axapta.
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] tricky query
If there are two fields in different tables, say income and noOfChildren, and you have to set up a Query and not write it in code, i.e. use a Query with ranges and values and not write a select. How would one solve this problem: Selecting persons with (income 3000 noOfChildren 2) || (income 9000 noOfChildren 5) ? Simply putting in income.value ( 3000 || 9000) and noOfChildren.value ( 2 || 5) will not do it since that will also include persons with income 3000 and noOfChildren 5 and vice versa. So how can this be solved? Please help me out with this. If you know the answer it will not take you much time to answer. __ Thomas Askeryd WM-data Affärssystem Axapta Sandhamnsgatan 65 Box 270 30, 102 51 Stockholm 08-6710474 0733-988686 [EMAIL PROTECTED] http://www.wmdata.se The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] tricky query
Hi, Askeryd Thomas,When writing the range criteria of the query, put the value using _expression_ in query range. For more detailed explanation about how to use _expression_ in query range, you may point to this article: http://www.axaptapedia.com/index.php/Expressions_in_query_rangesSo, one of the solution of your problem, write these two ranges in the range criterias:((income 3000) (noOfChildren 2)) ((income 9000) (noOfChildren 5))Askeryd Thomas [EMAIL PROTECTED] wrote:If there are two fields in different tables, say income and noOfChildren, and you have to set up a Query and not write it in code, i.e. use a Query with ranges and values and not write a select. How would one solve this problem:Selecting persons with (income 3000 noOfChildren 2) || (income 9000 noOfChildren 5) ?Simply putting in income.value ( 3000 || 9000) and noOfChildren.value ( 2 || 5) will not do it since that will also include persons with income 3000 and noOfChildren 5 and vice versa. So how can this be solved? Please help me out with this. If you know the answer it will not take you much time to answer.__Thomas AskerydWM-data Affärssystem Axapta Sandhamnsgatan 65Box 270 30, 102 51 Stockholm08-67104740733-988686[EMAIL PROTECTED]http://www.wmdata.seThe information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. Best regards,Sonny Wibawa AdiMBS Certified Professional - Axapta 3.0 TechnicalMCSD.NETMCAD.NET Yahoo! FareChase - Search multiple travel sites in one click. Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
