Repeating group from api parameter

Need help APIs
1

Hello!

I’ve been struggling with what I believe is a minor issue but I just can’t seem to get over it…
So, my data is retrieved by the Mysql pluggin:

Screenshot_1
Screenshot_1852×274 27.6 KB

I have a simple filter to the data. The idea is that, unless the user inputs some data to aplly the filter, the repeating group should list all records but, instead, it’s returning an empty list until the input has a value…

Can somebody help me out? Thanks in advance.

Rui Martins

2

The SQL looks ok. Possible answers:

  1. Are you using the correct connection
  2. Have you put in a Test Value, Initialized the query (by pressing button) and assigned data types?
  3. Is the preferencia_id an integer in your MYSQL db?
3

Hi @joeyg thanks for your reply!

So, yes to all your questions. I thought it might be something with the SQL instruction because the results are being displayed as soon as I input a filter:
When the page is first displayed (no records displayed):

Screenshot_2
Screenshot_21127×317 15.3 KB

After insering ‘3’ as filter:

Screenshot_3
Screenshot_31135×317 28.5 KB

Thank you once again.

4

Hi everybody, sorry but just got the solution: transfered the filter from the plugin’s query to the component itself using “:filtered”.

Rookie mistake. :slight_smile:

Thanks all.