JetEngine Query Builder - 25 Features You Must Know | WordPress | Crocoblock Tutorial

[@jasonwessel6379]

I can’t find any other resources on YT like this, thank you VERY much. You’re answering some of my biggest JFB questions.

[@tobisalami]

You are very welcome!

[@rewdroid]

I'm more of a graphic designer than a coder, and croboclock plugins help me build sites as I imagine them. Your tutorials are a great source of knowledge. Please continue. Thank you for your work

[@tobisalami]

I will! Thank you for thanking me!

[@daveswitzerland4442]

As a normal AMAZING Crocoblock Plugin user this video feels as if someone is feeding you some psychoactive LSD substances and you see the world in a totally new dimension, lol. GREAT Stuff haha one feature better than the other. :) Thank you very much, you open a whole new universe. I love such kind of deep going videos. So pitty that Russia attacks Ukraine, if this war is over (and Ukraine won) this Crocoblock team company has such a bright future, their software is just best on this planet.

[@tobisalami]

Thank you so much for the commendation!😊 And yes! The plugins are the best! Underrated!

[@pixelturm]

Damn ... the JetEngine-Godfather ... instantly subscribed, awesome job 👍

[@tobisalami]

I'm glad you enjoyed this! Thanks for the comment! 😄

[@yetistudiosnet]

Man, I watched a tutorial too and instantly subscribed to the channel. I needed a channel like this one, well dedicated to explaining JetEngine! 🙌

[@sushi414]

YES YES YES! 🔥 Awesome video! Even after 3 years of work with Crocoblock plugins I have learned a lot of things! ❤ Instant sub! 💪

[@tobisalami]

Thanks a lot for subscribing and for leaving the awesome feedback!

[@stevetoti]

Excellent. Please do more Crocoblock videos. We need them snd we are enjoying every bit of information you sre pouring out

[@tobisalami]

I do my best. 😊

[@lucianacorrea2287]

Hi Tobi thank you so much for your tips! The use of Query builder is more easy now. You show many possibilities for amazing applications! Please continue to post more tips for crocoblocks apps!

[@tobisalami]

Thanks for the feedback! And you're welcome!

[@Joe-ss9cr]

Tnx a ton! We need these types of tutorials. A similar one for ACF would be awesome as well and probably make you the first person having such a dynamic tutorial library.

[@tobisalami]

Thank you for thanking me. And yes! I have tutorials on ACF in the pipeline too.

[@paige0394]

I loved this format of rapid demos! I didn't expect to learn so many new tricks with the query builder. Truly awesome job with this video. Your voice is clear, you zoom in at the right times, and you don't overexplain things. You're a unicorn 🦄 I have a complex project coming up that I've been mapping out. After watching this, I'm going to change my approach to a couple queries. Looking forward to your future videos. 👏

[@tobisalami]

Thanks a lot for the feedback. I appreciate it a lot!

[@tobisalami]

Let me know what you think! Also, If you have any questions concerning the features I have discussed here, be sure to leave a comment.

[@stefanradu4550]

Fantastic tutorial and can't wait for the videos in full detail. Congrats!

[@tobisalami]

@@stefanradu4550 Thank you for watching!

[@LovelyPrintUK]

100% brill, Crocoblock published your tutorial also , not sure you know? Please do not stop making Crocoblock tutorials - there is not a lot "fresh" ones and worth to watch :P

[@tobisalami]

I appreciate the feedback! Thanks a lot! And yes, I am aware that Crocoblock published my video. I collaborated with them. Another is coming soon on Crocoblock's channel too. Thanks for watching!

[@Anonymous-rg1dd]

You are awesome, Tobi. We know very well what we want. Thank you.

[@tobisalami]

You are welcome!

[@adnanamin3666]

Truly useful! Thank you for sharing these features. 🙏🙏

[@tobisalami]

You are welcome. Thank you for watching!

[@nadmak9093]

Wow! 👍 Very in-depth tutorial. Wil be using some of these features I was not even aware of!! A request for future video would be to go in-depth on all things "cached". It is of outmost importance to build fast websites but I hear that caching plugins don't always play nice with JetEngine. Maybe a best practices video when it comes to caching with JetEngine going into the inner workings. Like when you turn on caching, when does the cache gets reset, can you control that? Etc... Thank you sir!!🙏

[@tobisalami]

You're welcome! And thank you for the suggestion. I've put it down as an idea for a future video.

[@글집자]

