Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Script for baseline view from today's Unlocking the Mysteries of Date Management webinar

Avatar

Level 3
Could someone share with me the s cript code for the baseline view that Chris Berry used in today's webinar called Unlocking the Mysteries of Date Management? We tried the code on the below linked page, but it is not the same:
2 Replies

Avatar

Level 10
Hi Wayne, I've not seen Chris B's video (sounds like a good one), so this will be a shot in the dark, but in case you're still looking, I've pasted a couple of baseline task views below for you to try. The second one is prettier. Regards, Doug -------------- column.0.descriptionkey=name column.0.isInlineEditable=false column.0.link.linkproperty.0.name=ID column.0.link.linkproperty.0.valuefield=ID column.0.link.linkproperty.0.valueformat=int column.0.link.lookup=link.view column.0.link.valuefield=objCode column.0.link.valueformat=val column.0.linkedname=direct column.0.listsort=string(name) column.0.namekey=name.abbr column.0.querysort=name column.0.shortview=false column.0.stretch=100 column.0.valuefield=name column.0.valueformat=HTML column.0.width=150 column.1.descriptionkey=view.relatedcolumn column.1.descriptionkeyargkey.0=defaultbaseline column.1.descriptionkeyargkey.1=plannedstartdate column.1.displayname=Baseline Start column.1.isInlineEditable=false column.1.linkedname=defaultBaseline column.1.listsort=nested(defaultBaseline).atDateAsAtDate(plannedStartDate) column.1.namekey=view.relatedcolumn column.1.namekeyargkey.0=defaultbaseline column.1.namekeyargkey.1=plannedstartdate column.1.querysort=defaultBaseline:plannedStartDate column.1.shortview=false column.1.stretch=0 column.1.valuefield=defaultBaseline:plannedStartDate column.1.valueformat=atDate column.1.width=75 column.10.descriptionkey=budgetalias column.10.displayname=Current Budget column.10.isInlineEditable=false column.10.linkedname=direct column.10.listsort=doubleAsDouble(budget) column.10.namekey=budgetalias.abbr column.10.querysort=budget column.10.shortview=false column.10.stretch=0 column.10.valuefield=budget column.10.valueformat=currencyStringCurrency column.10.viewalias=budgetalias column.10.width=100 column.2.descriptionkey=actualstartdate column.2.displayname=Actual Start column.2.isInlineEditable=false column.2.linkedname=direct column.2.listsort=atDateAsAtDate(actualStartDate) column.2.namekey=actualstartdate.abbr column.2.querysort=actualStartDate column.2.shortview=false column.2.stretch=0 column.2.valuefield=actualStartDate column.2.valueformat=atDate column.2.width=75 column.3.descriptionkey=view.relatedcolumn column.3.descriptionkeyargkey.0=defaultbaseline column.3.descriptionkeyargkey.1=plannedcompletiondate column.3.displayname=Baseline Finish column.3.isInlineEditable=false column.3.linkedname=defaultBaseline column.3.listsort=nested(defaultBaseline).atDateAsAtDate(plannedCompletionDate) column.3.namekey=view.relatedcolumn column.3.namekeyargkey.0=defaultbaseline column.3.namekeyargkey.1=plannedcompletiondate column.3.querysort=defaultBaseline:plannedCompletionDate column.3.shortview=false column.3.stretch=0 column.3.valuefield=defaultBaseline:plannedCompletionDate column.3.valueformat=atDate column.3.width=75 column.4.descriptionkey=projectedcompletiondate column.4.displayname=Projected Finish column.4.isInlineEditable=false column.4.linkedname=direct column.4.listsort=atDateAsAtDate(projectedCompletionDate) column.4.namekey=projectedcompletiondate.abbr column.4.querysort=projectedCompletionDate column.4.shortview=false column.4.stretch=0 column.4.valuefield=projectedCompletionDate column.4.valueformat=atDate column.4.width=75 column.5.descriptionkey=view.relatedcolumn column.5.descriptionkeyargkey.0=defaultbaseline column.5.descriptionkeyargkey.1=workrequired column.5.displayname=Baseline Effort column.5.isInlineEditable=false column.5.linkedname=defaultBaseline column.5.listsort=doubleAsDouble(workRequired) column.5.namekey=view.relatedcolumn column.5.namekeyargkey.0=defaultbaseline.abbr column.5.namekeyargkey.1=workrequired.abbr column.5.querysort=defaultBaseline:workRequired column.5.shortview=false column.5.stretch=0 column.5.valuefield=defaultBaseline:workFieldLong column.5.valueformat=compound column.5.viewalias=defaultBaseline:workrequired column.5.width=75 column.6.descriptionkey=workrequired column.6.displayname=Current Effort column.6.isInlineEditable=false column.6.linkedname=direct column.6.listsort=doubleAsDouble(workRequired) column.6.namekey=workrequired.abbr column.6.querysort=workRequired column.6.shortview=false column.6.stretch=0 column.6.valuefield=workFieldLong column.6.valueformat=compound column.6.viewalias=workrequired column.6.width=75 column.7.descriptionkey=view.relatedcolumn column.7.descriptionkeyargkey.0=defaultbaseline column.7.descriptionkeyargkey.1=plannedcost column.7.displayname=Baseline Cost column.7.isInlineEditable=false column.7.linkedname=defaultBaseline column.7.listsort=doubleAsDouble(plannedCost) column.7.namekey=view.relatedcolumn column.7.namekeyargkey.0=defaultbaseline.abbr column.7.namekeyargkey.1=plannedcost.abbr column.7.querysort=defaultBaseline:plannedCost column.7.shortview=false column.7.stretch=0 column.7.valuefield=defaultBaseline:plannedCost column.7.valueformat=currencyStringCurrency column.7.viewalias=defaultBaseline:plannedcost column.7.width=100 column.8.descriptionkey=actualcost column.8.displayname=Cost to Date column.8.isInlineEditable=false column.8.linkedname=direct column.8.listsort=doubleAsDouble(actualCost) column.8.namekey=actualcost.abbr column.8.querysort=actualCost column.8.shortview=false column.8.stretch=0 column.8.valuefield=actualCost column.8.valueformat=currencyStringCurrency column.8.viewalias=actualcost column.8.width=100 column.9.descriptionkey=view.relatedcolumn column.9.descriptionkeyargkey.0=defaultbaseline column.9.descriptionkeyargkey.1=budget column.9.displayname=Baseline Budget column.9.isInlineEditable=false column.9.linkedname=defaultBaseline column.9.listsort=nested(defaultBaseline).doubleAsDouble(budget) column.9.namekey=view.relatedcolumn column.9.namekeyargkey.0=defaultbaseline column.9.namekeyargkey.1=budget column.9.querysort=defaultBaseline:budget column.9.shortview=false column.9.stretch=0 column.9.valuefield=defaultBaseline:budget column.9.valueformat=doubleAsString column.9.width=100 -------------------- column.0.descriptionkey=referencenumber column.0.isInlineEditable=false column.0.linkedname=direct column.0.listsort=intAsInt(referenceNumber) column.0.namekey=referencenumber.abbr column.0.querysort=referenceNumber column.0.shortview=false column.0.stretch=0 column.0.valuefield=referenceNumber column.0.valueformat=int column.0.width=75 column.1.descriptionkey=name column.1.displayname=Project column.1.link.linkproperty.0.name=ID column.1.link.linkproperty.0.valuefield=ID column.1.link.linkproperty.0.valueformat=int column.1.link.lookup=link.view column.1.link.valuefield=objCode column.1.link.valueformat=val column.1.linkedname=direct column.1.listsort=string(name) column.1.namekey=name.abbr column.1.querysort=name column.1.shortview=false column.1.stretch=50 column.1.valuefield=name column.1.valueformat=HTML column.1.width=150 column.10.descriptionkey=plannedcost column.10.displayname=Cost Variance column.10.linkedname=direct column.10.listsort=doubleAsDouble(plannedCost) column.10.namekey=plannedcost.abbr column.10.querysort=plannedCost column.10.shortview=false column.10.stretch=0 column.10.styledef.case.0.comparison.attribute=css column.10.styledef.case.0.comparison.isrowcase=false column.10.styledef.case.0.comparison.leftmethod=doubleAsDouble(plannedCost) column.10.styledef.case.0.comparison.lefttext=plannedCost column.10.styledef.case.0.comparison.operator=notnull column.10.styledef.case.0.comparison.operatortype=double column.10.styledef.case.0.comparison.righttext= column.10.styledef.case.0.comparison.trueproperty.0.name=bgcolor column.10.styledef.case.0.comparison.trueproperty.0.value=E1E1E1 column.10.styledef.case.0.comparison.truetext= column.10.styledef.case.0.comparison.usefield=false column.10.valueexpression=SUB({actualCost},{plannedCost}) column.10.valueformat=currencyStringCurrency column.10.width=100 column.11.descriptionkey=plannedrevenue column.11.isInlineEditable=false column.11.linkedname=direct column.11.listsort=doubleAsDouble(plannedRevenue) column.11.namekey=plannedrevenue.abbr column.11.querysort=plannedRevenue column.11.shortview=false column.11.stretch=0 column.11.valuefield=plannedRevenue column.11.valueformat=currencyStringCurrency column.11.viewalias=plannedrevenue column.11.width=100 column.12.descriptionkey=actualrevenue column.12.isInlineEditable=false column.12.linkedname=direct column.12.listsort=doubleAsDouble(actualRevenue) column.12.namekey=actualrevenue.abbr column.12.querysort=actualRevenue column.12.shortview=false column.12.stretch=0 column.12.valuefield=actualRevenue column.12.valueformat=currencyStringCurrency column.12.viewalias=actualrevenue column.12.width=100 column.13.descriptionkey=plannedrevenue column.13.displayname=Revenue Variance column.13.linkedname=direct column.13.listsort=doubleAsDouble(plannedRevenue) column.13.namekey=plannedcost.abbr column.13.querysort=plannedRevenue column.13.shortview=false column.13.stretch=50 column.13.styledef.case.0.comparison.attribute=css column.13.styledef.case.0.comparison.isrowcase=false column.13.styledef.case.0.comparison.leftmethod=doubleAsDouble(plannedRevenue) column.13.styledef.case.0.comparison.lefttext=plannedRevenue column.13.styledef.case.0.comparison.operator=notnull column.13.styledef.case.0.comparison.operatortype=double column.13.styledef.case.0.comparison.righttext= column.13.styledef.case.0.comparison.trueproperty.0.name=bgcolor column.13.styledef.case.0.comparison.trueproperty.0.value=E1E1E1 column.13.styledef.case.0

Avatar

Level 1

Thanks Doug! I somehow thought this was already posted from my webinar -- for anyone interested in the original code from the webinar, here go ==> right here . Chris Berry Workfront