|
Topics
• Admission
• Assign MR#
• Change MR#
• Client Management
|
Table Definition - new table
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
- Envelope Definition (CWS)
- Table Definition (CWS)
Scenario 1: "Table Definition" Form - New table addition validations
Specific Setup:
- Have a system with modeled tables existing in both "PM" and "CWS" applications
- Using a database query program, connect to the "CWS" namespace and run the following query:
- 'Select tablecsmid from SQLUser.RadPlusCSMTable ORDER BY tablecsmid ASC'
- This will output all the table ID numbers (tablecsmid) for the tables existing in that namespace in numerical order. Make a note of the output. (Note: "SQL Query" in the cache "System Management Portal" can be used to execute the query, if access is accessible)
- Repeat the last step connected to the "PM" namespace. Make a note of the output
- Compare the output from the two namespaces in step 1 and 2
- Locate table with an ID# that exists in CWS that does not exist in PM
- Note the name and number of the table: For example: [CWSTestTableA (19)]
Steps
- In "Avatar CWS" open form "Table Definition"
- Select the table noted in the setup [CWSTestTableA]
- Navigate to the prompt 'Does this table require an associated table for the storage of binary information' field and set it to "Y", if it's not already
- In the 'Binary Storage Table Name' field enter a value (i.e. "Cwsbinary_Test"), if there's not a value already.
- Make note of the 'Binary Storage Table Name' field value [Cwsbinary_Test]
- Make a note of the envelope name in the "Envelope" field [CWSenvelopeA]
- Submit the form and exit
- In "Avatar CWS" open form "Envelope Definition" and select [CWSenvelopeA]
- Make a note of the value in the "SQL Schema" field [SYSTEMA]
- Exit the form
- Re-open form "Envelope Definition"
- Enter a new envelope name [CWSenvelopeB] and click to create the new envelope
- Select a value in the "Entity Database" field
- In the "SQL Schema" field, enter a different value than the one noted in n step 2a. [SYSTEMB]
- Set the 'Include Envelope within CDR' field to "Yes"
- Submit the form
- In "Avatar CWS" open form "Table Definition"
- In the search field, enter the name of the 'Binary Storage Table Name' field name noted in step 1c. For this test [Cwsbinary_Test]
- Click [New Avatar CWS Table]
- When prompted to select an "Envelope", select the envelope noted in step 2, [CWSenvelopeA]
- Click [OK]
- Validate the entry is accepted and the user is navigated to the table definition screen to create the new table
- Validate the "Table Name" field is populated with [Cwsbinary_Test]
- Populate all the required fields and any other desired fields
- Submit the form
- Validate the table submits successfully
|
Topics
• Modeling
|