Announcement

Collapse
No announcement yet.

Refined search not working with fields named YEAR in SQL Server

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Refined search not working with fields named YEAR in SQL Server

    Seems like link code is not properly generated when filtering for a field named YEAR. The SQL Select Statement under SQL section is enclosing the name of the field with quotes as seems YEAR is a command or reserved word in SQL Server, everything works fine except Refined Search not. I had to rename the field in database to solve this issue.

    Thanks.
Working...
X