I have a form which takes a date time entry. I now need to write a SQL query to check for overlap as a validation but have just discovered that the data type is longtext. Does anyone have any suggestions for how to do a date query in this context? We are dealing with less than 1000 entries.

We don’t recommend querying the tables directly as your code will break if there are changes made to how the data is stored in future releases. Have you tried using the GFAPI methods for getting or counting entries that match your search criteria? Searching and Getting Entries with the G…

Thats a great suggestion and I’m trying it now but will it treat the data as a date or string? In other words can I search for dates as of a specific date and time up to a specific date and time?

It looks like you created a new topic after getting a little further, so we will continue here: [image] How to create a field filter for a date time field Get Help I’m attempting to search entries by date time. I’m using GFAPI::get_entries( $form_id, $search_criteria ) …

How to write date queries against gravity form longtext gf_entry_meta

Get Help

chrishajer (Chris (Gravity Forms)) October 3, 2022, 4:13am 4

It looks like you created a new topic after getting a little further, so we will continue here:

Topic		Replies	Views
Check for overlapping datetime Get Help custom , gform_field_validation , date	4	550	October 3, 2022
How to create a field filter for a date time field Get Help gfapi , date-field , database	0	472	September 30, 2022
Including a date range in V2 REST API search criteria Get Help rest-api , date-range	11	2817	April 8, 2021
Search and Filter Entries - Take 2 Get Help entries , entry-search , multiple-criteria	1	428	August 15, 2022
Unreliable entry dates [RESOLVED] Get Help date , entry-date , date_created , gfcommon::format_date , utc	2	544	September 24, 2023

How to write date queries against gravity form longtext gf_entry_meta

Related topics