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

[@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 ❤️

[@Art-01]

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

[@dorohan_ilya]

Wow! That's what we were waiting about!

[@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

[@web_genius_bd]

Wow Nice and Helpful

[@cacomartin]

stunning! 🤖😎

[@PeguJurado]

Esto es lo que necesitamos

[@sudebkarmokar]

Make life easier❤❤

[@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

[@wilsonrosagomes]

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

[@sander_mk]

try it, it should work.

[@Crocoblock]

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

[@wilsonrosagomes]

@@sander_mk Thank you

[@wilsonrosagomes]

@@Crocoblock Thank you

[@nishidshajib5720]

🔥

[@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

[@tobisalami]

Great!!

[@ильявеличко-е2ф]

Hello! Can you tell me what the "Count SQL Query" field is used for, I haven't found instructions on how to work with it anywhere? Is it possible to specify a "Show/Per Page Limit" for a self-written SQL query? Thanks for the product.

[@Crocoblock]

Count SQL Query is used to influence on the total count in the query prnt.sc/FzgWke0uhmuY for example, according to the screen, we get only one post with id=583 as on the screen however, with the help of Count SQL Query we can get the count of all posts on the website

[@Crocoblock]

unfortunately, it will not work the way you've described

[@ильявеличко-е2ф]

@@Crocoblock Is such an update planned in the future? I really wanted to see the same function (Show/Per Page Limit) for self-written SQL queries and for received data from third-party REST APIs.

[@Crocoblock]

well, should admit that this feature is not planned for the future you can use results of the query in the usual SQL query and then set the pagination hope it'll help :)

[@coreyb1102]

This is amazing

[@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.

[@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/

[@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

[@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.

[@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 🥵