Highlighted
Absent Member.. Absent Member..
Absent Member..
226 views

How to do a list with group of records on service manager

Jump to solution

Hi everynody,

 

I want to know --> How to do a list with group of records on service manager as the view Incidents by Operator but with another table, this tables was created recently. 

Thanks a lot.

 

 

0 Likes
1 Solution

Accepted Solutions
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: How to do a list with group of records on service manager

Jump to solution

If you want to be able to define a queue and related views (e.g. Incidents, Interactions, Changes, etc.), the new table needs a dedicated Object record. 

  • You can start by copying the DEFAULT Object. Do not accidentally click Save after changing the object name to your tablename (this would overwrite the DEFAULT Object, which would not be good).
  • The Manage Queue tab of the Object must be filled in. Use and existing object as an example. Enable views for the table in the Object..
  • Define at least one view for the table. If the logged-in user does not have access to any views for a table, they will not see the table as an option in the Queue list.
  • Define an sc.manage format for the queue. 

 

If you just want to be able to search for records in the table (e.g. and display a list of results, a dedicated object is not needed. 

  • In the format control for the detail form, make sure the Access via DB Mgr option condition evaluates to true.
  • If you have not done so, define a list format (a .qbe form) using the forms designer wizard. The form should follow the format [tablename].qbe (e.g. myCustomTable.qbe).
  • From database manager, search for the table, select the form, and you should be able to execute the search. 
  • You can also add a menu item to link to the table for searching. You can use a line from an existing menu that calls the database application as a model.
----------------------------------------------------
Kudos - what, where, how, and why
Want Good Answers? Ask Good Questions...

View solution in original post

1 Reply
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: How to do a list with group of records on service manager

Jump to solution

If you want to be able to define a queue and related views (e.g. Incidents, Interactions, Changes, etc.), the new table needs a dedicated Object record. 

  • You can start by copying the DEFAULT Object. Do not accidentally click Save after changing the object name to your tablename (this would overwrite the DEFAULT Object, which would not be good).
  • The Manage Queue tab of the Object must be filled in. Use and existing object as an example. Enable views for the table in the Object..
  • Define at least one view for the table. If the logged-in user does not have access to any views for a table, they will not see the table as an option in the Queue list.
  • Define an sc.manage format for the queue. 

 

If you just want to be able to search for records in the table (e.g. and display a list of results, a dedicated object is not needed. 

  • In the format control for the detail form, make sure the Access via DB Mgr option condition evaluates to true.
  • If you have not done so, define a list format (a .qbe form) using the forms designer wizard. The form should follow the format [tablename].qbe (e.g. myCustomTable.qbe).
  • From database manager, search for the table, select the form, and you should be able to execute the search. 
  • You can also add a menu item to link to the table for searching. You can use a line from an existing menu that calls the database application as a model.
----------------------------------------------------
Kudos - what, where, how, and why
Want Good Answers? Ask Good Questions...

View solution in original post

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.