Retrieving data

Fetching all users #

The FETCH should be read as: fetch all user  entities and rename the name property to “Name”.

FETCH user (key, name AS "Name")

Will yield the result, notice the column names:

Fetching users filtered by name #

The FILTER directive at line 2 should read as: filter user entities by their name  property and match only those that end in 1.

FETCH user (key, name)
FILTER AND (name LIKE "%1")

Will yield the results:

Fetching all users and their type #

FETCH user (key, name AS "Name") {
	user_type TO id_user (type AS "Type")
}

Will yield the result, notice the column names:

Fetching users by filtered by type #

FETCH user (key, name) {
	user_type TO id_user (type)
		FILTER AND (type == "Admin")
}

Will yield the results: