Forum

Database field RefI...
 
Notifications
Clear all

Database field RefId in table History

4 Posts
3 Users
0 Reactions
5,067 Views
(@yassine)
Posts: 26
Active Member
Topic starter
 
[#900]

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


 
Posted : 18 Jan 2013 17H41
(@babynus)
Posts: 14952
Member Admin
 

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.


 
Posted : 18 Jan 2013 20H49
 imen
(@imenkolsi)
Posts: 37
Active Member
 

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'


 
Posted : 21 Jan 2013 13H14
(@babynus)
Posts: 14952
Member Admin
 

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 :


 
Posted : 21 Jan 2013 15H39
Share:

Scroll to Top