AnsweredAssumed Answered

Power Filter help with expression

Question asked by marlon on Mar 29, 2010
Latest reply on Apr 5, 2013 by navzjoshi00
Hi.   Am trying to setup a power filter on a portlet to compare a date field to today's date (ie., sysdate()).I can add (and it evaluates okay) the following:                   nsql.busdev_finish == date("sysdate()")  But when I submit to return to the portlet, it gives the error:      Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator.     There are some rows in the underlying NSQL query where the field above ('busdev_finish') are NULL, so am thinking maybe that's the issue??Anyone got any ideas to help with this?  Also wondering if there was any documentation on functions/structure etc on the allowed expressions?  Thanks.Marlon.

Outcomes