{"id":39961,"date":"2023-05-25T12:10:18","date_gmt":"2023-05-25T12:10:18","guid":{"rendered":"https:\/\/crocoblock.com\/knowledge-base\/?post_type=article&p=39961"},"modified":"2023-07-28T13:50:08","modified_gmt":"2023-07-28T13:50:08","slug":"generating-sql-query-with-open-ai-displaying-users-birthdays","status":"publish","type":"article","link":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/generating-sql-query-with-open-ai-displaying-users-birthdays\/","title":{"rendered":"How to Generate SQL Query with Open AI: Displaying Users’ Birthdays"},"content":{"rendered":"\n

Open AI is a platform that provides artificial intelligence-based models that are intended to solve different problems. One of the key concepts is prompts \u2013 that\u2019s how you build your request to generate the solution.<\/p>\n\n\n\n

Now, you can use the Open AI with the SQL Query<\/strong><\/a> by the JetEngine <\/em>plugin. With the text request (prompt), you can generate the query to display the data from the database table. For example, you can get users who published posts in the last two weeks, select product categories with products in stock, and display posts published this week.<\/p>\n\n\n\n

This tutorial will show how to generate the SQL query with AI to display users with birthdays this month on the current day and after.<\/p>\n\n\n\n

Create the Date Meta Field for Users<\/h2>\n\n\n\n
\n

Guided by the How to Apply Meta Boxes to Users<\/strong><\/a> tutorial, create the Meta Box<\/strong> and attach the Date <\/strong>meta field to users. <\/p>\n\n\n\n\"attach\n\n\n\n

You can add several meta fields of different types, for example, for users’ names, pictures, and additional information.<\/p>\n\n\n\n\"meta\n\n\n\n

Add several users and fill in the Date<\/strong> meta field for each of them.<\/p>\n\n\n\n\"add\n<\/div><\/div>\n\n\n\n

Create the SQL Query<\/h2>\n\n\n\n
\n

Proceed to the JetEngine > Query Builder <\/em><\/strong>tab and hit the \u201cAdd New\u201d <\/strong>button.<\/p>\n\n\n\n

Give the query a Name<\/strong>, and pick the \u201cSQL\/AI Query\u201d Query Type<\/strong>.<\/p>\n\n\n\n\"SQL\/AI\n\n\n\n

Enable the Advanced\/AI mode <\/strong>toggle, and you\u2019ll see that the settings are different than if you decided to write SQL query manually.<\/p>\n\n\n\n

To use AI, press the magic stick<\/strong> icon, and the pop-up for the SQL query generation will appear.<\/p>\n\n\n\n\"ai\n\n\n

<\/svg><\/div>
Warning<\/div>

Currently, you can make 30 requests per month with the Lifetime subscription plan and 5 requests per month with other subscriptions.<\/p><\/div><\/div>\n\n\n\n

In the text area, you can describe what data you want to display with the query. <\/p>\n\n\n\n

Also, you can find tips for the successful prompt (text request with the query description) writing and prompt examples.<\/p>\n\n\n\n\"generate\n\n\n\n

Prompt examples are clickable, so you can select one and use it for the SQL query. I selected \u201cGet users who have birthday on current month. Birthday is stored in ‘birth_date’ meta field. Return only future birthdays and all data from the users table.\u201d <\/p>\n\n\n\n\"example\n\n\n\n

Then, I pushed the \u201cGenerate query\u201d <\/strong>button.<\/p>\n\n\n\n\"generate\n\n\n\n

After that, you will see the generated query in the text area.<\/p>\n\n\n\n\"generated\n\n\n

<\/svg><\/div>
Warning<\/div>

Generated query with AI might not be accurate, so we recommend reviewing it before using it.<\/p><\/div><\/div>\n\n\n\n

For example, in the<\/p>\n\n\n\n

WHERE m.meta_key = 'birth_date' \n<\/code><\/pre>\n\n\n\n
line, the ‘birth_date’ value is default, so you need to replace it with the slug of the Date <\/strong>meta field you created earlier. I replaced it with the \u2018_employee-birthday\u2019 slug.<\/p>\n\n\n\n\"replace\n\n\n\n
After reviewing, click the \u201cUse this query\u201d <\/strong>button.<\/p>\n\n\n\n
The generated query will appear in the SQL Query<\/strong> text area, where you can edit it as well.<\/p>\n\n\n\n
Also, pay attention to the Cast result to instance of object <\/strong>option. The SQL query returns items as the default PHP objects, and with this option, you can convert default objects into the needed ones (posts, users, terms, etc.). This helps avoid errors when working with widgets customized to particular objects (posts, users).<\/p>\n\n\n\n
In this case, you need to select the \u201cUser\u201d option.<\/p>\n\n\n\n\"cast\n\n\n\n
After you finish, press the \u201cAdd\/Update Query\u201d <\/strong>button.<\/p>\n<\/div><\/div>\n\n\n\n
Create a Listing Item<\/h2>\n\n\n\n
\n
Move to the JetEngine > Listings <\/em><\/strong>tab and click the \u201cAdd New\u201d <\/strong>button. <\/p>\n\n\n\n
In the Setup Listing Item <\/strong>pop-up, you can select the \u201cUsers\u201d or \u201cQuery Builder\u201d Source<\/strong>. If you choose the \u201cQuery Builder\u201d Source<\/strong>, you need to pick the needed Query <\/strong>as well. Enter the Listing item name <\/strong>and choose the \u201cElementor\u201d or \u201cBlocks <\/strong>(Gutenberg)\u201d Listing view<\/strong>. Then, click the \u201cCreate Listing Item\u201d <\/strong>button.<\/p>\n\n\n\n\"setup\n\n\n\n
I used the Dynamic Field <\/strong>widget to display the users’ information. To learn more, proceed to the Dynamic Field Overview<\/strong><\/a>.<\/p>\n\n\n\n
If you want to display the data from the default WordPress fields for users, select the \u201cPost\/Term\/User\/Object Data\u201d Source<\/strong>.<\/p>\n\n\n\n
\"\"<\/div>\n\n\n\n
If you want to display the data from the JetEngine custom fields from the meta box, pick the \u201cMeta Data\u201d Source<\/strong>.<\/p>\n\n\n\n
\"\"<\/div>\n\n\n\n
To display images, enable the Filter field output <\/strong>option and choose the \u201cGet image by ID\u201d Callback<\/strong>. Navigate to the Filter Field Output Overview<\/strong><\/a> to learn how to display different data with different callbacks. <\/p>\n\n\n\n\"get\n\n\n\n
If you want to display only the day and month instead of the full date, enable the Filter field output <\/strong>option, pick the \u201cFormat date\u201d Callback<\/strong>, and enter \u201cF j\u201d instead of \u201cF j, Y.\u201d<\/p>\n\n\n\n\"format\n\n\n\n
After you done customizing, press the \u201cUpdate\u201d <\/strong>button.<\/p>\n<\/div><\/div>\n\n\n\n
Add the Listing Grid to the Page<\/h2>\n\n\n\n
\n
Move to the Pages <\/strong>tab and hit the \u201cAdd New\u201d <\/strong>button or click to edit the created page.<\/p>\n\n\n\n
Place the Listing Grid <\/strong>widget or block to the page and select the recently created Listing<\/strong> in the General <\/strong>settings.<\/p>\n\n\n\n
If you created the Listing Item with the \u201cQuery Builder\u201d Source<\/strong>, the Listing Grid <\/strong>would show the query results immediately.<\/p>\n\n\n\n
Today is 25th May, so the query shows only users whose birthday is in the current month on the current day and after, as that was set in the prompt example for the SQL query generation.<\/p>\n\n\n\n\"listing\n\n\n\n
If you created the Listing Item with the \u201cUsers\u201d Source<\/strong>, open the Custom Query <\/strong>tab, enable the Use Custom Query <\/strong>toggle, and choose the needed Custom Query<\/strong>. <\/p>\n<\/div><\/div>\n\n\n\n
\"\"<\/div>\n\n\n\n
That\u2019s all. Now you know how to generate the SQL query with the Open AI to display users with birthdays this month on the current day and after.<\/p>\n","protected":false},"excerpt":{"rendered":"
Discover how to generate the SQL query using the power of Open AI to display users with birthdays this month on the current day and after.<\/p>\n","protected":false},"author":8,"featured_media":0,"template":"","format":"standard","builder-category":[],"article-category":[405],"yoast_head":"\nHow to Generate SQL Query with Open AI: Displaying Users' Birthdays | Crocoblock<\/title>\n<meta name=\"description\" content=\"Discover how to generate the SQL query using the power of OpenAI to display users with birthdays this month on the current day and after. Use prompt examples to generate the SQL query.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/generating-sql-query-with-open-ai-displaying-users-birthdays\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Generate SQL Query with Open AI: Displaying Users' Birthdays | Crocoblock\" \/>\n<meta property=\"og:description\" content=\"Discover how to generate the SQL query using the power of OpenAI to display users with birthdays this month on the current day and after. Use prompt examples to generate the SQL query.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/generating-sql-query-with-open-ai-displaying-users-birthdays\/\" \/>\n<meta property=\"og:site_name\" content=\"Help Center\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-28T13:50:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2023\/05\/attach-date-meta-field-to-users-using-meta-box-1024x655.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/generating-sql-query-with-open-ai-displaying-users-birthdays\/\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/generating-sql-query-with-open-ai-displaying-users-birthdays\/\",\"name\":\"How to Generate SQL Query with Open AI: Displaying Users' Birthdays | Crocoblock\",\"isPartOf\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#website\"},\"datePublished\":\"2023-05-25T12:10:18+00:00\",\"dateModified\":\"2023-07-28T13:50:08+00:00\",\"description\":\"Discover how to generate the SQL query using the power of OpenAI to display users with birthdays this month on the current day and after. Use prompt examples to generate the SQL query.\",\"breadcrumb\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/generating-sql-query-with-open-ai-displaying-users-birthdays\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/generating-sql-query-with-open-ai-displaying-users-birthdays\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/generating-sql-query-with-open-ai-displaying-users-birthdays\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/crocoblock.com\/knowledge-base\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Articles\",\"item\":\"https:\/\/crocoblock.com\/knowledge-base\/articles\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Generate SQL Query with Open AI: Displaying Users’ Birthdays\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#website\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/\",\"name\":\"Help Center\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/crocoblock.com\/knowledge-base\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#organization\",\"name\":\"Help Center\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/04\/invert-crocoblock-logo.svg\",\"contentUrl\":\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/04\/invert-crocoblock-logo.svg\",\"caption\":\"Help Center\"},\"image\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Generate SQL Query with Open AI: Displaying Users' Birthdays | Crocoblock","description":"Discover how to generate the SQL query using the power of OpenAI to display users with birthdays this month on the current day and after. Use prompt examples to generate the SQL query.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/generating-sql-query-with-open-ai-displaying-users-birthdays\/","og_locale":"en_US","og_type":"article","og_title":"How to Generate SQL Query with Open AI: Displaying Users' Birthdays | Crocoblock","og_description":"Discover how to generate the SQL query using the power of OpenAI to display users with birthdays this month on the current day and after. Use prompt examples to generate the SQL query.","og_url":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/generating-sql-query-with-open-ai-displaying-users-birthdays\/","og_site_name":"Help Center","article_modified_time":"2023-07-28T13:50:08+00:00","og_image":[{"url":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2023\/05\/attach-date-meta-field-to-users-using-meta-box-1024x655.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/generating-sql-query-with-open-ai-displaying-users-birthdays\/","url":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/generating-sql-query-with-open-ai-displaying-users-birthdays\/","name":"How to Generate SQL Query with Open AI: Displaying Users' Birthdays | Crocoblock","isPartOf":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#website"},"datePublished":"2023-05-25T12:10:18+00:00","dateModified":"2023-07-28T13:50:08+00:00","description":"Discover how to generate the SQL query using the power of OpenAI to display users with birthdays this month on the current day and after. Use prompt examples to generate the SQL query.","breadcrumb":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/generating-sql-query-with-open-ai-displaying-users-birthdays\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/crocoblock.com\/knowledge-base\/jetengine\/generating-sql-query-with-open-ai-displaying-users-birthdays\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/generating-sql-query-with-open-ai-displaying-users-birthdays\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/crocoblock.com\/knowledge-base\/"},{"@type":"ListItem","position":2,"name":"Articles","item":"https:\/\/crocoblock.com\/knowledge-base\/articles\/"},{"@type":"ListItem","position":3,"name":"How to Generate SQL Query with Open AI: Displaying Users’ Birthdays"}]},{"@type":"WebSite","@id":"https:\/\/crocoblock.com\/knowledge-base\/#website","url":"https:\/\/crocoblock.com\/knowledge-base\/","name":"Help Center","description":"","publisher":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/crocoblock.com\/knowledge-base\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/crocoblock.com\/knowledge-base\/#organization","name":"Help Center","url":"https:\/\/crocoblock.com\/knowledge-base\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/crocoblock.com\/knowledge-base\/#\/schema\/logo\/image\/","url":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/04\/invert-crocoblock-logo.svg","contentUrl":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/04\/invert-crocoblock-logo.svg","caption":"Help Center"},"image":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/article\/39961"}],"collection":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/article"}],"about":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/types\/article"}],"author":[{"embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/users\/8"}],"wp:attachment":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/media?parent=39961"}],"wp:term":[{"taxonomy":"builder-category","embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/builder-category?post=39961"},{"taxonomy":"article-category","embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/article-category?post=39961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}