This pull request derives a table of organisations, and uses it to populate a new column in the table search.page that gives the full ancestry of the organisation that published a given page. This will allow a new feature in GovSearch to filter by an organisation or its constituent parts, which has been requested by users.
Organisations can have multiple parents at differing depths, so there is no meaningful way to describe the depth of an organisation in the hierarchy. For example, the arrows in the diagrams below are links of type ordered_child_organisations. The organisations are each associated with their immediate parent organisation, as well as with organisations that are further up the hierarchy.
This pull request derives a table of organisations, and uses it to populate a new column in the table
search.page
that gives the full ancestry of the organisation that published a given page. This will allow a new feature in GovSearch to filter by an organisation or its constituent parts, which has been requested by users.Organisations can have multiple parents at differing depths, so there is no meaningful way to describe the depth of an organisation in the hierarchy. For example, the arrows in the diagrams below are links of type
ordered_child_organisations
. The organisations are each associated with their immediate parent organisation, as well as with organisations that are further up the hierarchy.TODO: