When and how do I need to use groups in query

+1 vote
29 views
asked Nov 2 in How To by yczehn
When and how do I need to use groups in query

1 Answer

answered Nov 2 by yczehn

 

 

a grouping is only needed when there is an OR in the Query,

wen we use an OR anywhere in the Query we need to tell the program what condtions need to be met, with out a grouping it will load the records that satisfy any conditions are met, 

so lets take an example

we always want parents only but the parents need to have one of the these three conditions  Payments Or Credit cards Or Flag, so a grouping would look like this

Parents And ( Payments Or Credit cards Or Flag) 

a very simple example in math would be 

 2 * (6 + 5)

 (2 * 6 )+ 5

you can see the grouping decides how the criteria should be evaluated

Let's Welcome our New Members

  • CSFriesel of Yeshiva Avir Yakov - JHDarchei - Dec 05, 2022

  • Abayer of Avir yakov - Dec 04, 2022

  • Mrs Landau of Mosdos Satmar - Dec 01, 2022

  • kehila of Kehilas belz - Nov 30, 2022

  • Rteitelbaum of United Academy of Union - Nov 30, 2022

  • ZalmenFriedman of Marbah Lusova - Nov 29, 2022

  • eh407 of krula - Nov 29, 2022

  • susan cohen of Prospect Park Yeshiva - Nov 29, 2022

  • AYMoshel of Yeshiva Avir Yakov - Yeshiva Ketaneh - Nov 29, 2022

  • Tzvi Liberman of Vyelipol Yeshiva - Nov 24, 2022

...