User Tools

Site Tools


support_request_application_database_tables

This is an old revision of the document!


Support Request Application Config Tables

config_entry

idDescriptionNameValueFurther Details
1Customer - VisibilityVISIBILITYAirgainDetermine market visibility ticket is opened in
2Customer - WorkflowWORKFLOWAirgain Support RequestDetermine workflow visibility ticket is opened in
3Customer - Workflow Initial StatusSTART_STATUSTriageState ticket starts in
4Customer - Workflow Final StatusFINAL_STATUSResolvedState ticket ends in
5Customer - Workflow Status that indicating ticket is waiting for customer to response.AWAITING_STATUSAwaiting Response From Customer,Awaiting VerificationThese are the Status that when customer response the Support Request will auto move ticket to the Response Status (Customer Response Provided)
6Customer - Workflow Status that indicating customer has provided response.RESPONSE_STATUSCustomer Response ProvidedThe status that the Status shown in “Response Status” will be moved to
7Indicating days that closed ticket will return.CLOSED_DAYS45How many days Tickets considered closed ( Resolved or Cancelled) will be visible in the Support Request. ATC have their set to a year
8Forms that are visible to customer.CUSTOMER_VISIBLE_FORMSCustomer Update,Operation UpdateForms that are shown in the Support Request App
9Support Request Form NameREQUEST_FORM_NAMESupport Request DetailsForm used to write / add to ticket on creation
10Support Request Form Requester Email Field NameREQUEST_EMAIL_FIELDrequesterField the requesters emails is populated
11Support Request Form Issue Title Field NameREQUEST_TITLE_FIELDtitleField the title is populated
12Support Request Form Issue Description Field NameREQUEST_DESCRIPTION_FIELDdescriptionField the description is populated
13Support Request Form Affected Application Field NameREQUEST_APPLICATION_FIELDapplicationField the requesters emails is populated
14Support Request Form If Email Copy to Requester Field NameREQUEST_COPY_REQUESTER_FIELDcopy_requesterNot used anymore, was used when we gave submitter option if they wanted to be added to notifications
15Support Request Form Email CC Address Field NameREQUEST_CC_FIELDemail_ccField the requesters emails is populated
16Support Request Form Related Tickets Fields NameREQUEST_RELATED_TICKETS_FIELDSrelated_support,related_developmentWhere the Related tickets fields in Ticket details page pulls data from
17Customer Update Form NameCUSTOMER_UPDATE_FORM_NAMECustomer UpdateCustomer Update Form
18Customer Update Form Sender Email Field NameCUSTOMER_UPDATE_FORM_EMAIL_FIELDcustomer_update_emailCustomer Update Form
19Customer Update Form Message Field NameCUSTOMER_UPDATE_FORM_MESSAGE_FIELDcustomer_updateCustomer Update Form
20Customer Update Form Request Ticket to Close Field NameCUSTOMER_UPDATE_FORM_CLOSE_FIELDclose_requestedCustomer Update Form
21Customer Update Form Sender Name Field NameCUSTOMER_UPDATE_FORM_NAME_FIELDcustomer_update_nameCustomer Update Form
22Support Request Form POC Field NameREQUEST_POC_FIELDcustomer_contactCustomer Update Form
23Support Request Form Billable Field NameREQUEST_BILLABLE_FIELDbillableWhere the billable status is pulled from ( Support Request Details)
24Indicate if the environment is for multiple customers.MULTI_CUSTOMER_ENVFALSEIf true then logic to limted what user sees will be determined by thier access such as emails and tickets
25Support Request Form Last Update Field NameREQUEST_LAST_UPDATE_FIELDlatest_updateThis reads the latest update field (ticket_update)
26Customer - Workflow Status that indicating the ticket is either resolved or cancelled.CLOSED_STATUSESResolved,CancelledDetermines what states are the closed status
27Resolution Form NameRESOLUTION_FORM_NAMEResolution FormForm that is used for the Resolution tab
28Resolution Form Work DetailsRESOLUTION_DETAILS_FIELDwork_detailsForm that is used for the Resolution tab
29Resolution Form Date ResolvedRESOLUTION_DATE_FIELDdate_resolvedForm that is used for the Resolution tab
30List all the users have permission to access My Company page(split by comma)ADMIN_USERSUSER IDS HEREUsed to be used to determine of user can see the My Company option
31Support Request Form Company Field NameREQUEST_COMPANY_FIELDsco_companyUsed on multi Tenant ( SCO) environment , on ticket create uses customers company details and adds it to the sco_company field on the support request details form
32System admin user email regex which allow to access all SCO tickets regardless company.SYS_ADMIN_EMAIL System admin user email regex which allow to access all SCO tickets regardless company.
33Customer - Workflow Pending Approval StatusPENDING_APPROVAL_STATUSPending ApprovalStatus that determines if the approval billable hours is visible on the Customer Update form
34Customer Update Form Request Ticket to Approve Billable HoursCUSTOMER_UPDATE_FORM_BILLABLE_APPROVEDbillable_approvedRelates to the Customer Update form
35Support Request Form External key Field NameREQUEST_EXTERNAL_KEYexternal_keyOn ticket create an external key is generated and added to the external key field on the support request details form. This is used to allow users that don't have a log view the ticket.
36Support Request Form Notes Field NameREQUEST_NOTES_FIELDnotesWhere the notes field in Ticket details is populated from ( Support Request Details )
37Support Request Form Classification Field NameREQUEST_CLASSIFICATION_FIELDclassificationWhere the classification field shown on My Tickets/My Company details is populated from ( Support Request Details )
38Support Request General Ticket ClassificationGENERAL_TICKET_CLASSIFICATIONGeneral Support RequestDefault ticket classification

field_config

idfield_namehiddenmatch_valueform_idUsed For
support_request_application_database_tables.1687524077.txt.gz · Last modified: 2023/06/23 13:41 by 10.91.129.7