Asset Search

Before you apply filters to a view select the columns you would like to display in the results. To do this select the cog icon on the right hand side above the results. You can add or remove columns or rearrange by dragging the options into the correct order. 

Service Date

Select the asset search tab and add the service date using the cog icon on the search.

You can select the service date column name to order the results. You will see the arrow change to be a up or down depending on your choice. 

No Service Date

This example will show assets that do not have a service date. You can add in the following statement into the advanced search field. siteServiceDateAttribute is null

Service Dates Within 30 Days

You can review what sites/assets need to be serviced within the next 30 days. You can alter the dtoff(-3265d) and (-335d) to match the number of days you would like to display in the view. Example 60-90 days would be dtoff(-305d) and (-275d)

siteServiceDateAttribute > dtoff(-365d) and siteServiceDateAttribute <= dtoff(-335d) order by siteServiceDateAttribute asc 

Service Dates Due in 30-60 Days 

You can review what sites/assets need to be serviced within 30-60 days. You can alter the dtoff(-3265d) and (-335d) to match the number of days you would like to display in the view.

siteServiceDateAttribute > dtoff(-335d) and siteServiceDateAttribute <= dtoff(-305d) order by siteServiceDateAttribute asc

Filtering by Manufacturer 

Using the basic screen you can create manufacturer views, You can select manufacturer and model to define the results