Results 1 to 5 of 5

Thread: Report filter options

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #4
    Join Date
    Sep 2011
    Minneapolis, MN

    Default Re: Report filter options

    After not receiving any results with above filter, I adjusted the division selection list to include the brackets. Now I am getting some results, but not all.

    1. Selecting [CO], the report returns records that only contain [CO] in the column value.
      1. Code:
        SQL: (DAI_.Division IN ('[CO]'))

    2. Selecting [CO] and [PM], the report returns records that only contain one of the selected values, either [CO] or [PM], but not combination of more than 1, or a combination of both.
      1. Code:
        SQL: (DAI_.Division IN ('[CO]','[PM]'))

    Playing around inside an SQL View I found the right combination as an SQL Expression:
    (DAI_.Division LIKE '%CO%' OR DAI_.Division LIKE '%PM%')
    How would I accomplice that using multi-selection filters in a DynamicAI Report?
    Last edited by Benjamin; 6-Apr-2021 at 02:56 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts