Differentiate selected properties from properties required in a filter clause
To find the most recently created users, query the CreatedOn
property and add a filter that uses the greater than
operator. Adding the CreatedOn
property to the tree also selects that property.
In cases where you only want the user ID and first and last name, tell the query engine not to return the CreatedOn
property and use it in the filter.
CreatedOn
is a date expressed as the number of milliseconds since 1/1/1970.
- JSON
- YAML
{
"ViewConfig": {
"Resources": {
"User": {
"Id": { "name": "userId" },
"FirstName": { "name": "firstName" },
"LastName": { "name": "lastName" },
"CreatedOn": { "name": "createdOn", "hidden": true },
"Filter": { "Field": { "name": "createdOn", "operator": "GREATER", "value": "1440492290300" } }
}
}
}
}
---
ViewConfig:
Resources:
User:
Id:
name: "userId"
FirstName:
name: "firstName"
LastName:
name: "lastName"
CreatedOn:
name: "createdOn"
hidden: true
Filter:
Field:
name: "createdOn"
operator: "GREATER"
value: "1440492290300"
Using hidden: true
on a property removes that property from the results. The default value is false.
{
"view": {
"User": [
{
"userId": "9546bbe9-7299-4a99-bfd2-d97f8256c201",
"firstName": "Patrick",
"lastName": "Star"
},
{
"userId": "d9f3cc67-0db7-4aa5-a246-e83a62ea5c62",
"firstName": "SpongeBob",
"lastName": "SquarePants"
}
]
}
}