Clarity

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.

Hi All,
 
Any feedback here for Marlon?  You may want to check with Support as well to see what docs they can provide.
 
Regards,
Chris

try something like this Marlon:   project.schedule_finish >= dateMacro("today")   you are trying to apply SQLish logic, not macroish logic: (power filters are not sql!)  sysdate() is was the giveaway :-)  A word of warning however, there is no formal support offered on use of "dateMacro" - don't know why.

Thanks Paul...works a treat!

paul,

as always, you are a legend. (+1)

sam.

Paul saves my bacon today 3 years after the original post...

I LOVE the CA Clarity Forums!

@Rob - and there was a follow-up (to that old post*);

PowerFilter - dateMacro

...which worked out the other functionality associated with "dateMacro".

(* - crickey!.... the things that I remember! :blink: )

Pretty nice posts, both !!! :*)

NJ