---
title: School Data Service (SDS)
description: School Data Service (SDS) | Help & Support — GO 4 Schools
---

[Skip to content](https://supporttest.go4schools.com/mis/school-data-service-sds#main-content)

![GO logo](https://supporttest.go4schools.com/hubfs/GO-logo.svg)

- [Tickets](https://146391209.hs-sites-eu1.com/tickets-view)
- [Sign out](https://146391209.hs-sites-eu1.com/_hcms/mem/logout)

Open main navigation

Close main navigation

- [Tickets](https://146391209.hs-sites-eu1.com/tickets-view)
- [Sign out](https://146391209.hs-sites-eu1.com/_hcms/mem/logout)
- [Contact us](https://www.go4schools.com/contact)

[Contact us](https://www.go4schools.com/contact)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [GO 4 Schools MIS](https://supporttest.go4schools.com/mis?hsLang=en-gb)
2. [Reports](https://supporttest.go4schools.com/mis/reports?hsLang=en-gb)

# School Data Service (SDS)

**School Data Service**

The School Data Service (SDS) will allow schools to create queries to extract data reports from GO 4 Schools. 

**Permissions** (MIS)- Set permission for the SDS and additional permissions set will allow access to the data where users have permissions set. 

(Modular) The link below is only accessible to School Managers. 

![A screenshot of a computer

AI-generated content may be incorrect.](https://supporttest.go4schools.com/hs-fs/hubfs/undefined-Apr-10-2026-10-44-47-9727-AM.png?width=370&height=165&name=undefined-Apr-10-2026-10-44-47-9727-AM.png)

The SDS is available from the main menu: **School \> School Data Service.** 

The listing page will show the User’s saved queries.  Select **‘+Add New school data query’** to build a new report. 

*NB: The Service is in active development, and more features and areas of data will be added over time.  Please note the warning on the listing page.*

![A blue background with black text

AI-generated content may be incorrect.](https://supporttest.go4schools.com/hs-fs/hubfs/undefined-Apr-10-2026-10-44-50-4824-AM.png?width=418&height=76&name=undefined-Apr-10-2026-10-44-50-4824-AM.png)

Each step to create a query is clearly labelled for the user to build simple or more complex reports of their data. 

![](https://supporttest.go4schools.com/hs-fs/hubfs/undefined-Apr-10-2026-10-44-50-0261-AM.png?width=1366&height=327&name=undefined-Apr-10-2026-10-44-50-0261-AM.png)

**Template Queries**

Select **'View query templates'** to access templates provided by GO 4 Schools.  A page of templates providing useful common data reports can be found.  Select 'Use template' to open the query.

*NB: More templates will be added overtime from suggestions provided by schools via a support ticket.*  

![](https://supporttest.go4schools.com/hs-fs/hubfs/undefined-Apr-10-2026-10-44-48-4479-AM.png?width=1095&height=402&name=undefined-Apr-10-2026-10-44-48-4479-AM.png)When the query page is open if data included in the template is not available to report a pop-up will display listing these fields.

![](https://supporttest.go4schools.com/hs-fs/hubfs/undefined-Apr-10-2026-10-44-49-7932-AM.png?width=482&height=487&name=undefined-Apr-10-2026-10-44-49-7932-AM.png)

The user can continue to edit the report as required and save as required. 

**Build a simple query Step by step**

**Step 1**

Select Fields: ‘**Add an area’** to select the core data that is required for your report, this includes students, staff etc.  

![A screenshot of a computer

AI-generated content may be incorrect.](https://supporttest.go4schools.com/hs-fs/hubfs/undefined-Apr-10-2026-10-44-50-2867-AM.png?width=482&height=138&name=undefined-Apr-10-2026-10-44-50-2867-AM.png)

Once selected the data can be selected from ‘Loaders’ for a range of parameters and data sets. The headers can be expanded to view all of the fields available from the loader, and will show the number of fields selected.  Fields can be bulk or individually select/deselected. 

![A screenshot of a computer

AI-generated content may be incorrect.](https://supporttest.go4schools.com/hs-fs/hubfs/undefined-Apr-10-2026-10-44-48-7062-AM.png?width=418&height=604&name=undefined-Apr-10-2026-10-44-48-7062-AM.png)

Loaders can and do have overlapping fields. When you select a field in one loader, it will be selected in all other loaders that contain it as well. Then from the data sets each area can be expanded to select from a list or fields can be searched.  Data can be selected from multiple sets to build the query. 

Example: Lastname, firstname, Year group, Sex, PPI, FSM, SEN Code

![A screenshot of a computer

AI-generated content may be incorrect.](https://supporttest.go4schools.com/hs-fs/hubfs/undefined-Apr-10-2026-10-44-49-5802-AM.png?width=388&height=420&name=undefined-Apr-10-2026-10-44-49-5802-AM.png)

**Step 2**

Join areas – This is a more advanced feature and will allow users to combine data from different areas such as student and student contact data. See [Advanced School Data Service.](https://support.go4schools.com/en/support/solutions/articles/80001196803) 

**Step 3**

Select filters – In non-advanced mode limits are applied to the kind of filters that can be added and are useful to build filters into the query to narrow the range of data. These are added via conditions for the selected fields.  The conditions use the logic AND/OR, including  the following:

![A screenshot of a computer

AI-generated content may be incorrect.](https://supporttest.go4schools.com/hs-fs/hubfs/undefined-Apr-10-2026-10-44-50-6829-AM.png?width=208&height=111&name=undefined-Apr-10-2026-10-44-50-6829-AM.png)

Depending what data type field is selected options for the right-hand side will change, as well as what kind of comparison you're doing between the left and right:

- String (Text): free text field
- Boolean: dropdown with choice of true or false
- Date: free text, but must be in the form yyyy-mm-dd

Example below : SEN students that are PPI. 

![A screenshot of a computer

AI-generated content may be incorrect.](https://supporttest.go4schools.com/hs-fs/hubfs/undefined-Apr-10-2026-10-44-49-1445-AM.png?width=602&height=235&name=undefined-Apr-10-2026-10-44-49-1445-AM.png)

**Step 4**

Specify sort order – organising the order of the query result. Multiple sorts can be added and the priority order dragged to change. 

![A screenshot of a computer

AI-generated content may be incorrect.](https://supporttest.go4schools.com/hs-fs/hubfs/undefined-Apr-10-2026-10-44-48-9161-AM.png?width=412&height=253&name=undefined-Apr-10-2026-10-44-48-9161-AM.png)

**Step 5**

Specify column position and visibility – to organise the layout of the query result. This appears as a modal to drag the re-order and set the visibility.  Below SEND Provision is hidden. The Preview shows the order of the columns. 

![A screenshot of a computer

AI-generated content may be incorrect.](https://supporttest.go4schools.com/hs-fs/hubfs/undefined-Apr-10-2026-10-44-48-1960-AM.png?width=567&height=375&name=undefined-Apr-10-2026-10-44-48-1960-AM.png)

**Final step**

Select **‘ Execute query’** to run and view the results. Once built a query can be saved by the user. 

![](https://supporttest.go4schools.com/hs-fs/hubfs/undefined-Apr-10-2026-10-44-49-3667-AM.png?width=291&height=49&name=undefined-Apr-10-2026-10-44-49-3667-AM.png)

![](https://supporttest.go4schools.com/hs-fs/hubfs/undefined-Apr-10-2026-10-44-50-9053-AM.png?width=601&height=52&name=undefined-Apr-10-2026-10-44-50-9053-AM.png)

Once the results are available they are ready for the user to ‘take-away’.  The page is not designed for users to analyse the results.  Download as the required format and then add to Excel, Googlesheets, PowerBI or other 3rd party products. 

Because of that design principle, this page:

- DOESN'T have usual eTable functionality like searching, sorting.
- DOESN'T (necessarily) show all your results on the page: For a huge attendance query with many fields and a wide timeframe, that could be tens of columns times 10s or 100s of thousands of rows. Rendering a table of that size may crash the browser. Enough rows are visible to be sure you've built your query correctly, but then export the data to see it in full elsewhere!

**Save your query**

Select ‘Save query’ and a modal will show to add a name to save. 

![A screenshot of a computer

AI-generated content may be incorrect.](https://supporttest.go4schools.com/hs-fs/hubfs/undefined-Apr-10-2026-10-44-51-1712-AM.png?width=429&height=195&name=undefined-Apr-10-2026-10-44-51-1712-AM.png)The query will display on the listing page. The query name can be edited or deleted.   In future releases the option to share will be available.

- [General](https://supporttest.go4schools.com/mis/general?hsLang=en-gb)
- [Academic Year Set Up](https://supporttest.go4schools.com/mis/academic-year-set-up?hsLang=en-gb)
- [Student records](https://supporttest.go4schools.com/mis/student-records?hsLang=en-gb)
- [Courses](https://supporttest.go4schools.com/mis/courses?hsLang=en-gb)
- [Timetables](https://supporttest.go4schools.com/mis/timetables?hsLang=en-gb)
- [Cover management](https://supporttest.go4schools.com/mis/cover-management?hsLang=en-gb)
- [Exams](https://supporttest.go4schools.com/mis/exams?hsLang=en-gb)
- [Reports](https://supporttest.go4schools.com/mis/reports?hsLang=en-gb)
- [MIS Communications](https://supporttest.go4schools.com/mis/mis-communications?hsLang=en-gb)
- [Settings](https://supporttest.go4schools.com/mis/settings?hsLang=en-gb)
- [Census](https://supporttest.go4schools.com/mis/census?hsLang=en-gb)
- [Staff records](https://supporttest.go4schools.com/mis/staff-records?hsLang=en-gb)
- [Roles and Permissions](https://supporttest.go4schools.com/mis/roles-and-permissions?hsLang=en-gb)
- [Admissions](https://supporttest.go4schools.com/mis/admissions?hsLang=en-gb)
- [Agencies and agents](https://supporttest.go4schools.com/mis/agencies-and-agents?hsLang=en-gb)
- [Video Guides](https://supporttest.go4schools.com/mis/video-guides?hsLang=en-gb)

Copyright © 2026, GO 4 Schools