Adding Community Member Count to Xano API Response
In this meeting, the State Changers are discussing an API for community Xano. The main issue is how to retrieve a list of members for a specific community in the API response. The discussion revolves around the structure of the user and community tables in the database and how they are related. The State Changers suggest using a custom query with a conditional where clause to filter the list of users based on the community ID. They also mention using an add-on to retrieve the count of users instead of the full list. The State Changers go through the code step by step, making adjustments and testing the results. In the end, they manage to retrieve the desired count of users for each community and discuss potential further improvements.