KnowledgeSync Ideas

Ideas for the KnowledgeSync software product including EventPaks.

The ability to close the parenthesis at the end of the Compare Value on the Filters

Currently if you try and close the parentesis at the end of the Compare Value it will put it prior to the Apostrophe instead of after. Example (WHERE dbo.Job.Customer = 'operations' OR dbo.Job.Customer like 'R&D%' OR dbo.Job.Customer like 'FX%)' it should be WHERE dbo.Job.Customer = 'operations' OR dbo.Job.Customer like 'R&D%' OR dbo.Job.Customer like 'FX%')

  • Andy Knebel
  • Sep 21 2020
  • Already exists
  • Attach files
  • Andy Knebel commented
    September 22, 2020 14:05

    Hello David,

    That worked, Thank You

    Attachments Open full size
  • David Austin commented
    September 22, 2020 14:00

    Thanks for submitting the idea. Would you check if you might have the filter type set to “Char”? That is the default if the database field is a string data type. If you want KS to use the filter as-is, set the filter type to “Literal”.

    Attachments Open full size

Related ideas