One of the unique functions of smartsoft _ convenient, flexible, and powerful data query Functions

One of the unique functions of smartsoft _ convenient, flexible, and powerful data query Functions

____ One of the most frequently used functions of various management software required by enterprises is the query function. Users urgently need a convenient, flexible, and powerful query tool, smartsoft fully considers the user's needs. In the design process of smartsoft software, we fully borrowed (de) Joseph. in the book "concepts and strategies of product data management principles and policies of manufacturing enterprises" Translated by Hu guoning, Xiao Tana, the author of the book on: (parts) Things characteristics table Technology (3.5.1.4.1) and (parts) the theory of classification framework (3.5.1.4.2) and the theory of query possibilities (3.5.1.4.3) extend the application of ios13584 in part management to smartsoft queries to provide more query possibilities.

____ Smarteam organizes all the data around the project, so that the operator can conveniently browse the data and find relevant documents and other information. A project represents an idea and concept. They are the highest-level classes in the data structure. Smartsoft organizes all the data around the product, allowing the operator to conveniently browse the data and find documents, product structures, processes, and other information related to the product. Products are the final result of the Project Design. They are the highest-level classes in the smartsoft data structure.

____ Product information in smartsoft can be simply understood as all technical management information contained in the main assembly drawing of a product. One Product Information corresponds to one record in the data table, as shown in. In smartsoft, there is no big difference between common data tables and product information data tables. They are only in the class (a data table in smartsoft is treated as a class and has a detailed relationship description in the rule table) attribute values are slightly different during definition. Is a sample data about product management.

____ 1,Smart Query, As shown in the left sidebar. The most frequently used query in the query process is the phase between various conditions, that is, multiple conditions are met at the same time. Smart query is designed to meet this requirement.

____ 1.1, A, and B are the first and second classifications of all data tables that can be queried by the current user. This allows the user to manage the data tables to be queried more reasonably according to their own classification requirements. Smartsoft dynamically loads data. Therefore, the query and management capabilities of smartsoft on data tables are theoretically unlimited and only related to computers.

____ 1.2, C, and D are used to adjust the label width of the current query field and the width of the input box to make the layout more reasonable. This setting is unique to each user and query table and is a personalized setting. You can customize the query fields as needed.

____ 1.3 and E are the query input boxes. You can set prefix match (like a %), suffix match (like % A), and intermediate match (like % A %) for sorted queries) and equal to (= A) Four query matching modes. If two strings are separated by ";" in the condition input box, the two conditions are expressed as or. For date and number query fields: if only the input box on the left is <=, only the input box on the right is> =, and the input between the two sides is between this value. If multiple fields contain input conditions, these fields are related to operations.

____Ii. automatically filter rows. At the top of the data table view, each field has a line input box (shown in H), which automatically filters rows. The operator can directly enter the query conditions in the corresponding input box below the field to be queried. The query results can be dynamically displayed in the data table view, as shown in.

____3. Filter panel. When the operator enters a filtering condition in the automatic filtering box, it is automatically displayed in the filtering panel, as shown in.

____4. Filter condition editor.

____5. User-Defined filtering dialog box.

Subscribe to mysmartsoft Visit this forum