how to get a list children of family that matches a student or sibling condition in a query.

+1 vote
129 views
asked Jun 15, 2015 in Reports by BYBZ
I'm looking for a way how can we get a list in a report or childrens tab, of kids of a family that matches search criteria of a sibling.

i.e say a family 1, child 1 -  nursery child,  has a certain flag that hes in a headstart class or any flag or search property, and i'm looking to list his siblings that are in KDG in day camp.

this is just many types of situations that ive come across that this info is needed.

this should be a very basic database lookup feature.

Thanks,

1 Answer

answered Jun 16, 2015 by Admin

Is not so simple. When telling the computer you are looking for a certain flag, if its a student report it will only show the students of that flag, if its a parent list it will show any parent that has a child with that flag. The same is when querying for a period if you are looking at a students it will only show students of that criteria if you are looking on a parent list it will show you the parents of any child.

What you are trying to see is looking at a students but check if the parent meets the criteria. You can do this manually by editing the query in the edit tab. Just copy and paste from the 3rd box to the top box and click on update.

 

commented Jun 16, 2015 by BYBZ
Thanks for this option
commented Jun 17, 2015 by mbs
Thanks - this will definitely come in handy many times. Is there a way to get only the students' siblings on a report and not the students themselves who meet certain criteria?
commented Jun 17, 2015 by Admin
Simple. Just exclude that criteria.
For example Select the flag Kapures 5774 and click on exclude. That will exclude any student that has that flag.

Let's Welcome our New Members

  • astauber of JLS - Mar 27, 2024

  • yaakova of Bnos Menachem - Mar 26, 2024

  • GElefant of YGZM - Mar 21, 2024

  • bmiskin of Yeshiva Gedolah Zichron Moshe - Mar 20, 2024

  • cungar of Kollel Chatzos - Mar 18, 2024

  • sstein of Masores - Mar 18, 2024

  • RochelPultman of Prospect Park Yeshiva - Mar 11, 2024

  • rlefkowits of talmud torah ohel yochanan - Mar 11, 2024

  • Barber739 of Bnos Menachem - Mar 10, 2024

  • Chani Schwarz of Yeshiva K'tana of Waterbury - Mar 07, 2024

...