# Returns a list of accounts, sorted by internalName, where the accountNumber begins with 1 and contains a 6
# The filtering and sorting criteria can be changed in the filterByAccountNumber variable.
query GetAccounts($filterByAccountNumber: AccountQueryInput!) {
accounts(input: $filterByAccountNumber) {
content {
totalCount
items {
id
version
internalName
accountNumber
externalName
fullName
supplier {
kind
id
}
country
currencyCode
database { id name }
}
}
messages {
kind
key
targets
arguments {
name
value
}
}
}
}
query GetDatabases($noFiltering: DatabaseQueryInput!) {
databases(input: $noFiltering) {
content {
totalCount
items {
id
version
name
status
sqlServerName
sqlDatabaseName
}
}
messages {
kind
key
targets
arguments {
name
value
}
}
}
}
query GetSites($noFiltering: SiteQueryInput!) {
sites(input: $noFiltering) {
content {
totalCount
items {
id
version
name
database { id name }
}
}
messages {
kind
key
targets
arguments {
name
value
}
}
}
}