Table Plots - Value Expression Error

Relates to versions - 1.6.6+

This documentation illustrates the error that occurs in Table Plots in Spry i.e. "Value Expression has an error: All nodes have default values appears when a field does not have a value".

This error occurs when the range on which the table plot is running has several nodes that the Post Schedule Tasks aren't writing too which is why these records aren't having a start date or end date written to them. Instead they have the default date (Null Date) i.e. 01/01/0001.

Steps to Overcome

1) When generating table plots, there shouldn't be any Null or default date values, to fix this issue kindly put in a check in the expression filter to only look at records past that default/null date, some expression like this (highlighted in the below image).

2) After completing Step 1, the new expression i.e. GetValue(PostScheduleEndDate) > #01 Jan 0001# when used in the new range will generate the layer by ignoring all those nodes with start dates that are 01/01/0001.

The above steps once completed will rectify the value expression error and all default (Null) dates will not hinder the creation of table plots in Spry.

Want to learn more?

Click here to login to our Learning Management System

Click here to request access