Okay
  Public Ticket #1671920
Column filtering not working
Closed

Comments

  • Brad started the conversation

    Hey team, I've got a sample Google Sheet setup and integrated, but whenever I go to apply column filtering between a range (whether it's a number or date, doesn't work for either data type) I either get no results or only the result associated with the upper limit of the range definition. Anyone come across this before?

  •  631
    Bogdan replied

    HI Brad,
    Thank you for your purchase.

    Can you please send me the link of that page so I can take a look and give you my suggestion.

    Best regards.

    Check out our documentation for Amelia - WordPress booking plugin on this link.

    Check out our documentation for wpDataTables - WordPress table plugin on this link.

    Kind Regards,

    Bogdan Radusinovic
    bogdan@touchmesoft.net

  • Brad replied

    Hey Bogdan, the website isn't published yet but I can give you access to the back-end if that would help. Just send me your email address.

  •  631
    Bogdan replied

    Hi Brad,

    Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.

    Also point me to the table ID so I can take a look.

    Best regards.

    Check out our documentation for Amelia - WordPress booking plugin on this link.

    Check out our documentation for wpDataTables - WordPress table plugin on this link.

    Kind Regards,

    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •   Brad replied privately
  •  631
    Bogdan replied

    Hi Brad,

    Could you please confirm that this account is administrator level account. This is necessary for me to be able to see plugin and solve the issue.

    Best regards.

    Check out our documentation for Amelia - WordPress booking plugin on this link.

    Check out our documentation for wpDataTables - WordPress table plugin on this link.

    Kind Regards,

    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •   Brad replied privately
  •  631
    Bogdan replied

    Hi Brad,

    I tested out the table ID 2 and as I can see number range and date range is working (attachments) 

    Correct me if I am missing something.

    Best regards.

    Attached files:  Screen Shot 2018-08-10 at 5.25.45 PM.png
      Screen Shot 2018-08-10 at 5.26.49 PM.png

    Check out our documentation for Amelia - WordPress booking plugin on this link.

    Check out our documentation for wpDataTables - WordPress table plugin on this link.

    Kind Regards,

    Bogdan Radusinovic
    bogdan@touchmesoft.net

  • Brad replied

    Hey Bogdan,

    You're right that does work, I have tested it myself. I'm trying to apply a pre-defined filter and that's when I get "no matching records". Am I not configuring this correctly?

    Brad

    Attached files:  screenshot 1.png
      screenshot 2.png

  •  631
    Bogdan replied

    Hi Brad,

    As I can see you deleted the table ID 2, is there any other table that I can test it out with the predefined values.

    Best regards.

    Check out our documentation for Amelia - WordPress booking plugin on this link.

    Check out our documentation for wpDataTables - WordPress table plugin on this link.

    Kind Regards,

    Bogdan Radusinovic
    bogdan@touchmesoft.net

  • Brad replied

    Hey Bogdan,

    Yes you can try it with Tables 4, 5 or 6. All of them have a "Submitted At" date column that you can try to add filters to.

    Cheers,

    Brad

  •   Bogdan replied privately
  •   Brad replied privately
  •  631
    Bogdan replied

    Hi Brad,

    Ok now I can see the file.

    I think the issue might be because the Submitted At column is datetime column.

    We support date time columns but not with the seconds.

    That is why you have this issue.

    Best regards.

    Check out our documentation for Amelia - WordPress booking plugin on this link.

    Check out our documentation for wpDataTables - WordPress table plugin on this link.

    Kind Regards,

    Bogdan Radusinovic
    bogdan@touchmesoft.net

  • Brad replied

    Hey Bogdan,

    That could be part of the problem yes, however to validate I have reinstated the test table which has a pure date column (dd/mm/yyyy). Whenever I try to add pre-configured date range filtering I get "No matching records", however when I dynamically add the filtering on a test page that I setup (name is "TestPage") then the records filter perfectly. So it seems like there is another issue as well. 

    Cheers,

    Brad

  •  631
    Bogdan replied

    Hi Brad,

    can you please check if the date format is the same in the file and in the wpdatatables settings page.

    As I can see in the file is m/d/y but in the settings page is d/m/y

    Best regards.

    Check out our documentation for Amelia - WordPress booking plugin on this link.

    Check out our documentation for wpDataTables - WordPress table plugin on this link.

    Kind Regards,

    Bogdan Radusinovic
    bogdan@touchmesoft.net

  • Brad replied

    Hey Bogdan,

    Thanks yes I checked and the file was in the American format, not British. I have changed them to match and still the filtering does not work. I tried with the source file format as "Date" and also as "Plain Text" with the same result. Interestingly, if I go and clear the settings for the filtering and then click apply, the preview reloads and only the filtered data shows up.

    I have attached screenshots to show the configuration.

    Regards,

    Brad

    Attached files:  Column filter settings.png
      Column format settings.png
      Filtered No Results.png
      Filtered results but filter configuration erased.png

  •  631
    Bogdan replied

    Hi Bred,

    Strange I also reproduced the issue on my side once.

    I will investigate this in the mean time can you please try to make a table from GoogleSpreadsheet using the 3rd option in the table wizard.

    That should work with the predefined values.

    Best regards.

    Check out our documentation for Amelia - WordPress booking plugin on this link.

    Check out our documentation for wpDataTables - WordPress table plugin on this link.

    Kind Regards,

    Bogdan Radusinovic
    bogdan@touchmesoft.net

  •   Brad replied privately
  •  631
    Bogdan replied

    Hi Brad,

    This is reported as a bug and our developers are working on finding the solution as soon as possible.

    Sorry for any inconvenience.

    Best regards.

    Check out our documentation for Amelia - WordPress booking plugin on this link.

    Check out our documentation for wpDataTables - WordPress table plugin on this link.

    Kind Regards,

    Bogdan Radusinovic
    bogdan@touchmesoft.net