# Workflow Config-Replacement Data
## Overview
This document contains the steps to create new workflow configs specific to WS and SW modules for Bill Amendment.
## Steps
Create the new Workflow configs in the same tenant-Id as the one you want to replace in the applications.\
\
New configs for WS and SW bill amendment are as follows:
**Curl for WS Bill Amendment Config:**
```
curl --location --request POST 'https://egov-micro-qa.egovernments.org/egov-workflow-v2/egov-wf/businessservice/_create' \
--header 'Content-Type: application/json' \
--data-raw '{
"RequestInfo": {
"apiId": "Rainmaker",
"action": "",
"did": 1,
"key": "",
"msgId": "20170310130900|en_IN",
"requesterId": "",
"ts": 1513579888683,
"ver": ".01",
"authToken": "",
"userInfo": {
"id": 73,
"userName": null,
"name": null,
"type": "EMPLOYEE",
"mobileNumber": null,
"emailId": null,
"roles": [
{
"id": 2,
"name": "Customer Support Representative",
"code": null,
"tenantId": null
}
],
"tenantId": null,
"uuid": "uuid"
}
},
"BusinessServices": [
{
"tenantId": "pb.amritsar",
"businessService": "WS.AMENDMENT",
"business": "WS",
"businessServiceSla": 0,
"states": [
{
"tenantId": "pb.amritsar",
"sla": null,
"state": null,
"applicationStatus": "INWORKFLOW",
"docUploadRequired": false,
"isStartState": true,
"isTerminateState": false,
"isStateUpdatable": false,
"actions": [
{
"tenantId": "pb.amritsar",
"action": "OPEN",
"nextState": "APPROVALPENDING",
"roles": [
"CITIZEN",
"SW_CEMP",
"WS_CEMP"
],
"active": true
}
]
},
{
"uuid": "APPROVALPENDING",
"tenantId": "pb.amritsar",
"sla": null,
"state": "APPROVALPENDING",
"applicationStatus": "INWORKFLOW",
"docUploadRequired": false,
"isStartState": true,
"isTerminateState": false,
"isStateUpdatable": false,
"actions": [
{
"tenantId": "pb.amritsar",
"currentState": "APPROVALPENDING",
"action": "APPROVE",
"nextState": "APPROVED",
"roles": [
"WS_APPROVER",
"SW_APPROVER"
],
"active": true
},
{
"tenantId": "pb.amritsar",
"currentState": "APPROVALPENDING",
"action": "REJECT",
"nextState": "REJECTED",
"roles": [
"WS_APPROVER",
"SW_APPROVER"
],
"active": true
},
{
"tenantId": "pb.amritsar",
"currentState": "APPROVALPENDING",
"action": "SEND_BACK",
"nextState": "PENDING_FOR_CITIZEN_ACTION",
"roles": [
"WS_APPROVER",
"SW_APPROVER"
],
"active": true
}
]
},
{
"tenantId": "pb.amritsar",
"sla": null,
"state": "REJECTED",
"applicationStatus": "INACTIVE",
"docUploadRequired": false,
"isStartState": false,
"isTerminateState": true,
"isStateUpdatable": false,
"actions": null
},
{
"tenantId": "pb.amritsar",
"sla": null,
"state": "APPROVED",
"applicationStatus": "ACTIVE",
"docUploadRequired": false,
"isStartState": false,
"isTerminateState": true,
"isStateUpdatable": false,
"actions": null
},
{
"uuid": "PENDING_FOR_CITIZEN_ACTION",
"tenantId": "pb.amritsar",
"sla": null,
"state": "PENDING_FOR_CITIZEN_ACTION",
"applicationStatus": "INWORKFLOW",
"docUploadRequired": false,
"isStartState": false,
"isTerminateState": false,
"isStateUpdatable": true,
"actions": [
{
"tenantId": "pb.amritsar",
"currentState": "PENDING_FOR_CITIZEN_ACTION",
"action": "RE-SUBMIT",
"nextState": "APPROVALPENDING",
"roles": [
"CITIZEN",
"SW_CEMP",
"WS_CEMP"
],
"active": true
}
]
}
]
}
]
}'
```
**Curl for SW Bill Amendment Config:**
```
curl --location --request POST 'https://egov-micro-qa.egovernments.org/egov-workflow-v2/egov-wf/businessservice/_create' \
--header 'Content-Type: application/json' \
--data-raw '{
"RequestInfo": {
"apiId": "Rainmaker",
"action": "",
"did": 1,
"key": "",
"msgId": "20170310130900|en_IN",
"requesterId": "",
"ts": 1513579888683,
"ver": ".01",
"authToken": "",
"userInfo": {
"id": 73,
"userName": null,
"name": null,
"type": "EMPLOYEE",
"mobileNumber": null,
"emailId": null,
"roles": [
{
"id": 2,
"name": "Customer Support Representative",
"code": null,
"tenantId": null
}
],
"tenantId": null,
"uuid": "uuid"
}
},
"BusinessServices": [
{
"tenantId": "pb.amritsar",
"businessService": "SW.AMENDMENT",
"business": "SW",
"businessServiceSla": 0,
"states": [
{
"tenantId": "pb.amritsar",
"sla": null,
"state": null,
"applicationStatus": "INWORKFLOW",
"docUploadRequired": false,
"isStartState": true,
"isTerminateState": false,
"isStateUpdatable": false,
"actions": [
{
"tenantId": "pb.amritsar",
"action": "OPEN",
"nextState": "APPROVALPENDING",
"roles": [
"CITIZEN",
"SW_CEMP",
"WS_CEMP"
],
"active": true
}
]
},
{
"uuid": "APPROVALPENDING",
"tenantId": "pb.amritsar",
"sla": null,
"state": "APPROVALPENDING",
"applicationStatus": "INWORKFLOW",
"docUploadRequired": false,
"isStartState": true,
"isTerminateState": false,
"isStateUpdatable": false,
"actions": [
{
"tenantId": "pb.amritsar",
"currentState": "APPROVALPENDING",
"action": "APPROVE",
"nextState": "APPROVED",
"roles": [
"WS_APPROVER",
"SW_APPROVER"
],
"active": true
},
{
"tenantId": "pb.amritsar",
"currentState": "APPROVALPENDING",
"action": "REJECT",
"nextState": "REJECTED",
"roles": [
"WS_APPROVER",
"SW_APPROVER"
],
"active": true
},
{
"tenantId": "pb.amritsar",
"currentState": "APPROVALPENDING",
"action": "SEND_BACK",
"nextState": "PENDING_FOR_CITIZEN_ACTION",
"roles": [
"WS_APPROVER",
"SW_APPROVER"
],
"active": true
}
]
},
{
"tenantId": "pb.amritsar",
"sla": null,
"state": "REJECTED",
"applicationStatus": "INACTIVE",
"docUploadRequired": false,
"isStartState": false,
"isTerminateState": true,
"isStateUpdatable": false,
"actions": null
},
{
"tenantId": "pb.amritsar",
"sla": null,
"state": "APPROVED",
"applicationStatus": "ACTIVE",
"docUploadRequired": false,
"isStartState": false,
"isTerminateState": true,
"isStateUpdatable": false,
"actions": null
},
{
"uuid": "PENDING_FOR_CITIZEN_ACTION",
"tenantId": "pb.amritsar",
"sla": null,
"state": "PENDING_FOR_CITIZEN_ACTION",
"applicationStatus": "INWORKFLOW",
"docUploadRequired": false,
"isStartState": false,
"isTerminateState": false,
"isStateUpdatable": true,
"actions": [
{
"tenantId": "pb.amritsar",
"currentState": "PENDING_FOR_CITIZEN_ACTION",
"action": "RE-SUBMIT",
"nextState": "APPROVALPENDING",
"roles": [
"CITIZEN",
"SW_CEMP",
"WS_CEMP"
],
"active": true
}
]
}
]
}
]
}'
```
eg:--
List all the states from the process instances of the old workflow(business service) config.\
**select uuid,state from eg\_wf\_state\_v2 where businessserviceid=(select UUID from eg\_wf\_businessservice\_v2 where businessservice='BS.AMENDMENT' and tenantid='pb');**
| **uuid** | **state** |
| ------------------------------------ | ----------------------------- |
| 94055bb3-210c-4184-93ac-99e288ab00d9 | |
| b0fc6007-8b02-4753-8e50-1fdb29e559da | APPROVALPENDING |
| b9ea9101-09ff-4a8e-97c1-d43b3311af73 | REJECTED |
| ea5668ee-d8db-4c16-839b-64299e12f8fc | APPROVED |
| 468ce854-e19d-4a0f-97a0-66745f2034af | PENDING\_FOR\_CITIZEN\_ACTION |
List the states from the new business service created for replacement using this query\
\&#xNAN;***SELECT UUID, state FROM eg\_wf\_state where businessService='WS.AMENDMENT' AND business='WS***' ***AND tenantid='pb'***
***SELECT UUID, state FROM eg\_wf\_state where businessService='SW\.AMENDMENT' AND business='SW***' ***AND tenantid='pb'***
| **uuid** | **state** |
| -------- | ----------------------------- |
| New uuid | |
| New uuid | APPROVALPENDING |
| New uuid | REJECTED |
| New uuid | APPROVED |
| New uuid | PENDING\_FOR\_CITIZEN\_ACTION |
Replace the state-ids of the old workflow in the **eg\_wf\_processinstance** table with stateids of the new workflow.
Write an update query **(one for each state UUID)** to rewrite the process-instance table, as shown above - \
\&#xNAN;***update eg\_wf\_processinstance\_v2 set status={new state uuid} AND businessservice={WS.AMENDMENT} and modulename={WS} where businessservice={BS.AMENDMENT} and status={old state uuid} and businessid like '%WS%';***
***update eg\_wf\_processinstance\_v2 set status={new state uuid} AND businessservice={SW\.AMENDMENT} and modulename={SW} where businessservice={BS.AMENDMENT} and status={old state uuid} and businessid like '%SW%';***
{% hint style="info" %}
**Note:** businessid like '%SW% or businessid like '%WS% will be used depending on the New businessService that you are using. moduleName in the above query would take WS or SW in sync with the new businessService
{% endhint %}
* *The **status** and **businessservice** columns should be set to the new values from the newly created business-service master create based on the old status and id of the process-Instance.*
* Rename or delete the old business service **(BS.AMENDMENT)** to avoid any of the applications using it wrongly in future. \
{update eg\_wf\_businessservice set businessservice='**BS.AMENDMENT**-**deprecated**' where businessservice='**BS.AMENDMENT**'}
* UI/BACKEND will have to replace their configs to fetch the workflow configs for WS and SW.\
Changes required from UI:\
\&#xNAN;*Bill Amendment Workflow \_create and \_update APIs* - replace ***businessservice*** **BS.AMENDMENT** with **WS.AMENDMENT**/**SW\.AMENDMENT** and ***moduleName*** **BS** with **WS/SW** as per the requirement.\
\&#xNAN;*Bill Amendment Inbox* - replace ***businessservice*** **BS.AMENDMENT** with **WS.AMENDMENT**/**SW\.AMENDMENT** as per the requirement.
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.digit.org/local-governance/access/local-governance-stack/water-and-sewerage/water-services/workflow-config-replacement-data.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.