Add restricted access capabilities in the SBM administrator to allow for only Import Data. Currently SBM administration access can be somewhat limited by creating a managed administrator account, howe...ver the capabilities are not restricted at a finite level for some of the functions. Specifically we have a client that has a need to allow for only Import Data capabilities as they have external data that needs to be loaded into their own applicaitons
A test user was set up as a managed administrator with only submit access to a project its and auxiliary tables. Here are the results:
1. When the user was set up with no remote access privileges, all of the functions including Import Data were locked out with the exception of the Auxiliary Data which worked as expected. 2. When the user was set up with remote access privileges, the Import Data and Auxiliary functions worked as expected, however the following functions were also accessible:Resources, Work Center, Localization, Channels, Mailboxes, Record Locks, Calendars.
The request would be to enhance the SBM administration to allow for specific restriction of all other capabilites while still allowing access to the Import Data functions.
Thank you.More

Provide a mechanism where a REST dataset may be altered prior to display in a REST Grid. Seeking a feature to allow for altering a REST dataset using JavaScript or AppScript prior to the time it is di...splayed in the REST Grid. The AppScript should be able to access data within SBM and utilize data within the REST dataset to generate data for display in 1 or more columns of the REST Grid.
This functionality would provide the following benefits:
1) a means to correct REST service results if the REST service does not function correctly
2) to programmatically generate data for display in a column of the REST Grid.
In some cases, 3rd party REST services may produce results are are nearly usable but might have a minor flaw or they might return more results than what should be presented. Being able to programmatically alter the REST dataset would provide a means for solving these types of issues.
Some data must be displayed that is not contained in the REST dataset being returned but it can be generated. Being able to populate 1 or more columns in the REST dataset prior to display would solve this problem.More

Update SBM so that it can provide a REST and SOAP Web Service interface to any RDBMS based on a SQL statement The genesis of this enhancement request originates from the need for providing end-users i...n SBM the ability to marshal data from our other products (RM, CM, SDA) and 3rd party server products such as HP QC through an application workflow. SBM's orchestration workflow capability is limited by the robust architecture of the web service API for the other Serena product or the 3rd party server product. If Web Service that queries the data source of the Serena product or the 3rd party server product could be generated while developing an orchestration workflow, the orchestration could be delivered faster and with greater optimization. In the absence of an existing web service API, this feature could mean the difference between making an orchestrated workflow or not being able to meet the needs of the customer.
Providing a REST Service interface is also very compelling since SBM also supports a REST Grid. The REST Service could allow the presentation of data from the 3rd party server for selection in the workflow or presentation to the end-user so they can make a decision within the workflow. The generated REST service should also support the _currentPage pagination support that SBM REST Grid provides so that large datasets may be displayed in the REST Grid without uploading all of the data to the web browser.
The logical location for this feature should be a part of SBM Application Repository Manager since the data connections that will be defined are analogous to an end point. The SBM administrator could define the web service / REST service in the SBM Application Repository Manager and import the WSDL in composer as is currently done.
The data connection credentials and server will change from environment to environment. The SBM administrator would likely follow these steps for creating a web Service / REST Service:1) create a data connection using the same technique they do to create a data connection for SBM. 2) specify a SQL command and input parameters3) indicate if the interface being generated should be REST or SOAP web service or both, 4) specify access permissions to the newly created REST and SOAP Web service.
This enhancement would provide the following benefits:1) SBM orchestrated workflows could be generated with 3rd party applications regardless of the presence or functionality of the 3rd party application's web service API2) SBM REST Grids could present data from 3rd party applications regardless of the presence or functionality of the 3rd party application's REST service API3) If a 3rd party's application web service API or REST Service API is defective, development of the SBM orchestrated workflows could be generated without delay.4) If a 3rd party's application web service API or REST Service API is defective, this feature could present compelling evidence to prove that the problem is not caused by SBM.5) If a 3rd party's application web service API or REST Service API is poorly designed resulting in many complex web service calls that require significantly complicated orchestration steps, this feature could provide a much more optimal dataset for parsing within the SBM orchestration.
The functionality of the data server could be modeled after WSO2 data server (http://wso2.com/products/data-services-server/).
This feature could benefit any client that intends to create orchestration workflows or use the SBM REST GRID and has the following aspects in their environment:1) Presence of DIM RM, SDA, DIM CM2) Presence of a 3rd party server product (e.g. HP QC, Remedy)
This functionality could have been useful in many large clients that may be cited off-line. Please reach out to me privately.
I wrote a web service that performed a similar purpose (processed a SQL command and returned an array dataset). This web service has been used in multiple clients as well.More

Add change event to workcenter backlog so that changes logged in the TS_AGILE_CHANGEACTIONS table will be created for priority changes in the backlog. Currently the workcenter backlog logs changes to ...the backlog such as when it is created, deleted or when items are added or removed. These changes are logged in the TS_AGILE_CHANGEACTIONS table. The priority changes are not logged in the TS_AGILE_CHANGEACTIONS table. Please log priority changes in the TS_AGILE_CHANGEACTIONS table.More

Workcenter present a column/grid interface. Currently, the columns and their labels are fixed. We would like them to be editable.
Column label changes should be permitted (so Priority could be mad...e Rank, etc)
Columns should be able to be sortable so that what appears in the third position could be moved to the first position, etc. Perhaps drag n droppable.
Selections regarding which columns appear should be permitted. Right now, the displayed columns are fixed; it's not possible to replace one for another.
More