i have the following custom filter that works great except when multiple hold status's are selected (this is a required field, that can have 1 or multiple selections)
this is the section in question, it is the start of the filter (and is required)
how do i set this up if multiple selections are picked...also is there a way to debug this script using f12?
{
filter = getTo('HOLDSTATUS') + " = '" + holdstatus + "'";
}
below is the entire script
let fromCreateDate =getFrom('FROM_CDAT'),
toCreateDate = getFrom('TO_CDAT'),
holdtype = getFrom('HDTYPE'),
holdlevel = getFrom('HDLEVEL'),
custpo = getFrom('HDCUSPO'),
custno = getFrom('HDECUST#'),
assignuser = getFrom('HDASUSR'),
state = getFrom('C9SSTAT'),
eBidNumber = getFrom('HDEORDR'),
holdstatus = getFrom('HOLDSTATUS')
filter = '';
{
filter = getTo('HOLDSTATUS') + " = '" + holdstatus + "'";
}
if (fromCreateDate && fromCreateDate!=='0001-01-01'){
if (filter) filter += " AND ";
filter += getTo('HDORDDT') + " >= '" + fromCreateDate + "'";
}
if (toCreateDate && toCreateDate !== '0001-01-01') {
if (filter) filter += " AND ";
filter += getTo('HDORDDT') + " <= '" + toCreateDate + "'";
}
if (eBidNumber) {
if (filter) filter += " AND ";
filter += getTo('HDEORDR') + " = '" + eBidNumber + "'";
}
if (holdtype) {
if (filter) filter += " AND ";
filter += getTo('HDTYPE') + " = '" + holdtype + "'";
}
if (holdlevel) {
if (filter) filter += " AND ";
filter += getTo('HDLEVEL') + " = '" + holdlevel + "'";
}
if (custpo) {
if (filter) filter += " AND ";
filter += getTo('HDCUSPO') + " = '" + custpo + "'";
}
if (custno) {
if (filter) filter += " AND ";
filter += getTo('HDECUST#') + " = '" + custno + "'";
}
if (assignuser) {
if (filter) filter += " AND ";
filter += getTo('HDASUSR') + " = '" + assignuser + "'";
}
if (state) {
if (filter) filter += " AND ";
filter += getTo('C9SSTAT#') + " = '" + state + "'";
}
return filter;
this is the section in question, it is the start of the filter (and is required)
how do i set this up if multiple selections are picked...also is there a way to debug this script using f12?
{
filter = getTo('HOLDSTATUS') + " = '" + holdstatus + "'";
}
below is the entire script
let fromCreateDate =getFrom('FROM_CDAT'),
toCreateDate = getFrom('TO_CDAT'),
holdtype = getFrom('HDTYPE'),
holdlevel = getFrom('HDLEVEL'),
custpo = getFrom('HDCUSPO'),
custno = getFrom('HDECUST#'),
assignuser = getFrom('HDASUSR'),
state = getFrom('C9SSTAT'),
eBidNumber = getFrom('HDEORDR'),
holdstatus = getFrom('HOLDSTATUS')
filter = '';
{
filter = getTo('HOLDSTATUS') + " = '" + holdstatus + "'";
}
if (fromCreateDate && fromCreateDate!=='0001-01-01'){
if (filter) filter += " AND ";
filter += getTo('HDORDDT') + " >= '" + fromCreateDate + "'";
}
if (toCreateDate && toCreateDate !== '0001-01-01') {
if (filter) filter += " AND ";
filter += getTo('HDORDDT') + " <= '" + toCreateDate + "'";
}
if (eBidNumber) {
if (filter) filter += " AND ";
filter += getTo('HDEORDR') + " = '" + eBidNumber + "'";
}
if (holdtype) {
if (filter) filter += " AND ";
filter += getTo('HDTYPE') + " = '" + holdtype + "'";
}
if (holdlevel) {
if (filter) filter += " AND ";
filter += getTo('HDLEVEL') + " = '" + holdlevel + "'";
}
if (custpo) {
if (filter) filter += " AND ";
filter += getTo('HDCUSPO') + " = '" + custpo + "'";
}
if (custno) {
if (filter) filter += " AND ";
filter += getTo('HDECUST#') + " = '" + custno + "'";
}
if (assignuser) {
if (filter) filter += " AND ";
filter += getTo('HDASUSR') + " = '" + assignuser + "'";
}
if (state) {
if (filter) filter += " AND ";
filter += getTo('C9SSTAT#') + " = '" + state + "'";
}
return filter;