partSiteInformation-select-all.rq

# Copyright (c) 2023 SAP SE 
# Copyright (c) 2023 T-Systems International GmbH 
# Copyright (c) 2023 Contributors to the Eclipse Foundation
#
# See the NOTICE file(s) distributed with this work for additional
# information regarding copyright ownership.
#
# This program and the accompanying materials are made available under the
# terms of the Apache License, Version 2.0 which is available at
# https://www.apache.org/licenses/LICENSE-2.0.
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
# License for the specific language governing permissions and limitations
# under the License.
#
# SPDX-License-Identifier: Apache-2.0

PREFIX cx-common: <https://w3id.org/catenax/ontology/common#>
PREFIX cx-core: <https://w3id.org/catenax/ontology/core#>
PREFIX cx-vehicle: <https://w3id.org/catenax/ontology/vehicle#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

# Select the partsite informations of a all parts

SELECT ?catenaXId ?site ?function (MIN(?roleValidFrom) AS ?roleValidFrom) (MAX(?roleValidTo) AS ?roleValidTo) WHERE {

    ?catenaXId cx-vehicle:manufacturer ?site.
    ?site cx-common:isSiteOf ?legal;
          cx-common:validityPeriodStart ?roleValidFrom;
          cx-common:validityPeriodEnd ?roleValidTo .

    BIND("production" AS ?function)
}
GROUP BY ?catenaXId ?site ?function
ORDER BY DESC(?catenaXId)