How to Generate the Advanced SQL Query with the Open AI | JetEngine

JetEngine 3.2.0 is around the corner, and… will you believe we decided to add some of the AI to our plugins too?
In this video, we will take a look at an AI feature - Open AI integration to generate Advanced SQL query.
To find the functionality easily, the SQL query type has been renamed to SQL/AI. Also, the Advanced mode switch has been moved to the first position and renamed to Advanced/AI mode.
How it works?
When Advanced/AI mode is enabled, just like before, the query builder switches to manual query input mode. An icon has been added to the main query input field to invoke the automatic query generation UI.
Clicking on the icon opens a popup for query generation. After entering the prompt and clicking the "generate query" button, the query generation process starts.
Hope its video was useful. Stay tuned for more!
#wordpress #ai #sqlquery #wordpressai
-------------
Leave your feedback on our GitHub
► github.com/Crocoblock/suggest...
⚡Helpful instructions:
► bit.ly/43cUUVK
Get JetEngine plugin:
► bit.ly/3OMOcB4
Choose Crocoblock subscription:
► bit.ly/3N5Y87T
-------------
Templates used:
LaborTime - Dynamic Job Board Website for Elementor
► bit.ly/3opQgEG
-------------
☕LIKED THIS VIDEO? BUY JULIA A COFFEE
► www.buymeacoffee.com/JuliaMcHale
-------------
TIMESTAMPS
00:00 Introduction
00:35 Brief overview of JetEngine 3.2.0
02:32 Adding a custom query
04:01 Generating a query with AI
06:17 Applying the query to the listing
06:52 Adjusting the prompt
-------------
JetEngine playlist
► • JetEngine | Tutorials
-------------
Join us here:
► FB Community: / crocoblockcommunity
► Facebook: / crocoblock
► Twitter: / mrcrocoblock
► Instagram: / mrcrocoblock
► LinkedIn: / crocoblock

[@popopp2297]

Happy 5 year anniversary Crocoblock! The discount and the implementation of AI just convinced me to go and purchase the Unlimited Lifetime Croco plan. Thank you for the amazing tutorial Julia, keep up the good work!

[@Crocoblock]

We are happy to know you liked our new functionality! Stay tuned ❤️

[@dorohan_ilya]

Wow! That's what we were waiting about!

[@Art-01]

Woow, thank u Croco, love it✌️✌️✌️✌️🙏

[@kevinrichter9397]

I really like the idea of AI for advanced SQL queries. That's actually a good use case and not just adding AI because it's a buzz word. Good job Also nice to finally see some improvement for the DOM size of dynamic field/link. I've been using Bricks for a while now and the Elementor widgets are really unnecessarily bloated in comparison.

[@Crocoblock]

Thank you for your feedback! We do our best to implement new cool features and satisfy requests of our customers ❤️

[@WickyDesign]

Nice! The SQL query with AI looks to be a great feature!

[@kamalelboustani4550]

Thanks, that's great! Continue on that path

[@arifulislamnoyon]

Wow Nice and Helpful

[@cacomartin]

stunning! 🤖😎

[@PeguJurado]

Esto es lo que necesitamos

[@nishidshajib5720]

🔥

[@tobisalami]

Great!!

[@sudebkarmokar]

Make life easier❤❤

[@coreyb1102]

This is amazing

[@samuelepellizzari]

This looks awesome, @crocoblock! When is the update due out? I can’t wait! Keep up the great work!

[@Crocoblock]

You could test these features right now. The beta version is available on your Crocoblock Account for downloading. As soon as we finish all tests, the features will be released globally

[@MoxetKhanPK]

Excellent feature, especially for those with less knowledge of SQL. Question, the prompt/AI request to Open AI is free or paid?

[@Crocoblock]

Customers who have All-Inclusive Life-ime subscription may send 30 requests per month, all other customers who have JetEngine plugin may send 5 requests to generate Advanced query with the help of AI per month. Check all the limitations and details here please bit.ly/43pQ7zP

[@tajbinkhan4858]

This is really awesome. Now I can use query using my imagination. If you are seeing crocoblock, I have a request to you. Please fix the dynamic date function for built in elementor countdown timer. Because it's not showing in the dynamic tags. It only works for jet element countdown timer. 🤗🤗🤗🤗

[@Crocoblock]

Thank you for your feedback! Please, contact our support team for clarification of your task - crocoblock.com/help-center/. We will do our best to assist you with your questions.

[@wilsonrosagomes]

Sou do Brasil, não teria como fazer que o SQL AI funcionasse de acordo com o Idioma atual do Wordpress?

[@narlboro1989]

try it, it should work.

[@Crocoblock]

It works in Ukrainian :) Please, test the functionality in in Brazilian 😉

[@wilsonrosagomes]

@@narlboro1989 Thank you

[@wilsonrosagomes]

@@Crocoblock Thank you

[@qamarzaman-qz]

Can we add these as filter bassed on others plugins data, mean i am using a listing plugin can i made a query for that plugin meta data and make filter bassed on their data

[@Crocoblock]

To check your question and give you a solution for that, could you contact our support team, please? crocoblock.com/help-center/

[@PeliPelo-yg7zt]

This option dosent work for Sub key license, only for primar license. I dont understand why. We have more then 10 client and we use sub key for their websites and not primary key. Hope Croco can allow AI query for sub key too. Thank u

[@Crocoblock]

At the current moment, there are limits to the number of uses of this functionality for different types of Crocoblock Subscriptions. So the main key should be used.

[@fazelnasri]

Hello.how can we filter a series of categories that have a parent. Whenever I enter the name of "PARENT", JetSmartfilter does not find it, but when I enter ID "PARENT", it filters its sub-categories. What is the reason?

[@Crocoblock]

Hi! The value of the term for JetSmartFilters should be it's ID. This is the proper way to make it work. So you can build a term query to display the correct list of terms in filter options, then use this query as a source for the filter. Set the term_id for the value and name should be used as a label: prnt.sc/VvXmmAWFMbyH

[@TurabWahand]

Using Jet Engine is very difficult. I do very hadwork to use the Jet Engine

[@Crocoblock]

JetEngine is a great plugin that gives plenty of tools and possibilities. If you have some difficulties with any module of the plugin, let our support team help you :) crocoblock.com/help-center/

[@qamarzaman-qz]

An we apply these queries for filter 🥵