Caleb Fong
03/01/2019, 5:21 PMcolumns: [
{
name: "trandate"
},
{
name: "closedate",
function: "ageInDays", // this funcition gives a numeric result (as in 5) instead of a MM/DD/YYYY
sort: nss.Sort.DESC
},
{
name: "tranid"
},
{
name: "entity"
}
],
filters: [
{
name: "mainline",
operator: "is",
values: ["T"]
},
{
name: "type",
operator: "anyof",
values: ["SalesOrd"]
},
{
name: "trandate",
operator: "on",
values: [the_date]
},
{
name: "closedate",
operator: ["LESSTHANOREQUALTO", "3"]
},
{
name: "trackingnumber",
operator: "isnotempty"
}
]