What is FQL?
FQL or Feedback Query Language is Feedier’s syntax for filtering feedback data across the platform or API.
Using FQL offers several advantages:
Large filtering possibilities with 20+ filters - Role & privacy support
- Performance
- Built-in security
Where to find FQL in the Platform?
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.
Use the Filter button
Select your filter(s)
Click “Apply“
The FQL will appear in the navigation bar.
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:
[{"id":{"$in":[123]}}]
Voilà!
Supporter Operators
Operator | SQL Equivalent |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
A few FQL examples
Filter | FQL syntax |
|---|---|
Filter on feedback ID = 123 | [{"id":{"$in":[123]}}]
|
Filter on feedback created yesterday | [{"created_at":{"$eq":"date_last_day"}}]
|
Filter on feedback created yesterday and survey ID = 456 | [{"created_at":{"$eq":"date_last_day"}},{"carrier_id":{"$in":[456]}}]
|
Filter on feedback created yesterday and survey ID = 456 or 789 | [{"created_at":{"$eq":"date_last_day"}},{"carrier_id":{"$in":[456; 789]}}]
|
Filter on feedback that match text analysis topic id = 3 | [{"topics":{"id":{"$in":[3]}}}]
|
Filter on feedback that have attribute “Agence” = “Lille” | [{"attribute_values":{"attribute":{"name":{"$eq":"agence"}},"value":{"$in":["Lille"]}}}]
|
Any question? Ask support@feedier.com
0 Comments