I have successfully created a related list that queries a reference field from my destination table.
What I am having problems with are:
a) When my value is empty, it still queries the table for an empty value. Would like it not to query at all.
b) When trying to add an OR condition so that it adds a list variable to the query.
My code is as follows
if (parent.u_automated=='Yes')
current.addQuery('data', parent.u_data);
//This is what is not working
current.addQuery('data', parent.u_secondary);
else {
//Not sure how to return nothing. This works because they are two different fields, but not efficient.
current.addQuery('data', parent.u_name);
}
