I really like using addFoundSetFilterParam() to filter related foundsets, but run into problems when filtering for a column that contains a non-blank value. I do this:
lofsfees.addFoundSetFilterParam('feeauthno','!=', null);
lofsfees.addFoundSetFilterParam('feeauthno','!=', '');
lofsfees.addFoundSetFilterParam('feeauthno','NOT LIKE', ' %');
But it seem like a lot of work, especially if filtering on more than one column. Is there an easier way than testing individually for nulls, empty strings, AND blank values (and even this only check that the first character is blank, not the entire column)?