Clarity

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

Construct @param:user_def:date:myfield@ gives error writing dynamic lookup

  • 1.  Construct @param:user_def:date:myfield@ gives error writing dynamic lookup

    Posted Dec 04, 2024 12:00 PM

    Hi all.

    I'm writing a dynamic lookup using a parameter of type date with this syntax

    ... @WHERE:PARAM_USER_DEF:DATE:MYDATE@ ...

    but I receive the error: 

    SQL_SYNTAX_ERROR_DB_ERROR, Info: ERROR: could not determine data type of parameter $1 

    It looks like DATE datatype is not accepted in lookups.

    This is clarity 16.2.2 with postgres.

    Any idea how to use a date as a parameter in lookups.

    Thanks and regards

    Stefano