May 26, 2023

Using AI for Advanced SQL Queries with JetEngine 3.2

Play Video

What is the tutorial about?

Learn about the world of advanced SQL queries, leveraging the power of OpenAI to streamline the process. The tutorial by Crocoblock focuses on using JetEngine 3.2 with Elementor, to generate SQL queries with AI. This is particularly useful for those involved in website design and plugin management, offering a fresh perspective on optimizing WordPress operations.

Tutorial Steps

  1. Update to JetEngine 3.2:
    Ensure you have the JetEngine 3.2 plugin installed on your WordPress site.
  2. Navigate to JetEngine Query Builder:
    From your WordPress dashboard, go to JetEngine and select ‘Query Builder’.
  3. Create a New Query:
    Click on ‘Add New’ to create a new query. Name your query and select ‘SQL/AI query’ from the ‘Query Type’ dropdown menu.
  4. Enable Advanced/AI Mode:
    Scroll down and toggle on the ‘Advanced/AI mode’.
  5. Generate AI-Based Query:
    Click on the button next to the ‘SQL Query’ field. In the pop-up window, describe the data you want to retrieve in the top section. Use the tips and prompt examples provided to help you write a good prompt. Once you’re done, click ‘Generate Query’.
  6. Apply the Generated Query:
    Copy the generated query or click ‘Use This Query’. Check if it works by toggling on ‘Preview Results’.
  7. Cast Result to Instance of Object:
    Scroll down to ‘Cast Result to Instance of Object’ and select the appropriate option (e.g., ‘User’ if you’re querying users).
  8. Save Your Query:
    Click ‘Add Query’ to save your query.
  9. Apply Query to Listing:
    Open the listing you want to apply the query to with Elementor. Select the ‘Listing Grid’ widget and enable ‘Custom Query’. Select the query you just created.
  10. Adjust the Prompt:
    If needed, you can adjust the prompt to suit your specific needs. Simply go back to the ‘Generate AI-Based Query’ step and modify the description in the top section.

Use Cases for this Tutorial

  • Birthday Notifications:
    Displaying users who have birthdays in the current month, useful for sending out personalized greetings or offers.
  • Experience Filter:
    Showcasing employees with a specific range of experience, beneficial for HR processes or team management.
  • Custom Queries:
    Generating custom queries for any specific need, enhancing the functionality and user experience of your website.

Required Resources

JetEngine Logo
Payment required
Elementor Logo
Free Options
Credit to Crocoblock
Crocoblock is a YouTube channel dedicated to providing tutorials, tips, and insights on WordPress and web design. With a focus on the Crocoblock suite of plugins and themes, the channel offers valuable content for WordPress enthusiasts, developers, and designers looking to enhance their skills and create websites with their tools. Through step-by-step tutorials, product overviews, and expert advice, Crocoblock helps its audience master the art of WordPress website building and customization.
Using AI for Advanced SQL Queries with JetEngine 3.2
Welcome back!
Enter your Helwp credentials to sign in.

No Account yet? Sign Up

My Account
Give Feedback
Describe your feedback *
Rate Helwp
Problem *
Describe the problem
Want us to reply?
Your E-Mail
Affiliate Disclosure

At Helwp, we’re committed to transparency and honesty. Therefore, we want to inform you that some of the links on our website are affiliate links. This means that, at no additional cost to you, we may earn a small commission if you click through and make a purchase.

We only promote products or services that we genuinely believe in. These affiliate commissions help us to maintain the website and continue to provide you with free, high-quality WordPress content.

If you are interested in how you can support us even further, check out our support page.