wow i think you are genius of crocoblock~~ awesome!!

[@tobisalami]

Thank you for the feedback! 😊

[@nikhilb8345]

Amazing content! Waiting for a more detailed video on Related items! Thank you

[@tobisalami]

Sure! Thanks for the feedback!

[@GusCastro-m2h]

Great video. I'm more of a designer than a coder and my initial perception is that the jet engine is very versatile, but it seems to me that they complicate the simplest things a lot without need. Especially in the Query Builder it is disappointing to get pagers and filters working with advanced queries. So far I haven't found a way to do it :-(

[@clipstattoo]

the best of the best

[@tobisalami]

Thank you so much. I try my best to simplify things.

[@brunoaguilar689]

Very valuable. Thanks you for sharing

[@tobisalami]

Thank you for thanking me!

[@BilalShirzadDev]

aLWAYS THE BEST tHANK YOU

[@tobisalami]

You are welome! Thank you for watching!

[@ols9910]

Super, very thans

[@tobisalami]

You're welcome

[@UriHaik]

Thank you. Can you please explain how to create a query for filter that is based on relation?

[@tobisalami]

You are welcome. I have a video about this coming soon. But that will be published on the Crocoblock KZbin channel. I will have more videos about relations in the future. If you need urgent help with the relations though, you can make a post with the details on the Crocoblock community and mention me on there, and I will find the time to take a look at it for you.

[@masum_techs]

Oh you are boss. need more video

[@tobisalami]

Thanks! More videos in the pipeline.

[@HappyHappy_1314]

Excellent video Tobi🎉 I have a question - I currently have 2 listing (source is post), both listing has applied 2 different SQL query. Issue is I would like to display items (either listing 1 or listing 2) according to latest post time first, of which order can be like item from listing 1 ( posted 10 mins agp), item from listing 2 ( posted 1 day ago), item from listing 2 ( posted 3 days ago). May you suggest the query setting 🙏🏼

[@tobisalami]

Hi. Three options: 1. Use merge query and make it into one listing grid. 2. Query both of the listings into one query. 3. Use Listing Grid injections to inject the second listing into the first. And order both by date. (This one may not work as well as the first two.)

[@HappyHappy_1314]

@ thanks Tobi, as that is important element of my website, may I know if custom snippet code will work when the mentioned 3 options do not work. Wonder if possibly have a work around solution

[@HappyHappy_1314]

@@tobisalami I am thinking how about write a advanced SQL query is the only possible way to achieve way?

[@wellbeingchannel8669]

Great video...hope there will be more details videos...actually i'm struggling to display the most liked posts of a user on his public user profil....i think i don't understand well this query builder.

[@tobisalami]

It's a bit tricky, but it's possible!

[@tobisalami]

You can make a post about this in the Crocoblock community. Mention me in the comments, and I will see if I can take a look when I have the time to.

[@TheHeadphoneList]

This is an amazing video, thank you very much! I am trying to use nested queries in the Meta Query Clauses for a posts query, but it isn't working (tried IDs, titles, etc.). Do queries work in the Meta Query Clauses?

[@tobisalami]

You're welcome. Have you tried specifying an id in the query and in the listing grid? It could be why this is not working.

[@JL-qz7qb]

Hi Tobi, Thanks so much for your super helpful video! It’s already been a huge help for me. If you have a moment for a quick question. How can I display the labels from the JetEngine glossary? I’ve also tried with the simulated glossary, but I just can’t figure it out. I simply want to display a text value in a button without lowercase letters and hyphens. If you have an answer to this, my long search would finally be over! Thanks again for the awesome video!

[@tobisalami]

@@JL-qz7qb hi. You're welcome! Try this: %jet_engine_field_name|meta-field|field_name% Replace "meta-field" with the meta field key You should use that macro inside of a Dynamic Field widget when you toggle on "Customise field output" like so: %%jet_engine_field_name|meta-field|field_name%% Let me know if it works for you. Ideally, what you have in your "value" should be what you intend to show in the front-end. Not what you have in your label.

[@JL-qz7qb]

@@tobisalami Thanks so much for your help! I’ve managed to get it working with the simulated glossary, so now I can display values that include special characters, spaces, and uppercase letters, and they still work perfectly with JetSmartFilter. From what I can tell (as a non-expert), this doesn't seem possible with regular glossaries-they don’t seem to be filterable in the same way. Anyway, thanks again!

[@tobisalami]

@@JL-qz7qb you're welcome. And yes! It's difficult to filter the regular glossaries because the way they're stored makes querying them very much so.

[@julikame]

I see the "query product variable table" in your video. My head blowsup cause I try to create a variable table with 50 items, that a Woo Product have. Maybe you have a such video?

[@tobisalami]

I don't have a video yet. It's something I have been working on. I hope to release a video about this in the future.

[@julikame]

@tobisalami super. Waiting for. Cause i created table of variables for current product id, it's a progress 🤠, but it is empty 😵‍💫

[@OscarObians]

Love your videos. What software do you record with?

[@tobisalami]

Thanks a ton. I use Camtasia.

[@tobisalami]

What do you use?

[@OscarObians]

@@tobisalamiNice. I use OBS studio and edit in DaVinci Resolve

[@tobisalami]

Oh awesome!

[@rekhapatel7897]

Is it possible to cache the query and its query result ? so that we can serve the save result based on repeated search

[@tobisalami]

@@rekhapatel7897 that's what the cache query option does. Just make sure you have object cache enabled on your server and the Wordpress cache set to "on" as I showed.

[@jo.bloggs]

Hey Tobi, thank you so much for this. I've learned so much already. I recently came across a little hurdle and hoping you'd be able to help. I started re-creating the Glossaries into repeaters, but now I realised that I can't use them in JetFormBuilder. Unlike the Metaboxes where you can load your terms from Query Builder instead of Glossary, JetForm builder doesn't give you this option, so I can't actually load repeater items that I queried in the query builder into JFB Select/Checkbox/Radio field. Any ideas how to go about this?

[@tobisalami]

You're welcome. You can get this done by Querying the repeater using a regular Repeater Query. Then, use the syntax I showed in this video (kzbin.info/www/bejne/qWTJeJh6d7-onNEsi=X99ZpwHbhsHfGIU3) to fetch your values in.

[@tobisalami]

Which feature do you love the most?

[@stefanradu4550]

I love most of them but the accordion trick is amazing. Thanks!

[@tobisalami]

@@stefanradu4550 You are welcome!

[@legeekduweb_mtl]

Hi, I watch the video and tried to replicate de Woocommerce Cart items. I created the query has you did, then I tried to hide the button ADD TO CART if the item is in the cart. unfortunately it doesn't work... The query shows me the 123 items in the previews, only one when I add a specific product. So it works well, but on the front-end the footer popup the buton ADD to cart totally disappear on every product page. either if the product is in the cart or not in the cart. The button stays hidden even if the cart is empty. But thank you you did a great job with Query builder !

[@tobisalami]

Hi. You're welcome! And thank you for watching. About your request, I believe it could be a cache issue. Can you try disabling cache and trying again? Remember that when the query is cached, it keeps its last query ready to be used again without checking the database for updates. And it does this for a while. Maybe a few hours or a day. So, adding items to the cache and expecting immediate change to the query when the cache is in use, is not quite possible. Do you understand?

[@legeekduweb_mtl]

@@tobisalami at the moment I don't have cache activated on the website it's a staging one and test one. May Clickfunnel is the issue because I don't use the woocommerce regular Cart popup, so maybe... I'll check on it

[@billlewis22]

Tobi, question. So on the Show or hide the widget content based on Queries, how do you get that widget to show again? In my case: I would want it to show when someone clicks on a visual field from a smart filter to show the hidden listing grid. So with another query tied to the listing grid click? Thanks!~

[@tobisalami]

@@billlewis22 hey! I'm not sure I understand the question. If a section is hidden using dynamic visibility, it won't exist on a loaded page such that it can be acted upon. So, using smart filters to try to show a section hidden using Dynamic Visibility won't quite be possible (unless that section is within a listing grid).

[@tobisalami]

@@billlewis22 did I understand your question correctly?

[@billlewis22]

@@tobisalami Thanks, Tobi. I have JE listing items in an Elementor List Grid. I have various Smart Filters made with visual filters for the listing grid. I do not want the listing grid to show up (hidden) until an action (click) on a visual filter is clicked, and then the items for that action (click) are shown in the listing grid that is a JE CPT. I can hide the grid widget the way you explained, but I have been trying to get it to show after a search action (click). I hope I made myself clear, and I appreciate your videos and reply today.🤩

[@tobisalami]

@@billlewis22 Okay! It's a bit technical. Kindly send me message via Facebook or LinkedIn. We can talk in over.

[@billlewis22]

@@tobisalami I DM via linked in. Thanks

[@BWW4S]

is it possible to turn a listing Items into a shortcode?

[@tobisalami]

Technically, yes! You can put it inside a container template if you use Elementor or Bricks, and use that Shortcode Anywhere.

[@yetistudiosnet]

53:40 what if it is many to many relationship? 😭 I have a website where there are singers and songs. A song can be written by more than one singer and a singer can have more than one song. How do I go about that?

[@tobisalami]

@@yetistudiosnet it'll work the exact same way! It doesn't matter where it's many to many. What matters is the parent and the child. Try it out.😊

[@yetistudiosnet]

@@tobisalami I might be doing something wrong. I have singers and songs type of relationship where singers (P) and songs (C). I want to show the parents on the child page. I am using Bricks. I’m guessing the front end should be similar to Elementor

[@yetistudiosnet]

@@tobisalami it is working but I can’t display on the front end the data

[@mihaiciobanu01]

What can i say? Thank you so much 😊

[@tobisalami]

Thank you too! I appreciate the constant feedback!

[@90softapps]

Hi, thank you for your helpfull video. I need help. a post named "APK" post type and a post "Apk review", when user submits the review of an apk it is showing under that app, that make sense. But I want to show the avarage rating by taking average of the meta field "average_review" of Review post type. Now I am able to show the total reviews count with query results count. But I am not able to get the average of the mera field of the current apk reviews only. When i am using dynamic function it is returning the average of total reviews posts on the site. So, please give me solution, that How can I calculate the average of an apk using JetEngine Query builder or any other way. Please help.

[@tobisalami]

@@90softapps hi. Please see the video I made about building a profile completion bar. It'll give you insight into how to accomplish this.

[@90softapps]

@@tobisalami I have already watched that video. I did the same process, but I am confused about the SQL query. In your video, the context was easy (user), but in my case, I think the calculation was complex. 😥

[@Relaxingvibe97]

I am working on a travel website i need to add a search box . one key and two filters and an Apply button it will redirect me to a post section which I search how do i do that with crocoblock

[@tobisalami]

I don't have a tutorial for that at this time. But I can write this down as a suggestion.

[@webdev.vidyutpal]

Does it work with Gutenberg / GenerateBlock?

[@tobisalami]

Works with Gutenberg, yes.

[@DamilolaBabarinde]

Please: is it possible for me to create something like this with jet engines: i created a multi vendor store where vendor can create products. Now i add new cpt ( event). This cpt is the place and time they want to sell their product, which also can be also created from the front end from by each vendor. But the main thing is there will be a relationship between the product (child) and the event (parent). And when creating the event on the front end they should be able to do this and also the only product they can add to their event should be the one they created. If it is possible how will i go about it

[@tobisalami]

Hi Damilola. It's possible, yes. But explaining it here via text will be difficult as it is not a straightforward setup. I have taken this down as a suggestion for a future video, though. However, you should keep in mind that it will be difficult, natively, at this time, to manage variable products in the frontend with JetFormBuilder. If you are managing simple products, it is fairly easier to handle.

[@MrAI-p1e]

I’ve been facing an issue for weeks. I'm using Crocoblock post types, but I can't figure out how to add features like categories, tags, and other plugin options to them. These features are available and work fine with regular posts, but they’re missing when it comes to Crocoblock post types. How can I enable these features for the custom post types?

[@tobisalami]

I'm a little surprised by this. I think you should make a post in the Crocoblock Facebook community with screenshots and mention me in that. I'll take a look at it. I'm interested in what's going on there.

[@MrAI-p1e]

@@tobisalami I have posted and tagged you there. Please check

[@MrAI-p1e]

@@tobisalami Hey i have tagged you there please give me a soln

[@tobisalami]

@@MrAI-p1e can't see the tag. Kindly send me a private messenger message with the link to the post.

[@markbaquerizo6190]

Make the video with graphic examples man, plz

[@markbaquerizo6190]

I meant, showing examples in the frontend

[@tobisalami]

I'll make a video about each feature in the future.

[@nayanponz7883]

Until now, I don’t fully know or understand what a query is. I use JetEngine a lot and have a new ideas I want to develop. I believe queries will be helpful for this, but no one has explained what a query is or how to use it effectively. I don’t want to rely solely on copying and pasting from KZbin guides. I want a clear understanding so I can start building my own ideas.

[@tobisalami]

It's a good idea to understand it well. Does this video help you get an understanding of what it is used for?