URL filtering not working right after update

  • Resolved ynpmoose

    (@ynpmoose)


    3 years, 8 months ago

    Data Publisher pages are not longer honoring URL filters after yesterday’s update.
    example: ?wpda_search_column_Year=2021&wpda_search_column_User=joe.smith%40company.com

    I’m also now trying to add URL filtering to a data project page and it’s not working either.

    Thanks

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter ynpmoose

    (@ynpmoose)

    Hmm, I was making other changes too. It appears Data Access URL parameters don’t like when I use WHERE Employee=$$USER$$ OR Manager = $$USER$$, but are fine if I only use Employee=$$USER$$

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi @ynpmoose,

    When you use an OR condition in your default where clause, your URL parameters will be added with an AND condition after the OR. That AND condition will have precedence over your OR condition, not giving the expected result. Please and round brackets around your OR:
    WHERE ( Employee=$$USER$$ OR Manager = $$USER$$ )

    Does this solve your issue?

    Please let me know,
    Peter

    Thread Starter ynpmoose

    (@ynpmoose)

    Yes, thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘URL filtering not working right after update’ is closed to new replies.