Shortcode sql_where and filter for WP Data Access

  • vasut

    (@vasut)


    3 years, 9 months ago

    Hi Peter,
    Looks like sql_where which worked a few days ago no longer works now.
    No matter what clause condition it always returns all rows.
    Was it taken out for a security reason? I saw that notification some where.

    Also, this code returns empty list:
    [wpdataaccess pub_id=”1″ filter_field_name=”USER_ROLE” filter_field_value=”Cybernetic-Scientist”]

    And this returns all rows:
    [wpdataaccess pub_id=”1″]

    I believe I followed the sample correctly and the field_value does exist more than one row.
    There’s no upgrade required to the plugin for filter to work, right?

    Best Regards,
    Vasut

Viewing 16 replies (of 16 total)
1 2
  • Thread Starter vasut

    (@vasut)

    3 years, 9 months ago

    Sounds good, Peter.
    And that’s a good idea on using publications to hide all the parameters.

    I was also thinking, maybe, if Views type of table can be dynamically created in the background and referred to as a prepared report when user selects a report.
    But, then the pub_id is static. Would that work?

    I’m still not clear how operators like OR, IN, and LIKE would be used in Filter params?

    I’ll send you the message with private email through the plugin contactForm.

    Thank you!
    Vasut

Viewing 16 replies (of 16 total)
1 2
  • The topic ‘Shortcode sql_where and filter for WP Data Access’ is closed to new replies.