When you are working with ALM as administrator or project user, you might have come across some challenges to upgrade any of the field values in bulk mode.
Example: updating test cases module/stream from one project
If we have few values then it would be easier to update manually by identifying the specific cases, but when you have massive cases then updating all values would be really tedious and time consuming.
If you have ALM DB access then simple way to update values is, connect to DB directly and fire SQL queries and commit the changes.
following is the one of the case how we can run update data by firing sql query
Prerequisite: we have to first connect to Project schema from DB client.
Example: updating test cases module/stream from one project
If we have few values then it would be easier to update manually by identifying the specific cases, but when you have massive cases then updating all values would be really tedious and time consuming.
If you have ALM DB access then simple way to update values is, connect to DB directly and fire SQL queries and commit the changes.
following is the one of the case how we can run update data by firing sql query
Prerequisite: we have to first connect to Project schema from DB client.
UPDATE ALM_DB.TEST
SET TS_USER_16 =
'MANUAL'
WHERE TS_TEST_ID =
54176 And TS_USER_16 = 'No'
UPDATE ALM_DB.TEST
SET TS_USER_16 =
'AUTOMATED'
WHERE TS_TEST_ID =
54176 And TS_USER_16 = 'Yes'
I had really saved couple of hours of effort after following this approach.
No comments:
Post a Comment