Queries

Queries

E-learning TC

Teamcenter FUNDAMENTALS

Start

what are the queries and their use

QUERY BUILDER

TC queries follow the SQL query mode

what is a query and what is it used for?

feature that allows predefined queries for users searching teamcenter database

queries are used either in ootb versions, modified or created from scratch

Exceptions : Query builder does not support run-time or coumpound properties

Query Builder is only available in Teamcenter

query builder

Discover the interface by cliking the dots

SAVED QUERIES TREE PANE

Display all saved queries in the database

SAVED QUERy properties pane

Display the name, description, query type, and searched type of the saved selected queries

Search type button

Display the business type selection dialog box the lists the query type

Titre 1

property selection pane

Displays the attributes of the selected type and either all inherited types or only the direct attributes of the type, depending on the display setting you select

search criteria pane

Defines the search criteria clauses using attributes, user entry keys, operators, and default values. Boolean operators process multiple search criteria clauses

QUERY BUILDER

ExporT Queries in an XML file, SAVE and share them

create personalized queries

use hints to navigate the schema by presenting a relationship to traverse

Import Queries FROM AN XML file

HINTS

HINTS are a tutorial to help create Queries

Query hints are provided to assist you in navigating the schema by presenting a relationship to traverse (for example, item-to-item master form) and the steps required to build that relationship into your query definition.

HINTS are a tutorial to help create Queries

query example

Cette requête permet de rechercher des objets associés à un ID d'élément spécifique (Item ID) d'un objet principal. L'objet principal dans ce cas est une révision d'un article (item revision). En d'autres termes, elle va identifier et renvoyer les objets qui sont liés à cette révision d'article, en se basant sur l'ID de l'élément de l'article principal.

This query allows you to search for objects associated with a specific Item ID of a primary object. The primary object in this case is a revision of an item. In other words, it identifies and returns the objects linked to this item revision, based on the item ID of the primary object.

Query on "ImanRelation" searching objects according to the Item ID of a primary object(primary_object). THE PRImary object is an item revision

Query on "ImanRelation" searching objects according to the Item ID of a primary object(primary_object). THE PRImary object is an item revision

Query on "ImanRelation" searching objects according to the Item ID of a primary object(primary_object). THE PRImary object is an item revision

Cette requête permet de rechercher un Dataset (jeu de données) associé à une révision d'article (ItemRevision) en utilisant un paramètre appelé object_name. L'objectif est de retrouver le jeu de données spécifique qui est lié à la révision d'un article donné, en se basant sur le nom de l'objet fourni (object_name). Cela permet de filtrer les résultats et d'identifier précisément les datasets qui sont associés à un article particulier selon son nom, ce qui peut être utile pour la gestion et l'accès aux informations détaillées liées à cette révision d'article.

This query allows you to search for a Dataset associated with an ItemRevision using a parameter called object_name. The goal is to find the specific dataset related to a given item revision, based on the provided object name. This helps filter the results and precisely identify the datasets linked to a particular item according to its name, which can be useful for managing and accessing detailed information related to that specific item revision.

Query on "Dataset" carried by an ItemRevision with "object_name" as a parameter

Query on "Dataset" carried by an ItemRevision with "object_name" as a parameter

Query on "Dataset" carried by an ItemRevision with "object_name" as a parameter

Query searching datasets with an imanfile original file name containing either a « / » or « * » (~*)

Cette requête permet de rechercher des datasets dont le nom de fichier original de type "Imanfile" contient soit un « / », soit un « * » (ou ~*). Elle permet de filtrer et d'identifier les datasets ayant un nom de fichier contenant ces caractères spéciaux, ce qui peut être important dans des cas où ces symboles sont utilisés pour marquer des fichiers spécifiques ou pour des raisons de structure de noms dans un système de gestion de données.

This query allows you to search for datasets whose "Imanfile" original file name contains either a “/” or a “*” (or ~*). It filters and identifies datasets with filenames containing these special characters, which may be important in cases where such symbols are used to mark specific files or for naming conventions in a data management system.

Query searching datasets with an imanfile original file name containing either a « / » or « * » (~*)

Query searching datasets with an imanfile original file name containing either a « / » or « * » (~*)

Query searching datasets with an imanfile original file name containing either a « / » or « * » (~*)

Query searching datasets with an imanfile original file name containing either a « / » or « * » (~*)

import/export

You can import or export queries from an xml file.

queries use case

quick searches

queries

Workflows

reports

Quick search

You can create quick searches in Teamcenter and active workspace by using the "QUICK_ACCES_QUERIES" & "Quick_acces_queries_attributes" preference

queries

use the "qrysshownpref" to determine which query will be available in the search bar

WORKFLOWs

queries can be used also to proceed checkings on objects to validate workflow steps

reports

reports rely on informations based on a query definition

Your content is liked, but only engages if it is interactive. Capture the attention of your audience with an interactive photograph or illustration.

Your content is liked, but only engages if it's interactive. Capture your audience's attention with an interactive photograph or illustration.