Loading and Filtering table column (100+ items)

Data Service
1

Good Day,

I have a table with many columns and rows. I would like to retrieve only one column of the database and filter out all duplicate rows. There is also more than a 100 rows of data, so I am not sure how the logic will look for this so I can display the list on my page.

Kind Regards
Donovan

2

Hello @Donovan_Hardwick

looks like you should use a distinct option. Here is an example:

  • without distinct:
➜  ~ curl -i https://api.backendless.com/<app-id>/<api-key>/data/Comment\?property\=text
HTTP/1.1 200 OK
server: nginx
date: Thu, 29 Sep 2022 08:11:10 GMT
content-type: application/json
content-length: 141
access-control-allow-origin: *
access-control-allow-methods: POST, GET, OPTIONS, PUT, DELETE, PATCH
strict-transport-security: max-age=86400

[
  {"___class":"Comment","text":null},
  {"___class":"Comment","text":"c1"},
  {"___class":"Comment","text":null},
  {"___class":"Comment","text":"c1"},
  {"___class":"Comment","text":"c2"},
  {"___class":"Comment","text":"c3"}
]%
  • And WITH distinct
➜  ~ curl -i https://api.backendless.com/<app-id>/<api-key>/data/Comment\?property\=text
HTTP/1.1 200 OK
server: nginx
date: Thu, 29 Sep 2022 08:11:10 GMT
content-type: application/json
content-length: 141
access-control-allow-origin: *
access-control-allow-methods: POST, GET, OPTIONS, PUT, DELETE, PATCH
strict-transport-security: max-age=86400

[
  {"___class":"Comment","text":null},
  {"___class":"Comment","text":"c1"},
  {"___class":"Comment","text":"c2"},
  {"___class":"Comment","text":"c3"} 
]%

as you can see with distinct you have no duplicates of the records

3

Thank you @sergey.kuk

How will I be able to do this using codless logic.

Kind Regards
Donovan

4

Hello @Donovan_Hardwick

Use this block in Codeless

image
image2880×1592 416 KB

Regards,
Inna

5

Thank you.