| |
Results |
|
How do I get a list of all Agile items that have documents attached as well as the path on the file system in the doc store repository?
|
By altering the following sql to match your database names it will show all the items in the docstore as well as the corresponding file system path. SELECT obj_UID as Item_ID ,obj_Name as Agile_Item_Name ,'root_'+ Cast(doc_RootFolderID as nvarchar(100)) as Doc_Root, Cast(doc_GUID as nvarchar(100)) + doc_FileName as SubFolder, doc_FileName as Original_Filename
|
|
|
|
When trying to create or delete a work item you get Backlog Name (xxx) has been modified since last retrieval and item won't create or delete.
|
You may start to get this error after changing the Date and Time settings or Time Zone settings on either the Agile server or the Database server if the two boxes are different. In order to fix this run the following sql statement against the Agile database and log back into Agile and try the create or delete again. update PES_Object set obj_LastChange = GETDATE()
|
|
|
|
Agile Integration to SBM troubleshooting and research findings.
|
Q. When setting up the integration you have to fill in the name of the SBM Release and Projects tables in the IDM Configurations auxiliary table. The documentation says to look in Composer to get the " Database table name ". Is this correct?
|
|
|
|
How to Reset the User Settings
|
Backup your database before continuing. ... Be sure to replace "xxxx" with the login name of the user having trouble. ... To fix the root cause of the error, we recommend that you take a backup of your database BEFORE clearing the user settings.
|
|
|
|
SQL to show all license counts as well as remaining licenses.
|
The following sql statements can be run against the database to help troubleshoot where the discrepancy may be. ... SELECT lic_UID, lic_ Name , lic_Count
|
|
|
|
How can I see a list of all Agile teams along with their team members?
|
SELECT PES_Object.obj_ Name AS Team_ Name , PES_Resource.obj_ Name AS Resource_ Name FROM PES_Object INNER JOIN
|
|
|
|
"Name" field and "Description" fields are not available on the Feature work item
|
In View Designer, neither the Name field nor the Description field are listed in the Attributes list. In the Types Setup tab and the Work Types sub-tab, neither Name nor Description are listed as available fields for the Feature work item.
|
|
|
|
How can I use javascript to get the value of a drop down select list on a form?
|
The following example code can be put in the onselectionchange event of a list box. When the value is changed a alert should show the currently selected text value. The underlying value is actually a numeric value that will be stored in the database .
|
|
|
|
How do I change the server name in email notifications to have fully qualified domain name in the url?
|
How do I change the server name in email notifications to have fully qualified domain name in the url?
|
|
|
|
Import: Story is put in wrong folder when the Product/Release name matches Team/Sprint name
|
Import: Story is put in wrong folder when the Product/Release name matches Team/Sprint name
|
|
|
