Versions Compared

Version Old Version 1 New Version 2
Changes made by

François Forest

François Forest

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

What is FQL?

Info

FQL or Feedback Query Language is Feedier’s syntax for filtering feedback data across the platform or API.

Using FQL offers several advantages:

  • (tick) Large filtering possibilities with 20+ filters

  • (tick) Role & privacy support

  • (tick) Performance

  • (tick) Built-in security

Where to find FQL in the Platform?

Info

We recommend not to build FQL from scratch, but rather using the filter buttons in the Platform to build the FQL and then using it in the API.

Screenshot 2024-05-30 at 09.26.53-20240530-072658.png

  • Use the Filter button

  • Select your filter(s)

  • Click “Apply“

  • The FQL will appear in the navigation bar.

Screenshot 2024-05-30 at 09.27.45.png

In this example, we filter on feedback ID = 123

To use it you can URL decode it to have a JSON format you can use in the API:

Code Block
[{"id":{"$in":[123]}}]

Voilà!

Supporter Operators

Operator

SQL Equivalent

$eq

=

$ne

!=

$gt

>

$lt

<

$gte

>=

$lte

<=

$like

LIKE

$nlike

NOT LIKE

$in

IN

$nin

NOT IN

$regexp

REGEXP

$nregexp

NOT REGEXP

$jsin

JSON_OVERLAPS

A couple of FQL examples

Filter

FQL syntax

Filter on feedback ID = 123

Code Block
[{"id":{"$in":[123]}}]

Filter on feedback created yesterday

Code Block
[{"created_at":{"$eq":"date_last_day"}}]

Filter on feedback created yesterday and survey ID = 456

Code Block
[{"created_at":{"$eq":"date_last_day"}},{"carrier_id":{"$in":[456]}}]

Filter on feedback created yesterday and survey ID = 456 or 789

Code Block
[{"created_at":{"$eq":"date_last_day"}},{"carrier_id":{"$in":[456; 789]}}]

Filter on feedback that match text analysis topic id = 3

Code Block
[{"topics":{"id":{"$in":[3]}}}]

Filter on feedback that have attribute “Agence” = “Lille”

Code Block
[{"attribute_values":{"attribute":{"name":{"$eq":"agence"}},"value":{"$in":["Lille"]}}}]

Info

Any question? Ask support@feedier.com