Date search does not work

Also when I have added a search pane for one of my fields which is a text field the search pane does not appear.

Also just noticed the export csv icon is flashing with a question mark and exclamation mark.

Thanks sorry for all the things.

Hi @gatestar,

Let’s go through your questions one by one…

>>> The between function works fine but if I put equal and select a date nothing happens.

Your date column is a datetime column. The value you select is of type date. This results in a comparison like:
October 1, 2022 12:02 am === October 1, 2022
which is not true.

Do you need the time in your table? If not you could create a view and convert the datatime to date. This allows you to search for specific dates while maintained the time.

>>> Also when I have added a search pane for one of my fields which is a text field the search pane does not appear.

Did you add anhy columns? Please use the Config button behind the search panes checkbox. This is documented here:
https://wpdataaccess.com/docs/data-publisher/premium-extensions/

>>> Also just noticed the export csv icon is flashing with a question mark and exclamation mark.

Sorry, I don’t understand what you mean. Can you please clarify this? Maybe add a screenshot?

Thanks,
Peter

Hi Thanks for the Reply, I am really close to everything being perfect.

I will respond to your responses.

>>> The between function works fine but if I put equal and select a date nothing happens.

Your date column is a datetime column. The value you select is of type date. This results in a comparison like:
October 1, 2022 12:02 am === October 1, 2022
which is not true.

>>>>>> The field is a date field not date time.

Do you need the time in your table? If not you could create a view and convert the datatime to date. This allows you to search for specific dates while maintained the time.

>>> Also when I have added a search pane for one of my fields which is a text field the search pane does not appear.

>>>>>>> I have configured the search pane and added the column but will not show the front end. 

https://timesheet.sykesit.co.uk/pictures/search-pane-1.jpg

Did you add anhy columns? Please use the Config button behind the search panes checkbox. This is documented here:
https://wpdataaccess.com/docs/data-publisher/premium-extensions/

>>> Also just noticed the export csv icon is flashing with a question mark and exclamation mark.

Sorry, I don’t understand what you mean. Can you please clarify this? Maybe add a screenshot?

>>>>>>>>>> I have added a screen shot. First button should be a CSV icon.
https://timesheet.sykesit.co.uk/pictures/csv.jpg

Try filtering on the week commencing date and doing equals. This is a date field.

Hi @gatestar,

The date equals search works, but the request is not submitted. If you enter oct 3 and then press enter on the global search field, it works. The enter key seems not to be recognized by the date field. I will nee to do some further research on this issue and try to fix it asap.

Thanks for the icon image! Your page loads several font awesome file from different versions. I think the problem is that WP Data Access expects version 6 but version 5 is loaded earlier and does not contain this specific icon. Is it possible to completely update to version 6? Or use labels?

To activate panes with server-side processing you need to use the extention manager as explained here:
https://wpdataaccess.com/docs/data-publisher/premium-extensions/
Please do not overwrite the dom option in your advanced settings. This option bypasses the extention manager. This works with client-side processing only. With server-side processing panes need to be provided on page load. The extention manager does this for you. There is way to do this manually.

Thanks,
Peter

Hi I have also figured out if I turn on the option to search while typing this resolves the issue with the date as like you said the enter key is not being recognised.

I assumed it was font awesome and probably the theme I am using is probably loading this as default. I will load the font awesome v6.

I did used the services premium extensions but nothing appeared so I was looking for an alternative. I will put the extension manager back on so you can see it does not load the pane.

Thanks for your help just ironing out these few issue.

Ok sorted the font awesome and loaded version 6.

One more small issue is as I have a large amount of columns when I use the column button it shows the columns down so I can turn columns on and off, but I cant get to the bottom as it seems to be confined to the length of the page and doesn’t extend it.

I can add picture if you want or go to https://timesheet.sykesit.co.uk/timesheet-entries/ and click the column button.

Thanks

Hi @gatestar,

Your table looks great! ??

But I see the issue with the column list. You can solve this by adding some css to your page. Please try this:

.dt-button-collection .menu {
    height: 200px;
    overflow: auto;
}

Thanks,
Peter

Hi I still can only see down to Wed and no further is yours different?

Thanks

Sorry, menu is not a class but a role… ??

Can you try this:

.dt-button-collection div[role=menu] {
    height: 200px;
    overflow: auto;
}

Thanks,
Peter

That’s great thanks.