Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

The MAGNET Data Grid is a powerful tool that allows for the easy access to any information available within the current module. This Data Grid allows for powerful search and reporting functionality, that will be highlighted in this section.

...

Scroll title
titleExample Data Grid, from Business License module

Anatomy

The MAGNET Data Grid has several general features, functions or options that are generally consistent for each module in the MAGNET system. While some of the functionalities may differ slightly, this section will provide a general overview of all the items.

Data Grid Tabs

The Data Grid tabs are found above the Data Grid as highlighted in the image below. These tabs allow for high level filtering of the data, typically including tabs for Active cases, Inactive Cases, as well as when available a Reporting tab to access the departments “One Click Reports”.

Scroll title
titleData Grid Tabs

Data Grid Actions

Located above the Data Grid to the right, there Data Grid Actions, as highlighted in the image below, allow for the creation of new applications, exporting of the Datagrid and managing the columns currently shown in the Data Grid.

Scroll title
titleData Grid Actions

Standard Actions

  • Create Case

    • The new case button will typically be the first action button available and will typically be labeled based on the current module, such as the example above “New License Application”.

    • Clicking on this action will display the new case creation wizard and allow a user to enter details for a new case.

  • Generate Template

    • The Generate Template action allows for generating one of the predefined system templates(if available), while using the information available in the Data Grid.

    • This allows for a user to search for certain criteria and generate letters to only the cases meeting the entered criteria.

  • Generate Mailing Labels

    • The Generate Mailing Labels action allows for generating mailing labels on standard Avery 5160 labels for any of the cases in the current Data Grid.

  • Create PDF / Create Excel

    • The MAGNET Data Grid is a powerful reporting tool that allows for users to create custom reports based on any available data in the MAGNET system. After filtering the data to the needed information, MAGNET allows for all the current information in the Data Grid to be exported in either PDF format or Excel.

  • Edit Columns

    • The Edit Columns action allows a user to control which columns are currently displayed in their Data Grid. This allows for enhanced reporting, as well as additional filtering options.

Module Actions

Depending on the module being accessed, other Data Grid options may be available. These options include actions such as “Express Payment”, “Bulk Renewal”, etc. and will be explained in more detail for the modules utilizing these actions.

Data Grid Searching

Above each column in the Data Grid, there will be a text field that allows for the searching or limiting of data within the Data Grid.

...

Each fields supports “auto suggest” functionality, which will suggest options to you as you begin to type, additionally, the MAGNET Data Grid supports many data filters which give the user complete control over the data they are viewing or reporting on.

Data Grid filters

Operator

Description

Example

THRU

Used to search for the data range.​

12/1/2025 THRU 12/31/2025​

AND

Searches for two terms in the column.​

Building AND Demolition​

TODAY

Filters to today’s date.

Note

This only works in date fields.​

TODAY​

<

Used to find the values that are less than the value entered.​

< 100

>

Used to find the values that are greater than the value entered.​

> 500

<=

Used to find the values that are less than OR EQUAL TO the value entered.​

<= 500

>=

Used to find the values that are greater than OR EQUAL TO the value entered.​

>= 10000

%

Used as a wildcard character.​

Fes%val

IS BLANK

Returns all the rows where this column is empty.​

IS BLANK

NOT BLANK

Returns all the rows where this column is not empty.​

NOT BLANK

IS

Used to search for exact matches. Helpful for finding specific statuses.

Info

This can be useful for limiting to specific statuses that have similar labels, such as “Active” and “Inactive”

IS Active

Views

The MAGNET Data Grid allows for users to save their filters or other changed that they have made to the Data Grid, to make pulling back up previous filters or reports simple. In MAGNET, these saved Data Grid filters are called “Views”.

...

Scroll title
titleAvailable View options after selecting a View

View Management Buttons

Depending on the state of your current Data Grid, one or more of the following buttons will be available.

...

Scroll title
titleThe initial dialog after selecting the "Mage Views" button

Managing Views

After selecting the Manage Views button, the View Management dialog will appear. From this dialog you are able to select any existing view and make changes to it or delete it.

Note

Only Views created by you can be managed from this dialog. If you have any shared Views, changes to those Views can only be made by the user that created the View

View Options

When creating or managing a View, in addition to setting the name of the View, you will also have access to one or more of the following options.

...