Question

Lobby Query Builder Count

  • 9 December 2021
  • 1 reply
  • 237 views
K
Rank
Userlevel 3
Badge +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

1 reply

Minoshini Fonseka
Rank
Userlevel 7
Badge +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.
 

/Mino
Terms & ConditionsCookie settings