AR – Search to Load Data (101-ar-fea-026)

Accounts Receivable (A/R) Search to Load Feature

Available in Govern Rel. 6.0/6.1

Overview

Selecting a Record Key from the DataSet TreeView will load AR Data, the form also has a feature that allows you to search for keys to load the data. The key is then sent to the TreeView as a Temporary Key to allow the application to recalculate information based on that key.

Demonstration of the Temporary Key

To demonstrate the functioning of a Temporary key in Govern, follow these steps:
Preparatory steps:
  1. Search for a few records to add to the Treeview from the eSearch then open the AR Inquiry form.
  2. Search for a key that contains a field that is of the same type as the profile and is already in the Treeview. It gets selected.
  3. Perform Step 1) but for a key that isn’t in the Treeview already. It gets added, selected, 1st and orange background.
  4. Perform Step 2). the key added by 2) gets replaced by this new one.
  5. Repeat Step 1). notice that the same result and the one added in Step 3) remains.
  6. Perform a search for a key that doesn’t contain a field that matches the Treeview key. The description is based on the Main ID of the key.
  7. Manually remove the temporary key from the Treeview and search for it again. It gets added as Temporary again.

Related Topics

 

 

101-ar-fea-026

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

MB – Search Screens

Miscellaneous Billing (MB) – Search Screens

Overview

The following covers the standard searches used for Miscellaneous Billing,

Access by

Name and Address

Govern’s Name and Address search form provides two ways of searching for Miscellaneous Billing records:

  • By returning a list of all the miscellaneous billing records sorted by the selected option, or…
  • Returning only the records associated with a specific invoice or account number

 

Read More...

Miscellaneous Billing

  • Account No.
  • Name
  • Invoice No.

 

Specific Account Search

  • Account Number: Enter the full or partial account number of the miscellaneous billing record.
  • Invoice Number: Enter the full or partial invoice number of the miscellaneous billing record.
  • Date Invoice: Double-click in the field and select the date of the record from the pop-up calendar. Add it to be a range
  • Reference: Enter the reference number of the record as entered on the Misc. Billing Invoice form.
  • Department: Department issuing
  • MB Account Category

Recurring Entries Search

  • Date From and Date End
  • Note: The use of wild card characters is permitted, however, the wild card (*) is not supported in an ORACLE environment. – To be validated
  • Recurring Batch Period
  • MB Account Category

Property Search

To link a Miscellaneous Billing Account to a property, you can find the property by the following criteria

  • Tax map number
  • Parcel ID
  • House number
  • Street name
  • Owner status

Search Result Screen

At a minimum, the search should return the following information:

  • MB Account No (MB_ID)
  • Name (NA_ID)
  • MB Account Category
  • MB Invoice No.

 

NOTE: Depending on the setup, additional fields may be displayed.

 

 

 

101-mb-fea-004

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

 

 

 

Govern Ribbon Search

Standard Feature – Ribbon Search

Release 6.0.1903.0374 (Govern only) | 6.0.1904.0515 (Govern only)
Release 6.1.1911.0497 (All applications) | 6.1.1912.0513 (All applications)

Overview

The Govern Knowledge Base (KB) Search has been incorporated into the Govern Ribbon as part of the Help online help feature. This KB Search field is visible over all Govern suite applications for release 6.1. In addition, the display of the search field is persistent even if the ribbon is minimized.

NOTE: Users must ensure that they have internet access, a compatible browser, and an active account to access to the Knowledge Base.

Configuration

Govern New Administration (GNA)

In order to display the Ribbon Search field, it is necessary for an Administrator to run the Verify Database process in the Govern New Administration (GNA).

Security Manager (SM)

It will then be necessary to have the Security option in GSM configured to allow the user to see the KB Search in the ribbon.

The security applied is the same for all applications, except for the OpenForms Designer (OFD) which does not offer a securable node.

Presentation

This KB Search is available in the following applications (for the versions 6.1.1911 and 6.1.1912 only):

  • Govern (Ribbon)
  • GNA (Ribbon)
  • GSM (Ribbon)
  • QT (Ribbon)
  • BED (ToolBar)
  • BSC (ToolBar)
  • OFD (ToolBar) – Note that the presentation of the KB Search field is slightly different in the OFD. The text label appears as KB Search in comparison to the other suite applications where the field label reads as Knowledge Base. The behavior is the same in all applications

Using the Knowledge Base (KB) Search

The steps to use the KB Search are as follows:

  1. Enter a keyword in the Search field located at the upper right-hand side of the ribbon.
  2. Press Enter or if you are using version 6.1, click on the magnifier icon.

