Sale stakeholders
•
Version: 7.1
Some tooltip text!
• 1 minute to read
• 1 minute to read
Note
This feature requires a Sales Premium license. For details, see the list of user plans.
Use your favorite query tool and try this query:
SELECT * FROM saletype where hasStakeholders = 1
If there are sales defined with stakeholders, you may search the database for these sales:
SELECT * FROM sale where saletype_id in (select saletype_id from saletype where hasStakeholders = 1)
For these sales we may look up the stakeholders, this will present the stakeholders for sale_id = 4
SELECT * FROM salestakeholder where sale_id = 4
| salestakeholder_id | sale_id | contact_id | person_id | rank | stakeholderrole_id | registered | ... |
|---|---|---|---|---|---|---|---|
| 1 | 4 | 2 | 25 | 0 | 1 | 2021-11-05 10:57:03 | |
| 2 | 4 | 2 | 31 | 0 | 1 | 2021-11-05 10:57:03 | |
| 3 | 4 | 2 | 22 | 0 | 1 | 2021-11-05 10:57:03 | |
| 21 | 4 | 34 | 191 | 0 | 1 | 2021-10-01 08:00:00 |