Planned Start Date and Planned End date from task table

[jwagner]

ServiceNow Gurus,

We have created a list based on the task table grouped by task type, but are having difficulty finding planned start and planned end dates to add to the list. We took this approach to make it easy for users to locate tasks assigned to them without searching various applications.

Example:

User is assigned incidents, change requests, projects tasks and would like to see them in one place.

Any help adding Planned Start and End Dates or educating us on philosophy is greatly appreciated.

Thanks,

Jeremy  

[Michael Ritchie · Accepted solution]

The challenge you face is Planned Start and Planned End don't exist on task.   They are attributes of tables that extend task like change_request, release, etc.   You can always search the Dictionary Entry table and look for fields that have the label you are looking for to see what tables they are on.   Here is what's available in my out of the box instance for Planned Start:

Work Start and Work End (aka Actual Start and Actual End) are attributes of task.   So you could use a business rule to populate those fields for consistency.

[Mwatkins]

You can still display a field from a child table in a list but you have to drill down to the child table to see the list of columns from that table. Before you can do that you need to activate a property called, glide.ui.list.allow_extended_fields. Then when you customize list layout the fields from extended tables will show up in red at the bottom of the slush bucket.

[Michael Ritchie]

Matthew, good point and its something I considered adding to my response but the problem with this approach is the task list will have many duplicate "Planned Start" and "Planned End" columns.   One for each extended table.   So there isn't a way to look for all records where "planned start" is this month and you would have to do that individually with each extended task field.

[Chuck Tomasi]

Another option might be to go to System Properties> UI Properties and check this box. It allows you to pick the fields on extended tables on a list of tasks.