Your default browser is launched and you will be transferred to the search page of the Govern Knowledge Base website (https://kb.harrisgovern.com/), the results of the keyword(s) you have searched for are displayed in your browser.

NOTE: This Help search field is placed at the top level of the ribbon, and it is visible when any of the top-level tabs are selected, e.g. Home, View, Options, and so on.

Related Topics

Govern Search
Govern Quick Search
Quick Search Index Group Editor
Govern Search Technical Specifications

Saved Datasets
Dynamic Search Objects
Dynamic Search Styles
Dynamic Search Groups

Govern New Administration (GNA)

 

 

101-std-fea-047

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

Govern Quick Search

Govern Quick Search

Release 6.0.1707 | 6.1 1707

Overview

An alternate search interface is available to the Govern user. The Quick Search differs from the traditional search interface in the sense that it bears a closer similarity to the search and results interface that is often associated with search engines. When correctly configured, this search interface is available through the Govern ribbon. Note that this search is in addition to the KB Search that is also located in the upper right hand corner of the interface.

NOTE: This feature should not be confused with the Self Reported Business Tax (ST) Save and Search feature, that may also be referred to as a quick search.

User Interface

Keyboard Shortcuts

The Quick Search and other search interfaces are accessible through the following keyboard shortcuts:

  • Quick Search: F3
  • Advanced Search: Alt + F3
  • Saved Datasets: Ctrl + F3
  • Query Tool: Shift + F3

Available Search Type (Views)

Standard Views are available to the user; these are part of Governs ViewsScripts.xml resource files. Standard views include a Search for Property records (V_INDEX_PROPERTY), a Search for Self Reported Tax records (V_INDEX_SRT), and a Search for Name records (V_INDEX_NAMES)

Conditions for Functioning of Views

The Quick Search is a standard Govern Control. In order for this control to function correctly, the associated views must adhere to the following standard rules:

  • The nomenclature of the View must begin with by V_INDEX_ for standard views and VW_INDEX_ for custom views
  • There must be a unique ID column
  • The View must have a Title column
  • Although the search will still search in the column, the description will use any column not ending with _h

Search results will be presented on 2 rows, the first will be the Title, the second a Description.

Configuration

The first requirement for installing the Govern Quick Search is to install the Elastic Search Service.

Installation of ElasticSearch

Details about the Elastic Search service can be found at the following link: https://www.elastic.co/guide/en/elasticsearch/reference/current/install-elasticsearch.html#install-elasticsearch
When installing with the MSI package option, you may use the following:
1. Download the MSI package and run it.

NOTE: Java is required in order for Elastic Search to run. If not installed, the installer will give a notification. If not installed, you can download the offline Java installer from the following location: https://java.com/en/download/manual.jsp. Install Java and re-execute the Elastic Search installer. Governs’ implementation of Elastic Search will support versions 11 through 15 of Java.

2. Install ElasticSearch with the default directories and ensure you select the Install as a service option. You may reference the screen shots in the Elastic Search Install Screens that can be found in the docuementation; see below.
3. For the Cluster Name you can keep the suggested name or make another selection. Note down the selected HTTP port, as it will be required later; the default is port 9200.
4. Ensure that the Network host value is completed. This is the name of the server. Note that none of the Plugins options are required.
Once the installation is completed, open Services in windows and make sure Elastic Search is configured as Automatic, and start the service.

About Java Support

As stated, Java is required in order for Elastic Search to run. Governs’ implementation of Elastic Search will support versions 11 through 15 of Java.

Configuration in the Govern New Administration (GNA)

GNA – General Settings Editor

For the next step, additional configuration is required in GNA. Open the GNA application…

  1. Open the General Settings Editor.
  2. Select General as the Registry Filter, and in the Search section locate the Elastic Search URL key. Enter a value like http:servername:9200, where the servername is that of the server where the service is installed, 9200 is the port that was chosen during the installation; Step 3// above.

GNA – Profile Editor

Index Refresh Batch Process

In order to have access to the Quick Search, you will need to setup and run the Quick Search Refresh (101-std-bp-010) batch process. This batch process is used to rebuild indexes used by the quick search. If this batch process is not present in the list under the Batch Processes tab in Govern, it will need to be added to the profile. This is done through the GNA Profile Editor. Refer to the Profile Editor page for instructions on how to add a batch process.
In Govern, by default, after running the Verify Database Process, the batch definition and the schedule to run the batch process is generated. The batch process is scheduled to run once a day in Full Mode, and every 5 minutes in Refresh Mode.
The batch process will search for all views created in the database that begin with V_INDEX or VW_INDEX, and refreshing them using the buffer parameter. Alternatively the process will completely build, or if already existing, rebuild the indexes.

Search Parameters

There are three (3) Search parameters that are required to be configured in the GNA Profile Editor.

Configuration of Profile Editor Search group parameters

Default eStyle – Selecting an eStyle will remove the selected eGroup.
Default eGroup – When an eGroup is selected, it will remove the selected eStyle.
Quick Search Index Group – The Quick Search Group is used for the Quick Search of the Profile.
NOTE: Additional Quick Search Index groups can be created using the Quick Search Index Group Editor.
When saving the profile, at least one of the searches must be selected.

NOTE: When exporting and importing a profile, indexes from the Quick Search Group associated with a Profile will be automatically exported/imported.

Govern Security Manager (GSM)

In order to provide security parameters for this feature, there is a new node for the Quick Search in the Govern Security Manager (GSM).
To locate the node to secure in the GSM, in the left hand pane, select Applications > Govern > Menu > View > Data Sources > Quick Search. Refer to the GSM page for instructions on how to secure an application.
When security is not enabled, i.e. OFF, Govern users will not see the Quick Search icon in the View (tab) > Data Sources (group) section in the Govern ribbon. Users without permissions that attempt to access the Quick Search, will be presented with the standard Govern restricted access screen.

Using the Quick Search

Differences between Search All vs Specific Index

The Search All option allows a user to perform a search on ALL indexes associated with the Profile. If a specific index was selected then the search will be performed only on that selected index.

NOTE: Search All will use the boost specified to an index in GNA to order the Search Results. You will see a tag to indicate which index the Search Result came from in the Search All option.

Switching between indexes

In order to switch between indexes, you must click on the index name. The currently selected index will be underlined. The index name that is displayed is the name of the view without the prefix and underscores and title cased.
For example if you create a view named VW_INDEX_COMPANY_ONLY then the display name will be Company Only.

Search within a Specific Index

Searching within a specific index allows users to restrict search results to a specific index as well allowing them to search a specific column.

Column Specific syntax

The Column Specific Search enables a user to specify on which column a text string should be search.
Syntax – Field followed by “:” then by the text string to search for.
If the user selects a specific index all available fields will be available in the search box context menu. The context menu can be displayed with a Right-Click within the area of the Search field.
For Example: the following… street:freeway
This is an indication that the text string “freeway” must be located in the street field. Therefore, even if there was a record with an email like “freeway@example.com”, the record will not be returned if the text freeway is not found in the street field.

Using special options

In addition to a normal text search, special characters such as Boolean operators or wildcards may be used to further narrow search results. Listed below are options that are available.

Operators

AND – A search for the results containing the words CRYSTAL AND LAKES. This means that result must contains both the words CRYSTAL and LAKES.
OR – Searching for results containing the words CRYSTAL OR LAKES. This means that result must contains either word, CRYSTAL or LAKES.
* (Wildcard Character) – The wildcard characteris used for performing searches for partially defined strings, e.g. RIVE*. This means that all records containing words starting with RIVE will be returned, e.g. RIVER, or RIVEN.
~ (Fuzzy Character) – The Fuzzy Character tilde (~), allows the search to be more relaxed with its results. Searching for the following string with the tilde, CRYSTEL~, will result in all records containing a word the “sort of” looks like CRYSTEL with a one character difference allowance. The resulting records could contain the following words: CRYSTEL, CRYSTAL, CYRSTEL, CRESTEL, CRYSTEN, and so on.

Clicking on a Search Result

A click on a specific search result will add the ID to the Govern Dataset Treeview, and set all Govern IDs specified by the search result. In addition, if the search result contains a field named “form“, the form with this code will also be opened.

TIP: If you want to know the origin of the information displayed in the search result, i.e. the field it is taken from, place your mouse cursor over the value and the tooltip will indicate which field it corresponds to.

Troubleshooting

Typically issues that may arise with the Govern Quick Search may be related to the installed ElasticSearch service, or port configuration issues with the Windows Firewall.

NOTE: The following troubleshooting actions can only be accomplished by users with administrator level access.

Verify ElasticSearch Service

If the Govern Quick Search is not working after configuration, the first step is to verify that the installed ElasticSearch service is running. This is done through the Windows Services screen.

Additional Verification of Service

Issues with Java

Issues have been known to arise with the setting of the variable JAVA_HOME when installing Java 32bit or 64 bit. Ensure that the correct path is being used as some applications, when installing, may set a path for the JAVA_HOME variable that may not be consistent with other installed applications.

Verify the JAVA_HOME variable

In Windows 7 on a system that had Java 1.7 then upgraded to Oracle Java 1.8 SDK (jdk-8u45-windows-x64.exe) the system JAVA_HOME differed from the JAVA_HOME in the elasticsearch manager and as such a different version of java was in the path. As a result, the ElasticSearch service install failed because the system was unable to load Java 8.
Resolution required the setting of the system JAVA_HOME to the correct folder:

  1. Open Windows File Explorer.
  2. Right-click My Computer
  3. Select Advanced system settings
  4. Select Environment Variables
  5. Select JAVA_HOME
  6. Edit JAVA_HOME to change the value to the correct root folder e.g. C:Progra~1Javajre1.8.0_45
  7. OK twice

Check that JAVA_HOME is set and java works:

  • java -version
  • echo %JAVA_HOME%

If this fails then eleasticsearch-service install won’t work. To fix in a DOS prompt:

  • set JAVA_HOME=C:Progra~1Javajre1.8.0_45
  • path=C:Program FilesJavajdk1.8.0_45bin;%path%

Check the JAVA_PATH value in Elasticsearch manager and fix it if required. Open the manager program from a DOS prompt:

  1. Run elasticsearch-service.bat manager from a DOS prompt.
  2. Click on the Java tab
  3. Click the … button to the right of %JAVA_HOME%binserverjvm.dll
  4. Select the correct JRE folder if required or set the value manually, e.g. C:Program FilesJavajdk1.8.0_45jrebinserverjvm.dll
  5. Click Apply
  6. Select the General tab
  7. Click Start.
  8. Click OK to close the ElasticSearch manager

Removing and re-adding the ElasticSearch service may be needed:

  • elasticsearch-service.bat remove
  • elasticsearch-service.bat install

Browser Verification

Open ElasticSearch in a browser using the settings in configelasticsearch.yml to check that it is running. The URL could be https://MyServer:9200. For example https://localhost:9200/
…where, depending on your configuration, “localhost” would be substituted with the name of the server that the ElasticSearch is running on.

Issues with Windows Firewall

When there are issues with configuring the ElasticSearch, these issue may exist with the Windows Firewall.

  1. When the Firewall Screen is displayed, click Show/Hide Console Tree.
  2. On the left hand pane, right click Inbound Rules and select New Rule.
  3. In the New Inbound Rule Wizard form, select Port, click Next.
  4. At the Protocol and Ports step, select TCP; click on Specific local ports and enter 9200.
  5. Click Next.
  6. At the Action step, select Allow the connection; click Next.
  7. Set the rule to apply for Domain, Private, and Public by selecting the check boxes.
  8. Click Next.
  9. At the name screen, enter a descriptive name for the rule; click Finish.

Modifying a Preexisting Rule

If a rule has already been created and it needs to be modified you can go back to the Windows Firewall screen. Typically the modification involves adding an additional port number.

  1. Open Windows Firewall.
  2. On the left hand pane, click Inbound Rules.
  3. Under the Inbound Rules pane, locate ElasticSearch Rule. Note that this is the name that was given to the rule when it was first created.
  4. Right click ElasticSearch Rule and select Properties from the floating menu.
  5. Click on the Protocol and Ports tab.
  6. Configure the Protocol type as TCP.
  7. Add another port specified for the ElasticSearch in the Local port parameter; select Specific Ports, and add 9300 to the 9200, separated by a comma and space.
  8. Click OK.

Documentation

Click here to link to the documentation for this feature:

Related Topics

Govern Search
Quick Search Index Group Editor
Govern Search Technical Specifications

Dynamic Search Objects
Dynamic Search Styles
Dynamic Search Groups
Govern New Administration (GNA)

 

 

101-std-fea-034

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

Central Notes Feature

Central (Centralized) Notes

Overview

Central Notes are designed to allow users to enter and store notes in a centralized storage location. When used, Central Notes enables users to maintain, and review, any notes that are entered when an action is performed, or when a modification is made.

User prompts for a central note entry can be made to occur at the entity level, or at the field level of a profile. This means that a user can be prompted to make an entry when they either access and make a change anywhere in the profile, or in a specific parameter in the profile. These settings are made by an administrator in the Business Entity Designer (BED) release 5.1 or greater. in addition Central Notes can be applied on a dataset basis, i.e. all records of a search result could have a note applied to them collectively.

NOTE: Central Notes that are applied as a dataset are permanent, Notes applied to a dataset cannot be removed.

 

101-std-fea-009-(uiTN)-[v6.0].png
Centralized Notes Pane & Viewer

As an example, in the Parcel Linking profile if a new parcel link is created, or a modification is made to an existing Start Date or End Date, justification may be required for the action. This layer of security can be provided with the Central Notes System. When enabled, the user will not be able to complete the action unless an entry has been made in the Central Notes form. When entered and saved, the record of the username, change, and details is saved.
When a centralized note is entered, an optional flag can be assigned to it. A note can be entered with three (3) statuses. These statuses can be used as part of a search criteria. (Table: PC_CENTRAL_NOTES).

Locating the Central Notes pane

The Central Notes can be found by default as an Auto-Hide tab located on the left hand side of the Govern user interface. To display the note field, hover your pointer over the tab to display it. Refer to Auto-Hide Panes (std-fea-001).

Read More...

Enabling Central Notes

Creating an Entity Level Centralized Note requirement

At the entity level, when an entity is made or modified, the user will be required to enter a centralized note entry.

To set up an Entity level Central Notes entry request, you will need to make changes using the Business Entity Designer (BED) release 5.1 or greater. Refer to the BED release 5.1 guide for details about modifying Business Entities (BE’s)

  1. In the BED, under the Model Explorer pane, click on the Business Entity that will require a Centralized Note entry; for our example we will use Parcel Linking.
  2. Under the Properties pane on the right hand side under 1 – Basic Data Settings, set the Note is required on creation flag to True.
  3. Set the Note is required on modification flag to True.
  4. Click Save.

When the flags are set at this level, i.e. the Entity level, a Centralized Note entry will be required to create a new parcel link entry.
Creating an Attribute Level Centralized Note requirement
At the Attribute level, in order to enter a note, or when a modification is made to an attribute, i.e. field, a note entry will also be required to be made.
To set an attribute level Centralized Note entry request…

  1. In the BED release 5.1, under the Model Explorer pane, click on the Business Entity that will require a Centralized Note entry; for our example we will use Parcel Linking.
  2. In the central area under the List of Attributes pane, select an attribute that you want the user to be prompted with a Centralized Note entry request; for our example select the END_DATE attribute.
  3. On the right hand side, locate the Central Notes property, set both the Allow Notes, and the Note is required on modification flags to True.
  4. Repeat the above steps 2 and 3 for the FROM_DATE attribute.

About Entity / Attribute Level Centralized Note requests

Users that are enabling Central Notes for Entities and Attributes should note that the request for a Centralized Note entry by the system are separate. This means that if the flags are set at both the Entity and Attribute level, a separate prompt for a Centralized Note entry will be issued by the system.

Central Notes pane

The Central Notes pane is used to enter and display the notes that are related to the selected parcel. These tabs are used to enter and view the Central Notes, as well as controlling what notes are displayed after a search, through a series of user selectable filter fields.

Notes Viewer form

With a click on the Notes Viewer button in the Central Notes pane, the Notes Viewer form is displayed. This form contains two (2) tabs, one for defining your search parameters, and the other for displaying the search results.

NOTE: by default when the Notes Viewer button is clicked, the Notes Viewer form is displayed with the Notes Viewer Search Results tab.

Notes Viewer Search Criteria tab

In the Notes Viewer Search Criteria tab, you are able to search the Govern system for existing notes. The results of the query are filtered based upon your search parameters.

Central Notes Management tab

Notes Viewer Search Criteria tab – Command Button
Retrieve Notes:
Click Retrieve Notes to perform a search of the Centralized Note based upon the Filter options selected.

Notes Viewer Search Criteria tab – Parameters

The following is a description of the parameters that are found under the Notes Viewer Search Criteria tab.

Filters group

Dataset Filter group

Selections in the Dataset Filter group will restrict the display of notes to those within the current dataset.
All: Click All to display all notes in the current dataset.

Current Parcel: Select this option to display notes that are restricted to the current parcel.

Current Name: When Current Name is selected, only the Central Notes that were created on records that are linked to the current name account.

Author Filter group

All Authors: Select this filter option to display notes from all authors under the Author list. (TABLE: USR_USERFILE)

My Notes Only: When selected, this option will display only notes made by the current logged in user.

From Author: Click to select the From Author option; this will display the notes entered by the author that is selected from the drop down menu.

NOTE: The drop down menu list will not be active unless the option is selected. When this option is selected, but no author is selected, a warning will be displayed requesting that an author be selected from the list.

Subject Filter group

Entity Name: Click to select an Entity Name from the drop down list; the notes that are displayed are the ones that are related to the Entity.

Control / Attribute: Select the Control / Attribute option to filter for the Control or Attribute that is associated with the selected control or attribute

Table Name: Click to activate and filter Central Notes that are associated with the selected table name.

Column Name: After selecting a Table Name, you can further filter down and display Central Notes associated to a selected column name.
Date Filter group

Fiscal Year From / Fiscal Year To: Enter the Fiscal Year range of interest in the From and To fields.

Entry Date From / Entry Date To: Enter the date range of the Central Notes that you would like to view.

General Filter group

Note Priority: When a priority has been assigned to a Centralized Note, use this option to filter the search results for a specific priority. If no priority is selected, the all notes will be specified.

Exclude Private Notes: Select this option to exclude all notes that have been assigned with the Private Notes option.

Searching for Central Notes

Users with access to Central Notes can perform a search on all notes entered in the system. The search can be by parcel, name, or by author, for a given entity or attribute.
To perform a search for Central Notes that have been entered in the system:

  1. Click to display the Central Notes auto-hide pane.
  2. Select the Notes Viewer Search Criteria tab.
  3. In the Filters group, select each criteria required from each of the filter groups.
  4. If required select a priority note from the General Filter group.
  5. Click Retrieve Notes.

Notes Viewer Search Results

The search results will be displayed under the Notes Viewer Search Results tab.

Notes Viewer Search Results

As indicated earlier, the Notes Viewer Search Results tab displays the results of search queries based upon selected filters. The columns displayed can be re-arranged with a drag and drop action.

Grouping by Columns

The Central Notes drag and drop feature also allows for grouping by column heading. The space above the columns titled Drag a column header here to group by that column is referred to as the Grouping Area (A). This space expands to accommodate column names as they are added.

For example, if we have the following columns headings…:

  • Priority
  • Private
  • Entry Date
  • Relates To
  • Note
  • Author Name

We may want to view the entered notes grouped according to the Priority (A).

To group according to the Priority:

  1. Click and drag the Priority column into the Grouping Area above the columns; when empty this area is marked”Drag a column header here to group by that column”. Drop the column heading on the Grouping Area.
  2. You will note that the data has now been grouped according to the Priority column. You will see a heading that indicates the column grouping, the item that it is being displayed under, and the total number of items under that grouping. Click on the “^” beside the column grouping (A) to expand or contract the content listed.

Multiple columns or attributes can be grouped by dragging and dropping them into the Grouping Area above the column headings. Additional columns will appear as subgroups within the original group.

The order of the groups and subgroups can be changed with a drag and drop procedure.

To re-arrange subgroups:

  1. Click and hold the pointer on the subgroup title.
  2. Drag the title to its new location, noting the insertion point between the subgroups. The insertion is indicated by a bright vertical bar.
  3. Release the mouse button to complete the insertion.

Removing Column Groupings

To remove column groupings from the Grouping Area:

  1. Click and drag the grouped or sub-grouped title to an area outside of the Grouping Area.
  2. When an ‘X’ appears, release the mouse button to drop the object. The grouping or sub-grouping will be removed.

Viewing Central Notes Search Results

After result have been generated, there are two (2) options available to view the results; export results to an Microsoft Excel spreadsheet, Print with a preview.

Notes Viewer Search Criteria tab – Command Button

Export to Excel: When Export to Excel is selected, the current search result grid will be exported as an Microsoft Excel spreadsheet.

NOTE: The Excel export will not be affected by the sort order or grouping; the columns are output in the default order of the system.

Print Preview: Click Print Preview to display a preview of the current search result grid.

Behavior of Central Notes when enabled in Govern

When Central Notes are enabled, fields that have the Central Notes enabled through the Business Entity Designer (BED) will have icons that flag the state of the field.

Central Notes Status Icons

Central Notes fields are indicated with Notepad icons that lets the user know their status. Red icons indicate that note entries are required, i.e. mandatory; Gold icons are an indication that note entries are optional:

Allowed: The yellow icon indicates that entry of notes is optional for the user.

Required: This indicates that any changes to the field involves a mandatory note entry

Exists and Allowed: The yellow icon and magnifying glass indicates that notes exist in the system, but they are optional for the user.

Required and Exists: The red icon and magnifying glass indicates that a notes exist, but mandatory entry is required for changes by the user.

How to make a Centralized Note entry

Users that are attempting to save a record when the field is set as Required will be presented with the following error window: To resolve this situation…
1.Click OK to acknowledge the notification.
2.Locate the Central Notes auto-hide tab; place your pointer over the tab to display it.
3.Click Add a New Note.

NOTE: When a new note is created, the date, time, and user log-in name is displayed for reference.

4.Click in the note field and enter your note

5.When complete, click Save.

As long as the Centralized Note is created and the reason for the creation or change, i.e. “justification” is entered, the system will them allow a save.

Creating a Centralized Note for a Dataset

WARNING: A Centralized Note that is applied to a dataset cannot be modified or deleted. Take care when making your entry

Creating a Centralized Note for a Dataset, i.e. a group of records that are the result of a query, hand picked records, or appended list, is a similar procedure to applying one to an individual record.

NOTE: In order to be able to click on the Central Notes button, you will need to open a Profile, then perform a search.

To create a Centralized Note that will apply to a dataset…

  1. Perform a search; the resulting records will be the dataset.
  2. Load the dataset into the Dataset Treeview.
  3. If not selected, click the Home tab in the Govern Ribbon.
  4. In the Flags group, click to select Central Notes.
  5. In the Central Notes form, enter your notes that will apply to the dataset (1).
  6. Select a Priority status, and select the Private option if the note is to be set as private (2).
  7. Click Save (3) to create the note or Cancel (4) to stop the creation process.

Central Notes for Datasets are saved in the same table as the individual record notes, (Table: PC_CENTRALIZED_NOTES), the exception here is that these notes are permanent, i.e. they cannot be deleted.

Modifying a Centralized Note

Once a Centralized Note has been created, the author or creator of the note can modify their entry. In addition, with the correct security flags set in the Govern Security Manager (GSM), an author can modify all Centralized Note entries.

To modify a Centralized Note…

1.Display the Centralized Note pane.

2.Select the note and effect any required change.

To enable a Centralized Note author to be able to edit all notes…

1.In the GSM, ensure that the permissions flag for Update (U) has been set; refer to the Working with Central Notes section of the GSM 5.1 user guide.

NOTE: If the update flag has not been set, the author will only be able to change the notes that they created, and no others. Refer to the GSM release 5.1 for details on Working with Central Notes.

 

What’s New

[v6.0.1404]
  • The search panel is now dockable. Users can keep this window open while performing other tasks. Very handy for users with dual screens.
  • Collective notes can be recorded by dataset (permanent)
[v5.1]
  • Note Priorities
  • Private notes are used to flag notes that should not appear on the web

Specification

Product feature specification [v6.0] for centralized notes:
General

  • Recorded at the business entity level or at the field/attribute level
  • Recorded for the active parcel, name, building… or for the entire dataset or recordset results (permanent)
  • Metadata recorded along with the note (i.e. the author, date, dept. fiscal year, entity name, attribute/field name… is saved along with the note)
  • Additional security level based on authorship (my notes, other people notes)
  • Allowed or Required (on creation or on modification) Business Entity notes
  • Allowed or Required notes on Attributes
  • Priority status (3)
  • Private notes

User Interface

  • Auto-hide and dockable Note Pane synchronized with active form and ids
  • Notes are saved with the form
  • Centralized Notes Viewer with Search & Results (sort, group, print and export to xls)
  • Search Criteria:
    • Dataset: All, Current Dataset, Current Parcel
    • Author: All, Mine, Specific Author
    • Subject: Entity name, Attribute name, Table name, Column name
    • Date: Fiscal Year From and To, Entry Date From and To
    • General: Priority, Exclude or Include Private Notes
  • Visual representation (cues) of the note state on the form (required & missing, required and available … )
  • Notes can be deleted

Business Rules

  • Required Note Option to enable an additional layer of security to prevent a user from completing an action unless a note is created
  • Is dirty property is set to true on the form when a note is created or modified

Examples

  1. in a profile with Parcel Linking, if a new parcel link is created, or a modification is made to an existing Start Date or End Date, justification (note entry) may be required to complete the action (save or modify).

Setup (BED)

Setup in the Business Entities Designer as true or false properties for the Business Entity or for an Attribute (field).

Business Entity

  • A note is required on creation
  • A note is required on modification

Attribute

  • Allow notes
  • A note is required on modification

Security

In Govern Security Manager (GSM), there are 2 items that can be secured for notes; Entry & Viewer.
In addition, a distinction is made for Centralized Notes Entry between My Notes (notes entered by the user) and Other people’s Notes.

Expand ApplicationsGovernMenuViewViewCentral Notes to get the following:
Central Notes (change to Centralized Notes)

  • Central Notes Entry
    • My notes
    • Other notes
  • Central Notes viewer

For more information, see 102-Govern Security Manager (GSM) OpenForms System Suite

Technical Info

Tables

PC_CENTRAL_NOTES
PC_LK_CENTRAL_NOTES

[v6.0] New Govern Standard Attribute PC_CENTRAL_NOTES REQUIRED

Best Practices

  • Do not overuse (it is human nature to overdo it); this can be overwhelming when reviewing the information.
  • If Required Notes are not set properly, they can be a burden for users with data entry functions.

 

 

101-std-fea-009

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

MA – Mass Appraisal Feature 4 – Search

Mass Appraisal Feature 004 – Search

Overview

The Mass Appraisal Search feature allows you to retrieve datasets from the database. The Predefined Searches pane is the main user interface for performing searches on the database.
Further actions such as creating permits, attaching messages, generating licenses, generating mailing lists, etc. can then be performed on the records in these datasets.

When a search is performed, you are querying the database based upon your specified criteria. For example, a search by Parcel ID (P_ID) will return all records with a P_ID or a P_ID that matches a specified parameter. Search results can be controlled with the value specified in the Max. Records parameter in the User Registry. For example when the Max. Records parameter is used, i.e. a value of 25 is specified, only the first 25 records are used. If there are more records, they are discarded. Additional sorting can occur, but only on the records obtained.

Related Topics

 

 

101-ma-fea-004

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

Dynamic Search Objects

Dynamic Search Objects

Overview

All items that appear on the Search pages, including the search criteria and the labels are referred to as Objects. To display the objects on a Search page, you need to link them to a Search Style.
Through the Dynamic Search Object management tool, you can create the Search Objects and assign properties and behaviors to them.

The Search Objects Management tool has three sections

  • Available Objects: Available Objects list box displays the existing search parameters or Objects. Once a Search Style is applied, the objects can be added to the Search page and used as search criteria.
  • Properties: The Properties section displays the attributes of the selected object. Use the Properties section to create a new object or to modify or delete the attributes of an existing object.
  • Behaviors: Behaviors define how the data appears on the Web, and how they are stored in the database.

Creating an Object

Read More...

An object is a parameter that can be used as a condition for a search. Alternatively a series of different objects can be collected together as a group.
For example, objects such as House No.(From) (Location) and House No. (To) (Location) can be used as part of a group that allows the user to enter an address range in a search for parcels.
To create an object in GNA, from the ribbon:

  1. Select Editors (tab) > Dynamic Search Configuration (group) > Dynamic Search Objects.
  2. When the Dynamic Search Objects form appears, click Create a new item to create a new object.
  3. In the Code field, enter a string to identify the object in the database; use a maximum of 15 characters.
  4. In the English Short Description field (or the Short Description field for your first language), enter a description using a maximum of 25 characters.
  5. For the English Long Description field, enter a description up to a maximum of 100 characters.
  6. From the Control Type drop-down menu, select one of the following:

Selecting a Control Type

Control_Type_ Description
Check Box

Select this control type to display a check box to the user.

Note: When you select the Check Box control type, you need to consider the Checked option, under Behaviors. Select Checked if the object is to be selected (Ö) by default.

Combo Box

There are three options for the combo box:

User Query: Select this option to display items from a customized query. Then enter the query in the Query text box.

System Table: Select this option to display items from a system table.

User Table: Select this option to display items from a user table.

Label Select this type to display the object as a label or heading.
Text Memo Select this type to display a Memo field, for notes and comments. This type can accept an unlimited number of characters.
Textbox

There are nine textbox types. Select one of the following options to define the type of entry to accept.

Alphanumeric: Select Alphanumeric to accept all alphanumeric characters.

Currency: Select Currency to accept numeric characters, decimals, commas, spaces and currency symbols, such as the dollar sign ($). Entries are formatted according to the currency standards of the cultures entered on the Web Configuration tab of the Data Access Block.

For example, if en-ca and fr-ca are entered, $50.00 or 50,00 $ are accepted.

Date: Select Date to accept alphanumeric and special characters. The date is formatted according to the setting selected on the Updata Retry.

Date / Time: Select Date / Time to accept alpha-numeric and special characters. This is formatted according to the server.

Numeric with Decimal: Select Numeric with Decimal to accept numeric characters and decimals only. No letters or special characters will be accepted.

Numeric without Decimal: Select Numeric without Decimal to accept numeric characters only. No decimals letters or special characters will be accepted.

Pattern: Select Pattern to apply a field mask or pattern to the data entry. The field mask automatically formats the data entered in the field according to a set pattern. For example, you can define a pattern for phone numbers and apply it to the Telephone fields. If the user enters 18005618168, this is automatically formatted as 1-800-561-8168.

When you select Pattern, the Pattern Name and Custom Pattern fields appear. You can select a pattern previously saved to the Govern database or create a new one.

Tax Map Number: Select Tax Map Number to apply the mask or pattern, saved in the Govern database, to the user entry tax map number.

Time: Date / Time: Select Time to accept alpha-numeric and special characters. This is formatted according to the server.

7. In the Behaviors group, select all behaviors that apply to the object.

Behaviors group

Behavior Description
Encrypt Select Encrypt to encrypt the data in the database.
Force Uppercase Select Force Uppercase to save and display the user entry in uppercase.
Mask Entry with (**) Select this behavior to mask the user entry with asterisks, as with password entries.
Perfect Match Select Perfect Match to accept a full and exact match only. For example, to retrieve an account, the user must enter the full account number. A partial number is ignored.
Checked

The Checked behavior applies only to the Check Box control type.

Select this option to display a checked box, by default.

Deselect this option to display an unchecked box, by default.

Visible

This behavior is selected by default, meaning that if the object is added to the Web page, it will be displayed and made visible to the user.

Deselect this behavior to make the object invisible to the user.

8. Click Add to add the new object to the Available Objects list box and to the USR_WEB_SEARCH_OBJ table.

9. In the Table and Column drop-down menus, select the Govern database table and column, that will be used for the search.

Create a Parcel ID Object

In the following example we will create a Parcel ID object which, when referenced, will be used for entering parcel ID numbers.

  1. In the Search Object Management form, click Clear All Entries to start a new entry.
  2. Enter pcParcelIDseg in the Code field.
  3. Enter “Parcel ID Seg” in the English Short and Long Description, repeat the same description, or the following translation, “ID de la propriete seg” in the French Short and Long Description fields..NOTE: When a Short Description is entered and you click in the Long Description field, it is copied into the Long Description field.
  4. Under Control Type, select Textbox – Numeric without decimals
  5. Select PC_PARCEL for the table type.
  6. The Column that will be used is P_ID; there will be no Default Value.
    Take note of the code name that the object is given so that you can reference it for other examples.

Create a Tax Map Object with Default Values

Certain municipalities may have specific requirements for Tax Map numbers. For example a specific numeric sequence may be required as part of the Tax Map number. To minimize errors during frequent entry, a default sequence may be set with the requisite numbers. In the following example we will create a Tax Map search object that will have default values in the fields.

NOTE: The system will only allow one pattern for the Tax Map Number. The mask for this pattern is defined in the Global Field Validation Mask Editor.

In the Dynamic Search Objects editor…

  1. Click New.
  2. Enter pcTaxMapSeg in the Code field.
  3. Enter English short and long descriptions called Tax Map Number Pre
  4. Repeat the short and long descriptions for the French fields
  5. Select a Control Type of Textbox – Tax Map Number.
  6. Select PC_PARCEL from the Table drop-down menu.
  7. Select TAX_MAP_UFMT from the Column drop-down menu.

The Default Value is where the required sequence is entered. When a Tax Map mask looks like the following: “##-###-##-##-####”, and it needs to contain a default sequence with the following “-110-33-”, i.e. all tax maps will contain these numbers, this sequence can be entered in the Default Value field:

NOTE: When entering values into the Default Value field, DO NOT enter any quotation “ “ marks; only the dash “-” and the numbers are required.

Enter this sequence: “-110-33-“; without quotation marks.
Do not use this sequence: “XX-110-33-XX-XXXX”
“X” represents space characters.

NOTE: Space characters in the Default Value field are not required and will not work.

8. In the Default Value field (A), enter -110-33- with no spaces before or after the sequence.
9. Click Save, to add the new object to the list.
10. If any additional changes are required, make them, then click Save to save the object again.
The resulting object when used in the MSGovern.NET search form will appear with the entered sequence as a default (A).

Modify an existing Object

To modify an object:

  1. Highlight the object in the Available Objects list box.
  2. Make any required changes to the parameters on the form.
  3. Click Save.

Deleting an Object

To delete an object:

  1. Highlight the object under the Available Objects column on the left hand side (LHS).
  2. Click Delete; a confirmation window will appear.
  3. Click Yes to delete, or No to cancel.

See Also

Dynamic Search Objects
Dynamic Search Styles
Dynamic Search Groups

 

 

103-ed-014

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...