Data Setting [v4.9.0]

For versions:4.9.0

Click ‘Download’ button to show summary or download as PDF for offline viewing.

Data Setting

Data setting or data management is a feature that allow you to CRUD (Create, Read, Update, Delete). Using these capabilities, you can easily create new collections in databases, add field, purge data collection and remove data collection.

  • First, login as ‘Administrator‘, for the 3Dolphins SRM login mechanism, do the steps described on the ‘Login‘ page,
  • Go to Administration and click the Data Setting menus, then you will see a data setting page such as images below.

Component explanation :

IconNameDescription
New CollectionProcess to add new collection.
Refresh PageRefresh your page at any time to ensure you are always up to date and see your latest collection with the refresh button.
FieldProcess to add field in collection.
Purge Data CollectionProcess of freeing up space in the database or of deleting obsolete data that is not required by the system.
Archive CollectionProcess of moving data that is no longer actively used to a separate storage device for long-term retention
Remove CollectionRemoved a collection in data management list and database.

Create New Collection

To create new collection, in the upper right corner click the +new collection button. Then, you will see a pop-up form new collection, type your collection name, tick enable commit and click the save button to finish.

If creating a new collection is successful, you will see a notification that succeeded and the collection will be displayed on the data management list.

Add Fields in Collection

You can add fields or update fields to every collections by select collection and click fields button. Then, you will see a pop-up form to add the fields, enter field name and select the type of field collection as shown below.

If you want to delete a field in a collection, you can click the delete button on the action field in each field collection.

Field component explanation :

Field NameDescription
NameName of the field stored and referred in Solr. (Required)
TypeThe datatype of the field defined in the configuration . For example datatype i.e ‘Boolean’, ‘int’, ‘date’ etc. (Required)
IndexedIf indexed=True, the value of the field can be used in queries to retrieve matching documents.

If indexed=False, will make the field only stored but can’t be queried with.

(Optional)
StoredIf stored=true, the actual value of the field can be retrieved by queries (to tell Solr to store the original text in the index somewhere).

If stored=false, will make the field only indexed and can’t be retrieved in output.

(Optional)
MultivaluedIf true, indicates that a single document might contain multiple values for this field type. (Optional)

For example :

  • If stored=true and indexed=false : field aren’t searched, but need to be displayed in the search results.
  • If stored=true and indexed=true : field should be searchable and displayed in the search results.

Purge Data Collection

Purging is the process of freeing up space in the database or of deleting obsolete data that is not required by the system.

In the data management page, select the collection and click purge button. Then, you will see a pop-up to confirm the purge data collection, click yes button to proceed or you can click no button to return to the data management page.

Remove Collection

Sometimes you need to remove the collection from a database when it’s no longer needed.

In the data management page, select the collection and click the remove icon. Then, you will be prompts to confirm the remove request, click ‘Yes‘ to proceed remove classifier module or you can click ‘No‘ to return to the data management page.

If you removed a collection in this data management list, it will removed collection in the database.

Archive Collection

Archive collection is the process of moving data that is no longer actively used (no longer frequently accessed off primary systems) to a separate storage device for long-term retention.

At present, the 3Dolphins application already supports of archive on the user and ticket collection, so that it can improve server performance and speeds up the loading time for views, especially those views that include multiple tickets which have been closed for a long period of time.

Select collection and click archive collection button ( ). For example, archive collection with range date is ’31/03/2020′ to ’31/03/2020′ and click yes button.

Before you archive a collection (example collection of ticket), make sure that there is a ticket for that date.

If the archive collection is successful, you will see a pop-up success notification and archived collections will be displayed on the data management page with the format is ‘{collection_name}_{years-month-date-hour-minutes-second}‘, for example (example_collection_20200401115940) like the images below.

To view ticket archives, open the customer support page and search for tickets, and then select the date of the archive as shown below.

Was this article helpful?
Dislike 0