06-04-2010 04:05 AM
yes you are right.Theoretically all the users related to an entity should be reposited in that table,at least DataModel.pdf says that.
But in real,there is no user in the knta_users table related to trustee_id of the itg_trustee table.In datamodel.pdf,it says that trustee_id must match a USER_ID
In fact i want to find all the projects in which a user is chosen as a stakeholder.
06-04-2010 04:08 AM
06-04-2010 04:57 AM
this is very usefull information for me.
But is there any package that gets the stakeholder's name or id as an input and gives the names of the projects related to that stakeholder.
i want to go vice versa.
06-04-2010 05:31 AM
SELECT * FROM pm_projects
And put the user_id of the user you're doing the lookup for where the 30004 is.