Basic Search Option: Search by parameters such as Access Group Name, Description, Folder Name, Owner, Query Name, Type, Uses Field Name or Uses Record Name. Searching by Query Name or Description is most common. This search uses the “begins with” condition. Advanced Search Option: Search using one or more search criteria and selecting from a choice of conditions for each criterion (e.g., “contains”). You can use Wildcards (%) in many of the fields to refine or broaden a search. Query Naming Conventions To use a query to retrieve data from SWIFT, you will need to know its name or a part of its name. The naming convention for SWIFT is M_XX_GBL… M is for Minnesota. XX represents the two-letter SWIFT module abbreviation (e.g., SC for Supplier Contracts). GBL is for Global. It displays if all users have access to this query. Characters that appear after XX or GBL describe the kind of data the query will locate. For example, the query M_PO_DEFAULTS_BY_VENDOR will show information associated with the Vendor. You must use capital letters and the underscore symbol. Common Queries for Sourcing Module Query Name Purpose M_SS_BID_RESONSE_VERSION_1 List of vendors who bid on an event and their response status. M_SS_GBL_EVENT_ANALYSIS List of events by business unit and their statuses and responses. M_VENDOR_INQUIRY Allows you to look up information about a particular vendor (e.g., Vendor ID, Location Code, active and approved statuses, etc.). Process Steps for Using the Query Viewer Step 1: Enter Information into the Query Viewer. Navigation: Reporting Tools, Query, Query Viewer Searching by Query Name or Description is most common. On the Basic Search, enter the query name. It must follow the naming conventions. Click Search.
Basic Search Option: Search by parameters such as Access Group Name, Description, Folder Name, Owner, Query Name, Type, Uses Field Name or Uses Record Name. Searching by Query Name or Description is most common. This search uses the “begins with” condition. Advanced Search Option: Search using one or more search criteria and selecting from a choice of conditions for each criterion (e.g., “contains”). You can use Wildcards (%) in many of the fields to refine or broaden a search. Query Naming Conventions To use a query to retrieve data from SWIFT, you will need to know its name or a part of its name. The naming convention for SWIFT is M_XX_GBL… M is for Minnesota. XX represents the two-letter SWIFT module abbreviation (e.g., SC for Supplier Contracts). GBL is for Global. It displays if all users have access to this query. Characters that appear after XX or GBL describe the kind of data the query will locate. For example, the query M_PO_DEFAULTS_BY_VENDOR will show information associated with the Vendor. You must use capital letters and the underscore symbol. Common Queries for Sourcing Module Query Name Purpose M_SS_BID_RESONSE_VERSION_1 List of vendors who bid on an event and their response status. M_SS_GBL_EVENT_ANALYSIS List of events by business unit and their statuses and responses. M_VENDOR_INQUIRY Allows you to look up information about a particular vendor (e.g., Vendor ID, Location Code, active and approved statuses, etc.). Process Steps for Using the Query Viewer Step 1: Enter Information into the Query Viewer. Navigation: Reporting Tools, Query, Query Viewer Searching by Query Name or Description is most common. On the Basic Search, enter the query name. It must follow the naming conventions. Click Search.
swift-ss1-user-guide-for-acquisitions.docx