View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Database field RefId in table History - ProjeQtOr
 
 

Database field RefId in table History

More
18 Jan 2013 15:41 #1 by yassine
Hi again

i'd like to know the field idRef that exists in the table history how do you insert it.

and which is the relation between the table history and the table project (Refid)

would you just give me how you linked the project table and the history table

Thanks in advance

my best regards

Please Log in or Create an account to join the conversation.

More
18 Jan 2013 18:49 #2 by babynus
refType/redId are set in in the method store() of /model/history.php.
Lines of history table with refType='Project' and refId=x concern changes of project #x.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
21 Jan 2013 11:14 #3 by imenkolsi
Salut encore une fois,

Merci pour votre réponse

je cherchais une correspondance entre le projet en cours et le champ refType =

ProjectPlanningElement et le refID = 201 ( par exemple )

j'aimerai savoir comment trouver la relation entre le projet mis en question et

ces lignes dans la table History ?

La raison pour la quelle on cherche l'historique des modifications c'est pour fixer la

date changement du 'validatedWork'

Please Log in or Create an account to join the conversation.

More
21 Jan 2013 13:39 - 21 Jan 2013 13:39 #4 by babynus
PLEASE POST IN ENGLISH, SO THAT MOST OF COMMUNITY USERS CAN BENEFIT FROM THE POST.
___________________________________________________________________________________

If you have History with refType='ProjectPlanningElement' and refId=x,
you'll find a the referenced planningelement as id=x, this one has refType='Project', refId=y, so the project is the one with id=y.

Here is the model :

Babynus
Administrator of ProjeQtOr web site
Attachments:
Last edit: 21 Jan 2013 13:39 by babynus.
The following user(s) said Thank You: yassine

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.048 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.