Skip to main content
Question

Lobby Query Builder Count

  • December 9, 2021
  • 1 reply
  • 302 views
K
Sidekick (Customer)
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.

S
N
C
This topic has been closed for replies.

1 reply

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.
 

/Mino
H
Terms & ConditionsCookie settingsAccessibility statement