Hi There,Hope you're having a good day.I've been working on setting up a template project (Project ID 21) with some pre-existing planning information. I'd like to reset the planned start date, end date, and duration for these template tasks to be null or zero so they can be easily customized for new projects.I was considering using the following SQL update statement to achieve this:update planningelement set plannedStartDate=null, plannedEndDate=null, Plannedduration=0
where idproject=21 and (plannedStartDate is not null or plannedEndDate is not null or ifnull(Plannedduration,0)<>0) ;Before I proceed, I wanted to humbly ask for your expert guidance. I'm a little unsure about any potential knock-on effects this might have on other related data or functionalities. Would you mind taking a quick look to see if you foresee any potential issues or have any suggestions for a better approach? I really appreciate you taking the time to help me with this, especially since you're so generously providing this support without charge.
Thank you so much for your consideration!Best regards,
Thank you for the suggestion – using the multiple update feature for activities was my first thought as well. I tried to use it to update the planningelement, plannedStartDate, plannedEndDate, and Plannedduration fields, but they don't seem to be present in the options. I've attached a screenshot; am I missing something, or is there a specific configuration needed to access these fields?
The "planned" values are readonly, as they are calculated by planning calcvulation process.
Just go to Gantt view and calculate planning to update these fields.
En poursuivant votre navigation, vous acceptez le dépôt de cookies tiers destinés au bon fonctionnement et à la sécurisation du site (gestion de session, reCaptcha) et à une analyse statistique anonymisée des accès sur notre site (Google Analytics). Si vous vous inscrivez, les informations que vous fournirez ne seront jamais divulguées à un tiers sous quelque forme que ce soit. En savoir plus
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.