Skip to main content
Question

Lobby Query Builder Count

  • December 9, 2021
  • 1 reply
  • 276 views

Forum|alt.badge.img+4

Hello

 

Please i want to know if we can Create a lobby via Query Builder usint a count ? Because i didn’i found how to do a count Using SQL, so it is possible to create it using Query Builder ? 

 

Thank you.

This topic has been closed for comments

Minoshini Fonseka
Superhero (Employee)
Forum|alt.badge.img+19

Hi @Kochrim,

If your initial problem was to create a counter element using data source of SQL type, you could see below example. 
 

  • In the columns, you could provide the count(*) to get the aggregated value.
Figure 1: SQL Data Source 
Figure 2: Element Designer



It’s also the same way for Query Builder type Data Source as well.

Figure 3: Query Builder Data Source 
Figure 4: Element Designer

 

There are some other ways to get the count from the Element designer as well.  I will explain that with SQL Data source. 

 

Figure 5: SQL Data Source - get all the results
  • From the Element Designer we provide the aggregation.
Figure 6: Introducing count from Element Designer


Hope this helps you to get the count of your requirement.
 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings