Who can access ?

Roles	Access
👑 Admins	Full access
🛠️ Editors	No access
👀 Viewers	No access
🔒 Restricted Viewers	No access

Where to use Feedback Query Language (FQL) ?

FQL allows you to create complexe filters on your feedback data. It can be used in :

What is the easiest way to build an FQL filter ?

Create the filter in the platform

2. Copy paste the url of you browser.

3. Decode the URL in any decoder. For example here.

You will obtain something like :

https://bx.feedier.staging.alkalab.com/live-feed/feedback?fql=[[{"Form":{"$in":[453],"$type":"and"}}],[{"Attribute":{"$in":["United States"],"name":"country","$type":"and"}}],[{"Nps":{"$in":["promoter"],"$type":"and"}}]]&page=1

You will find the FQL in it 🎉

What are the available operators ?

A list of operators is available and can be used for perform a query on differents selectors.

Name	Operator	Accepted values	Description
Type	$type	`and` (default) `or`	The OR comparaison is for the entire query.
Equal	$eq	`int` `string`	Strict comparaison using = operator.
Not Equal	$ne	`int` `string`	Strict comparaison using != operator.
Greater Than	$gt	`int` `string`	Strict comparaison using > operator.
Lower Than	$lt	`int` `string`	Strict comparaison using < operator.
Greater Than or Equal	$gte	`int` `string`	Strict comparaison using >= operator.
Lower Than or Equal	$lte	`int` `string`	Strict comparaison using <= operator.
Contains	$like	`int` `string`	Containing one the given values. Examples: Match for `new`: “My new* field”* Doesn’t match for `My field`: “My new field”
Does not contain	$nlike	`int` `string`	Doesn’t contain the given values.
In	$in	`array`	Strict contain one the given values.
Not In	$nin	`array`	Strict doesn’t contain the given values.
Between	$btw	`array`	Ranges between the Start Date from the beginning of the day to the End Date end of the day

What are the available operators ?

Name	Example	Note
Attribute	[ { "Attribute": { "name": "age", "$in": [ "23" ], "$type":"and"} } } ]
Time period filter is applied on created_at field	[ { "TimePeriod": { "$eq": "date_last_month", "$type":"and" } }, { "TimePeriod": { "$gt": "2023-03-01T00:00:00.000Z", "$type":"and" } }, ]	You can use : date_last_day to target feedbacks from yesterday.
Form filter is done on carrier_id	[ { "Form": { "$in": [ 28121 ], "$type":"and" } } ]
Feedback Id	[ { "Id": { "$in": [ 12, 23 ], "$type":"and" } } ]
Satisfaction Ratio	[ { "SatisfactionRatio": { "$gt": "50", "$type":"and" } } ]
Question Answer	[ { "QuestionAnswer": { "question_id": 1132803, "question_type": "textarea", "$eq": "50", "$type":"and" } } ]	`question_id` (optional) → ID of the question `question_type` (optional) → Type of the question
Team	[ { "Team": { "$in": [ 13682 ], "$type":"and" } } ]
Completed	[ { "completed": { "$eq": 1 }, "$type":"and" } ]
Owner	[ { "Owner": { "$in": [ 17107 ], "$type":"and" } } ]
Status	[ { "Status": { "$eq": 1, "$type":"and" } } ]
Completion time	[ { "CompletionTime": { "$gt": 0, "$type":"and" } } ]
Topic	[ { "Topic": { "$in": [ 2713 ], "$type":"and" } } ]	Feedback with at least 1 question answer with this topic
Source	[ { "Source": { "$eq": "survey", "$type":"and" } } ]
NPS	[ { "NPS": { "$in": [ "promoter" ] } } ]

Importing feedbacks from CSV