...
| Table of Contents |
|---|
| minLevel | 3 |
|---|
| maxLevel | 6 |
|---|
| include | |
|---|
| outline | false |
|---|
| indent | |
|---|
| exclude | |
|---|
| type | list |
|---|
| printable | false |
|---|
| class | |
|---|
|
Image Modified
The primary keys are either:
...
| Code Block |
|---|
|
SELECT allocationprojectname, forecastfte
FROM forecast
WHERE
targetteamname = 'ABC App'
andAND sourceteamname = 'DB Solutioning'
ORDER BY allocationprojectname |
...
Example 1: Find all the company objectives.
| Code Block |
|---|
|
selectSELECT *
fromFROM objectives
whereWHERE objective_type = 'company-objective' |
Example 2: Find all the objectives with the parent of '1S3Q0WN2'
| Code Block |
|---|
|
selectSELECT *
fromFROM objectives
whereWHERE contains(parent_objective_ids,'1S3Q0WN2') |
...
Example 1: Find all the objectives linked to team Alpha.
| Code Block |
|---|
|
selectSELECT objective_id, objective_name
fromFROM team_objectives
whereWHERE team_name = 'Alpha' |
planning
...
| Code Block |
|---|
|
SELECT *
FROM projects
WHERE project_planner = true |
people
...
| Code Block |
|---|
|
SELECT team_name, team_id
FROM tag_teams
WHERE team_type = 'Agile Team'
AND tag_type = 'Interaction' |
...
| Code Block |
|---|
|
SELECT person_id, person_first_name, person_surname
FROM tag_people
WHERE tag_type = 'SPECIALIST_ROLE'
AND tag_value = 'Scrum Master' |
...
| Code Block |
|---|
|
SELECT left_id, left_name, association_tag_type, right_id, right_name
FROM associations
WHERE association_tag_type = 'RISK'
AND association_tag_value = 'financial risk' |
...