Filters: Difference between revisions

From RangerMSP Wiki - PSA software for MSPs and IT services providers
Jump to navigation Jump to search
No edit summary
No edit summary
 
(17 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Filters in CommitCRM allow you to define advanced search rules that can be applied for Accounts, Tickets, Charges, Items, etc. You can define the filter, save it easily and use it later to  filter lists.
Filters in RangerMSP allow you to define advanced search rules that can be applied for Accounts, Tickets, Charges, Items, etc. You can define the filter, save it easily and use it later to  filter lists.
<br>
==Create New Filter==
The Filter option is available in each window, in the left-top corner of the window:<br><br>


The Filter option is available in each window, in the left-top corner of the window:<br>
[[File:Filter-drop-down-menu.png]]


[[File:Filter-drop-down-menu.png|center]]
<br><br>
==Create New Filter==
To create a new filter you can use one of the options:
To create a new filter you can use one of the options:


Line 18: Line 18:
#Choose the fields you want to filter by and their values.
#Choose the fields you want to filter by and their values.
#You can add lines where each line is calculated according to the logical term (AND/OR) in the beginning of the line.
#You can add lines where each line is calculated according to the logical term (AND/OR) in the beginning of the line.
#You can use the By Subject and Secondary Filter (advanced) options. See more details below.
#You can use the [[Filters#By_Subject_.28filtering_by_user-defined_fields.29|By Subject]]  and [[Filters#Secondary_Filter_.28filtering_linked_data.29|Secondary Filter]] options. See more details below.
#You can choose to sort the results using the Sort fields at the bottom of the window.
#You can choose to sort the results using the Sort fields at the bottom of the window.
#Click OK to finish.<br>
#Click OK to finish.
#Note that in order to save the filter, you should use the Save option. See more details in [[Filters#Saving_Filters|Saving Filters]].<br>
[[File:Filter-new.png]]
[[File:Filter-new.png]]
<br>
<br>
<br>
<br>
===New from Template===
===New from Template===
Use predefined templates to create a filter. This will automatically define the fields and values for the search. These settings can be modified once the template is selected.
Use predefined templates to create a filter. This will automatically define the fields and values for the search. These settings can be modified once the template is selected.
Line 32: Line 34:
*Tickets which are open over 24 hours.
*Tickets which are open over 24 hours.
*Open Tickets without any logged charges.
*Open Tickets without any logged charges.
 
<br>
To create from template:
To create from template:
#Select New from Template
#Select New from Template
#Choose the filter template you want to apply, and click Next. <br>
#Choose the filter template you want to apply, and click Next. <br>[[File:Filter-new-from-template.png]]<br>
[[File:Filter-new-from-template.png]]<br>
#In the next step, the [[Filters#New Template|New Template]] window opens, however, there are already predefined fields selected for this filter, as defined in the template. In this window you can modify the search criteria if needed (see [[Filters#New Template|New Template]] ). <br>[[File:Filter-from-template-criteria-window.png]]
#In the next step, the New Template window opens and you can modify the search criteria if needed (see New Template).  
<br>
#Then and click OK.
<br>
 
===Saving Filters===
While a new filter is being used without saving yet, the menu looks like this:<br><br>
[[File:Filter-unsaves-drop-down-menu.png]]
<br><br>
The pause and delete options provide a quick way to stop the filter from affecting the list. These options will appear when hovering over the (Unsaved) label. At this stage, you can use the filter, pause it and edit it, however, it will not be saved until you actually save it.
<br><br>
To save the filter for future use:
#From the Filter menu, choose Save
#The Save window opens<br>[[File:Filter-save-window.png]]
#Enter a name for this filter
#Choose whether you want to share this filter with other users
#Click OK to save.
#The filter is now available in the filter drop-down menu.
<br>
<br>
<br>
===By Subject (filtering by user-defined fields)===
===By Subject (filtering by user-defined fields)===
For entities that have user-defined fields, you can use the "By Subject" tab which allows you to filter according to the user-defined fields. Here you can choose the subject you want to filter by, and this will give you the relevant field list for this subject. A subject is basically a fields-group, which can be defined when adding new fields. For more details about adding your own fields, [[Field_Customization|click here]].
For entities that have user-defined fields, you can use the "By Subject" tab which allows you to filter according to the user-defined fields. Here you can choose the subject you want to filter by, and this will give you the relevant field list for this subject. A subject is basically a fields-group, which can be defined when adding new fields. For more details about adding your own fields, [[Field_Customization|click here]].
Line 55: Line 73:
*Filter Tickets to only show Tickets linked to Assets whose warranty has expired.
*Filter Tickets to only show Tickets linked to Assets whose warranty has expired.
*Filter Opportunities to only show Opportunities of Accounts that I am assigned to as the manager.
*Filter Opportunities to only show Opportunities of Accounts that I am assigned to as the manager.
<br>
<br>
To use the secondary filter:
To use the secondary filter:
#Create a New filter
#Create a [[Filters#New_Filter|New filter]]
#Selecting the Secondary Filter Tab.
#Selecting the Secondary Filter Tab.
#The available data sources appear. Each has a Filter button.
#The available data sources appear. Each has a Filter button.
Line 64: Line 82:
#The chosen filter now shows (Filter Active)<br>
#The chosen filter now shows (Filter Active)<br>
[[File:Filter-secondary-filter-window.png]]<br>
[[File:Filter-secondary-filter-window.png]]<br>


<br>
<br>
===Sorting===
The advanced sorting feature allows you to reorganize the data displayed in the list to be sorted to your needs. Advanced Sorting - sort the results by three levels, by choosing the fields to sort by.




==Advanced Queries==
When creating a Filter from templates, some of the templates are marked with (*), marking them as  “advanced”. These templates are system-defined templates and use advanced queries on data related to the entity. These queries cannot be defined manually, however, users can define the search criteria in the next window.
For example:<br>
[[File:Filter-new-template-advanced.png]]
<br>
<br>
===Non-Expiry Search Options===
 
==Non-Expiry Search Options==
When defining filters which are date-time based, such as by Ticket Due Date or Creation Date, etc. you can use non-expiring conditions, which are always relevant to the day you activate the filter.
When defining filters which are date-time based, such as by Ticket Due Date or Creation Date, etc. you can use non-expiring conditions, which are always relevant to the day you activate the filter.
For example, saved filters that can be used everyday:
For example, saved filters that can be used everyday:
Line 80: Line 100:
*Assets expiring next month.
*Assets expiring next month.


<br>
==Renaming Filter==
===Advanced Queries===
Once a filter is saved, you can rename it by using a special option.
Note that some of the templates are marked with (*), marking them as  “advanced”. These templates are system-defined templates and use advanced queries on data related to the entity. These queries cannot be defined manually, however, users can define the search criteria in the next window.  
To rename a filter:
For example:<br>
#Choose the filter from the filters list.
[[File:Filter-new-template-advanced.png]]
#Select Filter > Rename/Share <br>[[File:Filter-rename-menu-option.png]]
<br>
#The following window opens:<br>[[File:Filter-rename-window.png]]
==Saving Filters==
#Enter the new name in the Name field.
While a new filter is being used without saving yet, the menu looks like this:
#Click OK to finish.
[[File:Filter-unsaves-drop-down-menu.png]]
 
<br>
==Sharing Filter With Other Users==
The pause and delete options provide a quick way to stop the filter from affecting the list. These options will appear when hovering over the (Unsaved) label.  
Filters can be shared so that other users can enjoy the already defined filters.
At this stage, the drop-down menu now includes also the following options:
When saving the filter for the first time, you can also set the sharing options in the new filter window. See [[Filters#Saving_Filters|Saving Filters]] for more details.
#Edit
#Save
To share an existing filter:
#Pause
#Choose the filter from the filters list.
#Close
#Select Filter > Rename/Share <br> [[File:Filter-rename-menu-option.png]]
<br>
#The following window opens: <br> [[File:Filter-sharing-window.png]]
==Share Filter With Other Users==
Filters can be shared by users so that other users can enjoy the already defined filters.
To share your filters:
#Select Filter > Rename/Share
[[File:Filter-rename-menu-option.png]]
#The following window opens:
[[File:Filter-sharing-window.png]]
#Choose Everyone to share your filter. Note that only users with “Save Filter” privileges can edit the filter. See more details in [[Employee_Privileges|Employee Privileges]].
#Choose Everyone to share your filter. Note that only users with “Save Filter” privileges can edit the filter. See more details in [[Employee_Privileges|Employee Privileges]].
#Click OK to finish.
#Click OK to finish.

Latest revision as of 08:11, 8 July 2020

Filters in RangerMSP allow you to define advanced search rules that can be applied for Accounts, Tickets, Charges, Items, etc. You can define the filter, save it easily and use it later to filter lists.

Create New Filter

The Filter option is available in each window, in the left-top corner of the window:

To create a new filter you can use one of the options:

  • New - create new filter from scratch.
  • New from template - use predefined template to create a filter. This will automatically define the fields and values for the search. These settings can be modified once the template is selected



New Filter

To create a new filter:

  1. Select Filter > New.
  2. Choose the fields you want to filter by and their values.
  3. You can add lines where each line is calculated according to the logical term (AND/OR) in the beginning of the line.
  4. You can use the By Subject and Secondary Filter options. See more details below.
  5. You can choose to sort the results using the Sort fields at the bottom of the window.
  6. Click OK to finish.
  7. Note that in order to save the filter, you should use the Save option. See more details in Saving Filters.



New from Template

Use predefined templates to create a filter. This will automatically define the fields and values for the search. These settings can be modified once the template is selected.

Examples for templates:

  • Accounts with Assets expiring next month.
  • Accounts with expiring Contracts.
  • Tickets which are open over 24 hours.
  • Open Tickets without any logged charges.


To create from template:

  1. Select New from Template
  2. Choose the filter template you want to apply, and click Next.

  3. In the next step, the New Template window opens, however, there are already predefined fields selected for this filter, as defined in the template. In this window you can modify the search criteria if needed (see New Template ).



Saving Filters

While a new filter is being used without saving yet, the menu looks like this:



The pause and delete options provide a quick way to stop the filter from affecting the list. These options will appear when hovering over the (Unsaved) label. At this stage, you can use the filter, pause it and edit it, however, it will not be saved until you actually save it.

To save the filter for future use:

  1. From the Filter menu, choose Save
  2. The Save window opens
  3. Enter a name for this filter
  4. Choose whether you want to share this filter with other users
  5. Click OK to save.
  6. The filter is now available in the filter drop-down menu.



By Subject (filtering by user-defined fields)

For entities that have user-defined fields, you can use the "By Subject" tab which allows you to filter according to the user-defined fields. Here you can choose the subject you want to filter by, and this will give you the relevant field list for this subject. A subject is basically a fields-group, which can be defined when adding new fields. For more details about adding your own fields, click here.

Secondary Filter (filtering linked data)

The secondary filters allow you to create super-advanced filters on the results, and narrow down the results to exactly what you want to see. For example, you can filter Charges, and narrow the results by specific ticket type, which reflects the type of problem (i.e. printer, mobile phone, laptop etc.,). This feature is quite powerful and provides great analytic possibilities.
Other examples:

  • Filter Tickets to display only Tickets related to Accounts to which a specific Employee is assigned.
  • Filter Charges to display all Charges logged for Block of Time Contracts that belong to Accounts which are assigned to a specific Employee.
  • Filter Charges to display only Charges for Completed Tickets that belong to Accounts of the type 'Law Office'.
  • Filter Tickets to only display Tickets of VIP Accounts.
  • Filter Charges to only show Charges related to Block of Time Contracts.
  • Filter Tickets to only show Tickets linked to Assets whose warranty has expired.
  • Filter Opportunities to only show Opportunities of Accounts that I am assigned to as the manager.


To use the secondary filter:

  1. Create a New filter
  2. Selecting the Secondary Filter Tab.
  3. The available data sources appear. Each has a Filter button.
  4. Click Filter for data sources you want to filter and define the filters in the window that opens.
  5. Click OK.
  6. The chosen filter now shows (Filter Active)




Advanced Queries

When creating a Filter from templates, some of the templates are marked with (*), marking them as “advanced”. These templates are system-defined templates and use advanced queries on data related to the entity. These queries cannot be defined manually, however, users can define the search criteria in the next window. For example:

Non-Expiry Search Options

When defining filters which are date-time based, such as by Ticket Due Date or Creation Date, etc. you can use non-expiring conditions, which are always relevant to the day you activate the filter. For example, saved filters that can be used everyday:

  • Tickets created yesterday.
  • Tickets that are due tomorrow.
  • Contracts that expire this week.
  • Assets expiring next month.

Renaming Filter

Once a filter is saved, you can rename it by using a special option. To rename a filter:

  1. Choose the filter from the filters list.
  2. Select Filter > Rename/Share
  3. The following window opens:
  4. Enter the new name in the Name field.
  5. Click OK to finish.

Sharing Filter With Other Users

Filters can be shared so that other users can enjoy the already defined filters. When saving the filter for the first time, you can also set the sharing options in the new filter window. See Saving Filters for more details.

To share an existing filter:

  1. Choose the filter from the filters list.
  2. Select Filter > Rename/Share
  3. The following window opens:
  4. Choose Everyone to share your filter. Note that only users with “Save Filter” privileges can edit the filter. See more details in Employee Privileges.
  5. Click OK to finish.