Filter is off by one…

  • Resolved huotg01

    (@huotg01)


    8 years, 4 months ago

    Hi!

    I setup a field named “District” with values from 1 to 10

    When I filter (on the list participants) for, let’s say district 7, the system displays records with district 8. Il fact it is always the searched district number+1.

    The filter is: “District” that “is” “7”
    Number of filter to use: “1”

    Very strange. Any idea why this is happening ?

    Thanks,

    Gaston

    https://wordpress.org/plugins/participants-database/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author xnau webdesign

    (@xnau)

    8 years, 4 months ago

    What is the exact string you have in the field’s “values” definition?

    Have you looked at the database directly (such as with phpMyAdmin) to see exactly what is stored in that column of the record?

    Thread Starter huotg01

    (@huotg01)

    8 years, 4 months ago

    Is there a way to post a picture in this forum ?

    Dropdown list
    Values: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10

    Yes phpMyadmin confirms that the districts are the same in the db as in the list of participants. Strange, isn’t it ? Anything else that I can check ?

    Gaston

    Thread Starter huotg01

    (@huotg01)

    8 years, 3 months ago

    I sent an email to support@xnau.com in order to attach a few screen shots files. Maybe it will help to understand if I did something wrong.

    Thanks

    Thread Starter huotg01

    (@huotg01)

    8 years, 3 months ago

    from xnau

    in the plugin file classes.PDb_FormElement.class.php on line 695, you’ll find:
    if (is_array($options_array)) {
    change this to:
    if (is_array($options_array) && array_search( $title, $options_array ) === false ) {
    that will eliminate the confusion. That function allows dropdown values to be used in a multilingual environment.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Filter is off by one…’ is closed to new replies.