Helix ALM

The table name is SCMCHGLST. You can check database schema here: http://help.seapine.com/helixalm/2018.1.0/erd/entd.html#SCMCHGLST

REST API and SOAP SDK do not have methods to manipulate this information.

Helix ALM and Selenium integration

https://www.perforce.com/webinars/alm/quality-not-compromise-best-practices-automated-testing

To add files in empty depot follow the below steps

a. Create a workspace
b. Create a folder with Depot name( like Development)
c. Create a file under the folder as readMe.txt
d. Check-in the file
e. then click on get latest version you will see the folder with depot name in the workspace along with file you created.


To delete a workspace

from Helix Core documentation :  https://www.perforce.com/perforce/r14.3/manuals/p4v/using.workspaces.html

Deleting a workspace removes Perforce's record of the workspace but does not remove files from the workspace or depot. You cannot delete a workspace that has files checked out (open for edit) in Perforce.

To delete a workspace:

1. Submit or revert any pending or shelved changelists associated with the workspace.

2. Go to View > Workspaces or select the Workspace icon in the toolbar to open the Workspaces tab.

3. Context-click the label and select Delete Workspace 'workspace_name'. 

Helix ALM Database 

select * from TTPRojects
select  * from VIEWINFO
select * from REQMNT

select * from REQMNT where  idRecord in (14337,13489,14498,13559,14335)
select * from SCMCHGLST where entityRID=14335 ChgLstID in (3541,5871) --

select * from SCMCHGLST where  entityRID= 13489 ChgLstID in (5256) --

select * from SCCFILE where ChgLstID in (2118)
select * from SCCFILE where idRecord =135417
select * from SCMCHGLST where  ChgLstID in (5739) --
select * from SCCFILE where ChgLstID in (3478)

select * from SCCFILE where changeType=0
select * from SCCFILE where Filename ='//Dev/Source/ACE/CommonLIB/COMMON_UTILS/COMMON_UTILS.esql'
select * from SCCFILE where Filename like '%demo.service.ts'

select * from SCCFILE where ChgLstID in (3086,3105)

--1920036212  --Task
--1684431732  --Defect

select * from SCCFILE  where ChgLstID not in (4294967295) (3541,5871)

To start / stop helixalm on jenkins server when helix alm rest api  is installed

/usr/bin/helixalmrestapi start

/usr/bin/helixalmrestapi stop

/usr/bin/helixalmrestapi cleanup

/usr/bin/helixalmrestapi start

https://help.perforce.com/helix-alm/helixalm/2019.3.0/restapi/Content/RESTAPI/GettingStarted.htm