Fetch is PensionPro's data query tool. The Fetch querying tool acts as an open database where users who are given access can create customized queries of their PensionPro data. All queries created in Fetch can be saved, shared, and exported to multiple formats. The File Menu allows easy access to saved queries, the saving of new queries and to the program options.
Tier Availability: Business
Security Rights Required: Access Query Tool
Article Contents
- Accessing Fetch
- Creating and Editing a Query
- Overview Window
- Column Selections
- Ordering & Sorts
- Filtering
- Using the Toolbar
- Using the Action Menu
- Frequently Asked Questions
Accessing Fetch
Security Rights Needed
Users will need the Access Query Tool Security Right to access Fetch. Fetch acts as an open database to users allowing access to all of their firm's data in PensionPro. For steps on how to add security rights to employees, please review Security Rights & Security Roles.
Access from PensionPro
Fetch users can access Fetch directly from PensionPro from the Power Tools menu. Users accessing Fetch in this manner will need the Access Query Tool, and Access Power Tools security rights.
- From the Navigation Panel, click Power Tools > Fetch.
- Fetch will open in a new tab within the user's web browser.
Website Access
Users can access Fetch on the web, using this URL: https://fetch.pensionpro.com
Log Into Fetch
- Open the Fetch website.
- The user should enter their username in the Username field.
- This is the same username the user logs into PensionPro with.
- The user should enter their password in the Password field.
- This is the same password the user logs into PensionPro with.
- Users will have the ability to show or hide password inputs.
- Click the Log In button.
When users log into Fetch, they should use the same login credentials they use to log into PensionPro. These credentials are linked between both PensionPro and Fetch. Should a user reset their password for either application, the user should use their new password to log into both applications.
Reset Password
- Click the Reset Password link on the Fetch login page.
- The user should enter their username in the Username field.
- This is the same username the user logs into PensionPro with.
- Click Reset Password
- A temporary password will be sent to the email address associated with the username entered. The email will come from no-reply@devapps.pensionpro.com.
- Carefully copy the temporary password from the email and paste it into the Password field of the Fetch Login page.
- The user can enter their username and click the Login button that appears.
- The user will be prompted to create a new password. Enter and confirm the new password and click Update.
- Passwords need to be 8 characters with 3 of 4 of the following: uppercase letter, lowercase letter, number, and symbol.
Creating and Editing a Query
Users open Fetch to a blank query upon login. Users can click on the Personal Queries or Shared Queries to open a previously saved query or click the Add New Query icon. Users can then use the Overview, Column Selections, Ordering & Sorts, and Filtering windows to create and maintain their query.
Open a New Query
- Click the Add New Query icon.
- An Add a new query slider will appear.
- Enter a name for the query in the Name field.
- Enter a description for the query in the Description field.
- Select a repository for the query.
- Users can select "My queries" or "Shared queries" to save the query as a personal or shared query respectively.
- Click Save.
- The new query's name, description, and repository will appear in the Overview window of Fetch.
Open a Previously Saved Query
- Click the Personal or Shared Queries icon.
- Click on a Personal or Shared Query to open it.
- The query will load onto the Fetch site.
Overview Window
The Overview window is where users can edit the name, description, and repository of the query. Users can hide or display the Overview window by clicking the collapse icon on the right side of the Overview header. Simply click on an Overview field to edit it.
Column Selections
The Column Selections window is where users can select the fields they want to appear in their query. Users can hide or display the Column Selections window by clicking the collapse icon on the right side of the Column Selections header.
The Column Selections window contains the “tree” of fields that are available to be selected. The fields selected will be returned in the Result tab as columns of data. Users can select field by checking the box to the left of the field name.
When a column field is selected, the selected field will appear in the Ordering & Sorts window of Fetch. The selected field will also be available in the Filtering window as a field that can be filtered.
Selecting Fields
- Expand Field Selections to the level of data desired in the Column Selections window.
- Place a checkmark in the checkbox to the left of the field name to include the field in the query.
Null Fields
Each time a node is expanded, a (+) or a (-) symbol is shown to the right of the node name. This determines how the records in that node will be returned in the query. For example, if the user selects two fields, Plan Name, and Project Name, with an option of minus on the Projects node, only plans that have projects will be returned. However, if the plus option is chosen on the Projects node, all plans will be returned, but some might contain a blank for the Project Name because there are no projects in the system for that plan.
Ordering & Sorts
The Ordering & Sorts window is where users can refine their query by reordering field columns, add sorting and select whether to display a column or not. Users can hide or display the Ordering & Sorts window by clicking the collapse icon on the right side of the Ordering & Sorts header.
Ordering
Users can click and drag the six-dot toggle to the left of the field name in the Column bar to re-order their field columns for their results.
- Click the six-dot icon to the left of the field name under the Column header of the Ordering & Sorts window.
- Drag the field to the desired column location. Fields displayed from top to bottom of the column header will appear left to right on the query results page.
Sort type\Order
Users can add sorting to their query by clicking the Sort type\Order icon to the right of the field name in the Ordering and Sorts window.
- Click the Sort type\Order icon to the right of the field name in the Ordering & Sorts window to add sorting to the field.
- Users can then add a sort type, change sort order, and select whether to show the column in the query results.
- Toggle Sort Type: Users can toggle through No Sort Type, Ascending, or Descending sort selections by clicking on the Sort type\Order icon.
- Change Sort Order: If multiple fields have sorting added, users can click the Order arrow icons or enter a number in the window to the right of the sort selection to update the order fields are sorted.
Show Column
Users can click on the On/Off toggle to select whether or not the field is displayed
Filtering
The Filtering window is where users can add filters to fields to enhance their query and limit results. Users can hide or display the Filtering window by clicking the collapse icon on the right side of the Filtering header.
Add Filters
- In the Filtering window, click the(+)Add new rule icon to add a filter.
- Select a field to filter on in the Column section dropdown.
- Select an operator to filter by in the Operator column dropdown.
- Select a value to filter by for this filter in the Value column dropdown.
Add Filter Groups
Users can add filter groups to control how their filters are utilized.
- Click the Add new group icon to add a new filter group.
- An And/Or toggle will appear.
- Selecting And will control results so that they must adhere to each of the filters entered below the And Filter Group.
- Selecting Or will control results so that they must adhere to any of the filters entered below the Or Filter Group.
- Users can add additional filters under the Filter Group.
Using the Toolbar
The toolbar can be found in the grey bar to the left of the Fetch. The toolbar is where users can access their profile, Library Queries, Shared Queries, Personal Queries, and add new queries.
Profile
The Profile is where Fetch users can view their Login name, change their password, update their color scheme for Fetch, and provide feedback on Fetch.
Click the Profile icon in the lower left hand corner of the toolbar.
-
Change Password
- Click the Change Password link.
- The user should enter their current password in the Password field.
- The user should enter their new password in the New Password field and confirm that password in the Confirm New Password Field.
- Click Save
- The user can Cancel if necessary.
- The new password entered will be what the user logs into PensionPro with in addition to Fetch.
-
Update Color Scheme
- Users can click the Color Scheme dropdown to change the shading of the Fetch Website.
- Selections include light and dark.
-
Give Feedback
- Click on the Give Feedback link to provide PensionPro with feedback on the Fetch App.
- Enter a comment in the Comment section.
- Click Submit.
Library Queries
The Library Queries icon is where users can access pre-made queries that may be useful or provide a starting point for users to update to their needs. PensionPro is currently developing a library of queries to be selected from this menu.
- Click the Library Queries icon.
- Click on a query to open it.
Shared Queries
Queries saved as Shared Queries will appear in this menu. These queries can be edited by any Fetch user in the user's firm. Users may want to keep a copy of a shared query as a backup by saving the copy as a Personal Query.
- Click the Shared Queries icon.
- Click on a Shared Query to open it.
- Shared Queries saved on the desktop version of Fetch will appear here.
- The query will load onto the Fetch site.
Personal Queries
Queries saved as Personal Queries will appear in this menu. Personal Queries saved by the user are only accessible to that user.
- Click the Personal Queries icon.
- Click on a Personal Query to open it.
- Personal Queries saved on the desktop version of Fetch will appear here.
- The query will load onto the Fetch Site.
Add Query
Users can click the Add icon to start a new query.
- Click the Add Query icon.
- An Add a new query slider will appear.
- Enter a name for the query in the Name field.
- Enter a description for the query in the Description field.
- Select a repository for the query.
- Users can select My queries or Shared queries to save the query as a personal or shared query respectively.
- Click Save.
Using the Action Menu
The Action menu is the bar at the top of the Fetch screen that allows users to run, save, or perform other actions for their query.
Execute a Query
Once users create their query, they can execute the query to see their results. Simply click the Execute query icon at the top of the Fetch screen.
- Click the Execute Query icon.
- Fetch will open to the Query Results page.
- The results page displays up to 100 records per page.
- Return to Query Builder: Users can click the Back icon to return to the Query Builder.
-
Export Query Results: Users can click the Export Query Results icon to export their query results to xls, xlsx, or csv file formats.
- Click the Export Query Results icon.
- Enter a File Name for the exported results in the File Name field.
- Select an extension. Users can export their query results to xls, xlsx, or csv file formats.
- Click Export. The file will download from the user's default browser.
Save a Query
Once a user creates their new query, they can save the query. Simply click the Save Query icon. The Query will save based on the parameters laid out in the Overview window.
Duplicate a Query
Users can duplicate an open query to copy it.
- Open a Query.
- Click the Action icon (three dots) from the Action menu.
- Click Duplicate.
- A popup will appear. The duplicated query name will default to the name of the duplicated query with "Copy" appended to the end of the original query name.
- Click Duplicate.
Delete a Query
Users can delete a saved query.
- Open a Query.
- Click the Action icon (three dots) from the Action menu.
- Click Delete.
- A popup will appear. Click Yes, Delete to confirm deletion.
Clear Columns
The Clear Columns icon will clear any and all selected columns from the query. Doing so will remove all filtering and orderings as well.
- Open a Query.
- Click the Action icon (three dots) from the Action menu.
- Click Clear Columns.
- A popup will appear. Click Ok to confirm.
Clear Filters
The Clear Filters icon will remove any filters the user had in their query.
- Open a Query.
- Click the Action icon (three dots) from the Action menu.
- Click Clear Filters.
Clear Order and Sorts
The Clear order and sorts icon will remove any selected order or sort options selected for the query.
- Open a Query.
- Click the Action icon (three dots) from the Action menu.
- Click Clear order and Sorts.
Help
Should users need more information on Fetch, they can click the (?)Help icon to open the Help Center and link to Fetch articles.
Frequently Asked Questions
-
Is it possible to filter on a field selection, but hide the field in the report so it doesn't display in the results?
Yes. To add a field as a filter without displaying it in the report, Select a field from the Column Selections window and click the Show Column toggle to Off on the Ordering and Sorts window. The user can then select that field in the Filters window as a selection without the field appearing as a column in the query results.
-
Can I grant access for some users to view shared queries, but not others?
Currently, any user that has access to Fetch can view and edit shared queries. The only way to restrict access to a saved query is to save it as a Personal Query.
-
Can I control who has rights to edit a shared query?
Currently, any user that has access to Fetch can edit a shared query. There isn't a separate right to control which users can edit a shared query.
-
Can the Fetch queries be made to look more like the standard reports in PensionPro?
Currently Fetch does not display the color format, date generated and title as seen in the standard PensionPro reports. Users can export the Fetch results to excel and format the report as desired.
-
I cannot find To-Dos in Fetch, where are they located in the Fetch "tree?"
To-Dos are not currently included in Fetch.
-
Why are the Task Item values not appearing for the Projects I am reporting on?
The only way to view answers to Task Items in a report or within Fetch is if the Task Item is tagged as a Project Field. Fetch will not display values if the Task Item is not set up as a Project Field. For more information on Project Fields, please review Using Project Fields.