Teta CMS is on ProductHunt 🎉
Perform fast json queries
In a short time, without any effort.
Get started
Fetch docs in collection
It returns all the docs in "CollectionName" collection.
MATCH name EQ CollectionName;
IN docs;
In SQL: SELECT * FROM CollectionName
Select a field
It returns only fields where name is equal to "_name" from all the docs
MATCH name EQ CollectionName;
IN docs;
GET _name;
Equivalent in SQL: SELECT _name FROM CollectionName
With condition
Returns all documents that match the condition
MATCH name EQ CollectionName;
IN docs;
MATCH _name = 'value';
Equivalent in SQL: SELECT _name FROM CollectionName WHERE _name = "value"
OR condition
Returns all documents that match the conditions
MATCH name EQ CollectionName;
IN docs;
MATCHOR _name EQ 'value' _name LIKE /value2/;
Equivalent in SQL: SELECT _name FROM CollectionName WHERE _name = "value" OR _name = "value2"
Sort docs
Returns all documents sorted by field name. Use -1 or 1 to choose the order.
MATCH name EQ CollectionName;
IN docs;
MATCHOR _name EQ 'value' _name LIKE /value2/;
SORT _name 1;
Equivalent in SQL: SELECT _name FROM CollectionName WHERE _name = "value" OR _name = "value2" ORDER BY _name ASC
Limit docs
Returns all documents limited by a number.
MATCH name EQ CollectionName;
IN docs;
MATCHOR _name EQ 'value' _name LIKE /value2/;
SORT _name 1;
LIMIT 10;
Equivalent in SQL: SELECT _name FROM CollectionName WHERE _name = "value" OR _name = "value2" ORDER BY _name ASC LIMIT 10
From multi collections
Get documents from multi collections
MATCHOR name EQ CollectionName1 name EQ CollectionName2;
IN docs;
Equivalent in SQL: SELECT * FROM CollectionName1, CollectionName2
Date conditions
Fetch docs by a date condition.
You can combine GT, LT, DateSub, and DateAdd.
MATCHOR name EQ CollectionName;
IN docs;
MATCH created_at GT DATESUB($now $week);
Equivalent in SQL: SELECT * FROM CollectionName WHERE created_at > now() - interval '1 month'
Start using Ayaya.
And perform custom queries on your back-end effortlessly.
We are a European 
software company. We help people from all over the world to build their products.
software company. We help people from all over the world to build their products.
Onda Teta S.R.L.
Largo dei Colli Albani - 00179 Rome (RM)
C.F/P.IVA IT16321091007
REA RM1648901
RESOURCES
Pricing
Flutter Package
Open metrics
Release Tracker
Documentation
Flutter docs
Microsoft Store
COMPANY
Say hi 👋
Careers
Service Status
Privacy Policy
Terms and Conditions
Cookie Policy
Backed by
Copyright © 2022 Onda Teta S.R.L.