Queries

Teamcenter FUNDAMENTALS

E-learning TC

Queries

Start

QUERY BUILDER

what are the queries and their use

TC queries follow the SQL query mode

Query Builder is only available in Teamcenter

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

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

feature that allows predefined queries for users searching teamcenter database

what is a query and what is it used for?

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

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

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

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

Display all saved queries in the database

Discover the interface by cliking the dots

SAVED QUERIES TREE PANE

search criteria pane

property selection pane

Search type button

query builder

Titre 1

SAVED QUERy properties pane

Import Queries FROM AN XML file

ExporT Queries in an XML file, SAVE and share them

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

create personalized queries

QUERY BUILDER

HINTS

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

HINTS are a tutorial to help create Queries

query example

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.

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.

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

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.

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.

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 « * » (~*)

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.

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.

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 « * » (~*)

You can import or export queries from an xml file.

import/export

queries use case

reports

Workflows

queries

quick searches

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

Quick search

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

queries

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

WORKFLOWs

reports rely on informations based on a query definition

reports

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.