Filtering And Sorting

Students

{
    "$orderby": "it.FullName"
}
    

The $orderby parameter allows the data to be ordered as desired. asc ascending sorting. desc descending sorting.

If you want another $orderby, it is shown in the list below.

{
    "$orderby": "it.Enrollment.ID" or
    "$orderby": "it.Enrollment.GradeLevel desc" or
    "$orderby": "it.Enrollment.YearID desc" or
    "$orderby": "it.Enrollment.Homeroom" or
    "$orderby": "it.Enrollment.LocalId desc" or
    "$orderby": "it.ID" or
    "$orderby": "it.FullName desc"
}
    

Can be used as above.

{
    "$where": "it.Enrollment.YearID == 2025"
}
    

The $where allows you to filter the data based on specified conditions. It accepts a string expression that matches the fields and values of the dataset, enabling dynamic and flexible filtering.

If you want another $where, it is shown in the list below.

{
    "$where": "it.Enrollment.ID == Guid(11184a41-3d1c-ef11-8117-bc97e1afd913)" or
    "$where": "it.Enrollment.GradeLevel == 04" or
    "$where": "it.Enrollment.YearID == 2025" or
    "$where": "it.Enrollment.Homeroom == 4/A" or
    "$where": "it.Enrollment.LocalId == 3" or
    "$where": "it.ID == Guid(11184a41-3d1c-ef11-8117-bc97e1afd913)" or
    "$where": "it.FullName == Hasan Göçmen" or
    "$where": "it.FullName.contains(Hasan) || it.FullName.contains(Göçmen)"
}
    

If you get an error, you can add an escape \" element. For example "$where": "ID == Guid(\"aa667af6-3c6c-ef11-8147-bc97e1afd933\")"

Can be used as above.

Teachers

{
    "$orderby": "it.FullName"
}
    

The $orderby parameter allows the data to be ordered as desired. asc ascending sorting. desc descending sorting.

If you want another $orderby, it is shown in the list below.

{
    "$orderby": "it.Assignment.ID" or
    "$orderby": "it.ID" or
    "$orderby": "it.FullName desc"
}
    

Can be used as above.

{
    "$where": "it.Assignment.ID == Guid(11184a41-3d1c-ef11-8117-bc97e1afd913)"
}

The $where allows you to filter the data based on specified conditions. It accepts a string expression that matches the fields and values of the dataset, enabling dynamic and flexible filtering.

If you want another $where, it is shown in the list below.

{
    "$where": "it.Assignment.ID == Guid(11184a41-3d1c-ef11-8117-bc97e1afd913)" or
    "$where": "it.ID == Guid(11184a41-3d1c-ef11-8117-bc97e1afd913)" or
    "$where": "it.FullName == Melih Öztunç" or
    "$where": "it.FullName.contains(Melih Öztunç)"
}

If you get an error, you can add an escape \" element. For example "$where": "it.ID == Guid(\"a2467af6-3c6c-ef11-8147-bc97e1afd113\")"

Can be used as above.