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"
}
]
}
}