This content applies solely to Vendor Management, which must be purchased separately from the Appian base platform. |
IntroductionCopy link to clipboard
You can customize the Vendor Management solution to your organization's particular needs. The various interfaces in the out-of-the box solution contain dropdown lists that you can modify by changing the values in the reference data tables with values that reflect the data that is unique to your processes. For example, you can add or delete values that display in the Task Type dropdown list.
This page outlines how to modify the values for the dropdown lists in the various interfaces of the VM solution.
- If you need to add a value to a particular dropdown list, add a row to the reference data table. See the Adding a new dropdown value section.
- If you need to remove a value from a dropdown list, deactivate the value in the reference data table. See the Deactivating a new dropdown value section.
- If you want to add a new dropdown list, create a new dropdown list type in the reference data table. See the Adding a new dropdown list section.
See the Reference Data Tables page for descriptions of the table structures.
Adding a new dropdown valueCopy link to clipboard
Most dropdown values for VM are stored in the AS_VM_R_DATA
table. Updating this table allows you to control which dropdown values and lists display to end users moving through the opportunity management process.
To add a value to a dropdown list:
- Insert a new row into the
AS_VM_R_DATA
table. - Update each column with the following information:
REF_LABEL
: The new value you are adding.REF_TYPE
: A grouping category for the dropdown values; a name for the dropdown list.SORT_ORDER
: Optional field that is used to specify the sort order.- Note: In order to implement the sort order, you will have to update the queries applied to this column.
REF_ICON
: Optional field that is used to specify an icon for this entry.REF_COLOR
: Optional field that is used to specify the icon color.IS_ACTIVE
: true (1).CREATED_BY
: Your Appian username.CREATED_DATETIME
: The current timestamp in the YYYY-MM-DD HH:MM:SS format.MODIFIED_BY
: Your Appian username.MODIFIED_DATETIME
: The current timestamp in the YYYY-MM-DD HH:MM:SS format.
After the row is inserted, this value will be available in any of the dropdown lists that have the same reference REF_TYPE
as the value you inserted.
ExampleCopy link to clipboard
To add a new dropdown value, you could use the following SQL statement by replacing the values in the angle brackets (< >)
with your data.
1
2
3
4
INSERT INTO `AS_VM_R_DATA` (`REF_DATA_ID`, `REF_LABEL`, `REF
_TYPE`, `IS_ACTIVE`, `CREATED_BY`, `CREATED_DATETIME`, `MODIFIED_BY`, `MODIFIED_DATETIME`)
VALUES (null, '<New Label>', '<Type>', 1, '<Username>', CURRENT_TIMESTAMP(), '<Username>', CURRENT_TIMESTAMP()),
(null, '<New Label>', '<Type>', 1, '<Username>', CURRENT_TIMESTAMP(), '<Username>', CURRENT_TIMESTAMP());
Copy
Deactivating a dropdown valueCopy link to clipboard
If there is a value in a dropdown list that is no longer needed, deactivate the value by changing the IS_ACTIVE
value in the AS_VM_R_DATA
from 1 (true) to 0 (false).
After the update is made, this value will no longer display in any dropdown list. The value will continue to display for already active and historical opportunities.
Deactivating an opportunity status or task status is not recommended, as it will negatively affect other aspects of the application. Deleting data from the table is not recommended except during initial set up. If the application is already in use, deleting data rather than deactivating it may cause issues.
ExampleCopy link to clipboard
To deactivate a dropdown value, you could use the following SQL statement. Replace <ID Being Updated>
with the R_DATA_ID
value. For example, to deactivate Weeks in the following table, <ID Being Updated>
would be 24.
R_DATA_ID | LABEL | TYPE | IS_ACTIVE |
---|---|---|---|
22 | Hours | Item Duration Unit | 1 |
23 | Days | Item Duration Unit | 1 |
24 | Weeks | Item Duration Unit | 1 |
Note that this example uses MySQL syntax.
1
UPDATE AS_VM_R_DATA SET IS_ACTIVE = 0 WHERE R_DATA_ID = <ID Being Updated>
Copy
Adding a new dropdown listCopy link to clipboard
If you want to add a new dropdown list, you need to create a new dropdown list type. There are two main steps to add a new dropdown list:
- Add a new row to the
AS_VM_R_DATA
table. See Adding new dropdown values for instructions on how to add new rows.- For the value in the
REF_TYPE
column, enter a name for the new dropdown list, such as Entity Region.
- For the value in the
- Create a constant in the application to query this from the database. See Using a new dropdown list in the application for instructions on how to set this up.
Using a new dropdown list in the applicationCopy link to clipboard
After a new dropdown list type has been added to the AS_VM_R_DATA
table, it will need a constant to point to it in order to be used in interfaces.
- Go to the
AS VM Baseline
application in Appian Designer. - Create a new constant called
AS_VM_REF_TYPE_<NEW_DROPDOWN_LIST_TYPE>
. For exampleAS_VM_REF_TYPE_OPPORTUNITY_STATUS
.- Type: Text
- Value:
<New Dropdown List Type>
- Note: Be sure this matches the dropdown list name in the
REF_TYPE
column of theAS_VM_R_DATA
table exactly. For example, if the name in theREF_TYPE
column is Evaluation Status, the value here must be the same.
- Note: Be sure this matches the dropdown list name in the
- Save it in the
AS VM SAIL Design Objects
folder.
After the dropdown list constant has been created, the list is ready to be used by the AS_VM_QE_getRefDataByType
rule. This rule pulls all of the reference data onto the interface that needs a reference value. AS_VM_QE_getRefDataByType
takes in typelist—an array of text—corresponding to the type values in the database you need to use.
ExampleCopy link to clipboard
To pull in the Evaluation Status dropdown list, you would use the rule as shown below:
1
2
3
4
5
6
local!refData: rule!AS_VM_QE_getRefDataByType(
refTypes: {
/* Evaluation Status */
cons!AS_VM_REF_TYPE_OPPORTUNITY_STATUS,
}
)
Copy
As shown in the example, you can pass in either text or a constant of type text
with the corresponding dropdown list type.
Other reference data tablesCopy link to clipboard
There are several other tables that contain reference data that appear in lists. The information stored in these tables are universal and shouldn't change often. However, if you ever have to change the list of countries, currencies, industry classification codes, or states, refer to the below tables.
- AS_VM_R_Country
- A list of countries
- AS_VM_R_State
- A list of US states
- AS_VM_R_DocumentTemplate
- A list of document templates used to create opportunity documents