Skip to main content

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.

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.
 

Terms & ConditionsCookie settings