Ordering And Paging Clauses
ORDER BY
SKIP
LIMIT
Start here
What Nexyron is
From your files to an answer
Knowing what your data can answer
What it does
One connected model
Behaviour over time
Lenses
From prediction to decision
Build with it
Building on Nexyron
Language bindings
Python
Node and TypeScript
Rust
C, and other native languages
WebAssembly
AI assistants
Running it
Where Nexyron runs
Your data, and who can reach it
Doing more with less AI
Where the product is today
Cypher reference
Cypher Clauses
Cypher Functions
Cypher In Nexyron
Procedures And Algorithms Overview
Cypher Clauses Reference
LIMIT
ORDER BY
Ordering And Paging Clauses
SKIP
allShortestPaths
Pattern Features Clauses
shortestPath
CALL
CALL { ... }
LOAD CSV
Procedural Clauses
MATCH
OPTIONAL MATCH
Reading Clauses
RETURN
UNWIND
WHERE
WITH
ALTER CURRENT GRAPH TYPE
CREATE ABSTRACTION
CREATE CONSTRAINT
CREATE INDEX
CREATE Semantic Definitions
CREATE SEMANTIC INDEX
CREATE TEMPORAL PROPERTY
DROP CONSTRAINT
DROP INDEX
Schema And Admin Clauses
SHOW ABSTRACTIONS
SHOW CONSTRAINTS
SHOW CURRENT GRAPH TYPE
SHOW INDEXES
SHOW Semantic Definitions
SHOW TEMPORAL PROPERTIES
USING LENS And APPLY ANALYSIS RUN
EXPLAIN
FROM PREVIOUS
Multi-Statement Scripts
PROFILE
Statement Forms Clauses
UNION
`ASOF`
ALIGN
LATEST
TIME
Time Clauses
VALID
WINDOW
CREATE
DELETE
FOREACH
MERGE
REMOVE
SET
Writing Clauses
Cypher Functions Reference
`avg`
`avgif`
`avgmerge`
`avgstate`
`collect`
`collectmerge`
`collectstate`
`corr`
`corrmerge`
`corrstate`
`count`
`countif`
`countmerge`
`countstate`
`covarpop`
`covarpopmerge`
`covarpopstate`
`covarsamp`
`covarsampmerge`
`covarsampstate`
`first`
`firstmerge`
`firststate`
`heavyhitters`
`heavyhittersmerge`
`heavyhittersstate`
`hllcount`
`lastmerge`
`laststate`
`listagg`
`listaggmerge`
`listaggstate`
`max`
`maxif`
`maxmerge`
`maxstate`
`min`
`minif`
`minmerge`
`minstate`
`percentilecont`
`percentilecontmerge`
`percentilecontstate`
`percentiledisc`
`percentilediscmerge`
`percentilediscstate`
`regravgx`
`regravgxmerge`
`regravgxstate`
`regravgy`
`regravgymerge`
`regravgystate`
`regrcount`
`regrcountmerge`
`regrcountstate`
`regrintercept`
`regrinterceptmerge`
`regrinterceptstate`
`regrr2`
`regrr2merge`
`regrr2state`
`regrslope`
`regrslopemerge`
`regrslopestate`
`regrsxx`
`regrsxxmerge`
`regrsxxstate`
`regrsxy`
`regrsxymerge`
`regrsxystate`
`regrsyy`
`regrsyymerge`
`regrsyystate`
`sample`
`samplemerge`
`samplestate`
`stddevmerge`
`stddevpop`
`stddevpopmerge`
`stddevpopstate`
`stddevsamp`
`stddevstate`
`sum`
`sumif`
`summerge`
`sumstate`
`varpop`
`varpopmerge`
`varpopstate`
`varsamp`
`varsampmerge`
`varsampstate`
Aggregate State And Merge
Aggregation Functions
Basic Aggregates
Distinct And Sketch Aggregates
distinct_count
Filtered Aggregates
first_time
Heavy Hitters And Collection Aggregates
last_time
median
Percentiles, Statistics, And Regression
__doc_remove
__doc_set
all_different
cardinality
coalesce
Collection And Document Functions
contains_all
exists
head
keys
last
length
overlaps
pivot
properties
property_values
range
reverse
same
size
string_join
tail
unpivot
vector
distance
geo_distance_m
geo_within_bbox
geo_within_radius
Geospatial Functions
point
element_id
endNode
Graph Functions
hasLabel
id
internal_id
isDestination
isDirected
isSource
labels
property_exists
startNode
type
`atan2`
`ceiling`
`ln`
`log10`
`log2`
`pow`
`random`
abs
acos
asin
atan
ceil
cos
degrees
e
exp
floor
log
Numeric Functions
pi
power
radians
rand
round
sign
sin
sqrt
tan
edges
isAcyclic
isSimple
isTrail
nodes
path
Path Functions
relationships
current_graph
current_schema
home_graph
home_schema
info
nullif
schema
Session And Metadata Functions
session_user
`byte_length`
`lower`
`upper`
char_length
isNormalized
left
ltrim
normalize
octet_length
replace
right
rtrim
split
String Functions
substring
toLower
toUpper
trim
`active_streak`
`align_to_grid`
`asof_join`
`baseline_deviation`
`burst_count`
`burst_duration`
`calendar_window`
`changes`
`context_alignment_join`
`count_window`
`cumulative_sum`
`current_timestamp`
`currenttimestamp`
`delta`
`derivative`
`diff`
`downsample`
`dwell_time`
`ema`
`event_window`
`frequency`
`gap_duration`
`idelta`
`inactivity_streak`
`increase`
`intensity`
`inter_event_time`
`irate`
`lag`
`latest_state_join`
`latest`
`lead`
`local_time`
`missing_ratio`
`nearest_prior`
`percent_change`
`rank_in_window`
`rate`
`regularity_score`
`resample_to_grid`
`resets`
`rolling_avg`
`rolling_quantile`
`rolling_stddev`
`rolling_sum`
`sample_by`
`session_duration`
`session_window`
`sliding_window`
`spread`
`state_duration`
`state_transition_count`
`state_window`
`time_in_state`
`time_weighted_avg`
`time_weighted_sum`
`zoned_datetime`
`zoneddatetime`
`zonedtime`
bucket
bucket_wallclock
current_date
current_time
date
date_trunc
datetime
day
duration
hour
local_datetime
localdatetime
minute
month
now
Ordered Sequence Analytics
Rate And Weighted Analytics
recency
Resampling And Windowing
second
stale_since
State And Session Analytics
Temporal Functions
Temporal Joins
time
timestamp
toDate
toDateTime
toDuration
toTime
toZonedDatetime
toZonedTime
truncate
year
isTyped
toBool
toBoolean
toFloat
toInt
toInteger
toList
toString
toTypedList
Type Functions
common_neighbors
cosine_similarity
dot_product
euclidean_distance
euclidean_similarity
jaccard_similarity
manhattan_distance
overlap_similarity
pearson_similarity
preferential_attachment
same_community
total_neighbors
Vector And Similarity Functions
Cypher Procedures And Algorithms Reference
Abstraction Platform Procedures
`nexyron.forecast_intervals`
`nexyron.model_calibration_report`
`nexyron.model_compare`
`nexyron.model_evaluate`
`nexyron.model_explain`
`nexyron.model_gain_table`
`nexyron.model_materialize`
`nexyron.model_materialized_drop`
`nexyron.model_materialized_read`
`nexyron.model_pr_curve`
`nexyron.model_refresh`
`nexyron.model_roc_curve`
`nexyron.model_score_many`
`nexyron.model_score`
`nexyron.model_threshold_curve`
`nexyron.model_uncertainty_report`
Abstraction Platform/Model Runtime Procedures
`nexyron.policy_apply`
`nexyron.policy_bandit_apply`
`nexyron.policy_bandit_decide`
`nexyron.policy_bandit_evaluate`
`nexyron.policy_bandit_offpolicy_report`
`nexyron.policy_bandit_sensitivity_report`
`nexyron.policy_bandit_subgroup_report`
`nexyron.policy_causal_bandit_decide`
`nexyron.policy_causal_bootstrap_report`
`nexyron.policy_causal_compare`
`nexyron.policy_causal_diagnostic_report`
`nexyron.policy_causal_gain_table`
`nexyron.policy_causal_optimize`
`nexyron.policy_causal_score`
`nexyron.policy_causal_value_curve`
`nexyron.policy_causal_value_report`
`nexyron.policy_compare`
`nexyron.policy_dataset_compare`
`nexyron.policy_dataset_evaluate`
`nexyron.policy_decide`
`nexyron.policy_doubly_robust_compare`
`nexyron.policy_doubly_robust_report`
`nexyron.policy_evaluate`
`nexyron.policy_explain`
`nexyron.policy_gain_table`
`nexyron.policy_materialize`
`nexyron.policy_materialized_drop`
`nexyron.policy_materialized_read`
`nexyron.policy_offpolicy_compare`
`nexyron.policy_offpolicy_report`
`nexyron.policy_propensity_balance_report`
`nexyron.policy_propensity_overlap_report`
`nexyron.policy_propensity_report`
`nexyron.policy_refresh`
`nexyron.policy_uplift_compare`
`nexyron.policy_uplift_report`
Abstraction Platform/Policy, Bandit, And Causal Procedures
`nexyron.abstraction_list`
`nexyron.abstraction_match`
`nexyron.abstraction_read`
`nexyron.abstraction_register`
`nexyron.dataset_list`
`nexyron.dataset_read`
`nexyron.dataset_register`
`nexyron.feature_get`
`nexyron.feature_list`
`nexyron.feature_read`
`nexyron.feature_register`
`nexyron.feature_serve_many`
`nexyron.feature_serve`
`nexyron.intervention_list`
`nexyron.intervention_read`
`nexyron.intervention_record`
`nexyron.intervention_register`
`nexyron.intervention_response_record`
`nexyron.model_list`
`nexyron.model_read`
`nexyron.model_register`
`nexyron.policy_list`
`nexyron.policy_read`
`nexyron.policy_register`
`nexyron.scenario_evaluate`
`nexyron.scenario_list`
`nexyron.scenario_read`
`nexyron.scenario_register`
`nexyron.snapshot_list`
`nexyron.snapshot_read`
`nexyron.snapshot_register`
`nexyron.split_policy_list`
`nexyron.split_policy_read`
`nexyron.split_policy_register`
Abstraction Platform/Registry Procedures
nexyron.decision_run
`nexyron.abstraction_artifact_status`
`nexyron.abstraction_contract_status`
`nexyron.abstraction_dependency_graph`
`nexyron.abstraction_refresh_stale`
`nexyron.abstraction_task_enqueue_stale`
`nexyron.abstraction_task_list`
`nexyron.abstraction_task_run_all`
`nexyron.abstraction_task_run_once`
`nexyron.dataset_build`
`nexyron.dataset_materialize`
`nexyron.dataset_materialized_drop`
`nexyron.dataset_materialized_list`
`nexyron.dataset_materialized_read`
`nexyron.dataset_refresh`
`nexyron.feature_history`
`nexyron.feature_separability`
`nexyron.lens_rule_run_many`
`nexyron.model_materialized_list`
`nexyron.policy_materialized_list`
`nexyron.snapshot_build`
`nexyron.snapshot_materialize`
`nexyron.snapshot_materialized_drop`
`nexyron.snapshot_materialized_list`
`nexyron.snapshot_materialized_read`
`nexyron.snapshot_refresh`
Abstraction Platform/Runtime And Artifact Procedures
Algorithms/Centrality Procedures
betweenness_centrality
closeness_centrality
degree_centrality
eigenvector_centrality
harmonic_centrality
hits
pagerank
Algorithms/Clustering And Triangles Procedures
clique_counting
clustering_coefficient
total_triangles
triangle_count
triangles
Algorithms/Community Detection Procedures
bigclam
community_analytics_suite
conductance
degree_corrected_nested_stochastic_block_partition
degree_corrected_stochastic_block_partition
graph_quality
hierarchical_leiden
infomap
k1coloring
label_propagation
leiden
louvain
maxkcut
modularity_metric
modularity_optimization
nested_stochastic_block_partition
sllpa
slpa
stochastic_block_partition
Algorithms/Components And Ordering Procedures
connected_components
strongly_connected_components
topological_sort
Algorithms/Shortest Path And Routing Procedures
astar
bellman_ford
dag_longest_path
dijkstra
floyd_warshall
sssp
yens
adamic_adar
Algorithms/Similarity And Embedding Procedures
common_neighbors
fast_rp
knn
node_similarity
preferential_attachment
random_walk
resource_allocation
total_neighbors
Algorithms/Structure Procedures
articulation_points
bridges
kcore
Algorithms/Traversal Procedures
bfs
dfs
Algorithms/Trees And Flow Procedures
k_spanning_tree
kruskal
max_flow
min_cost_max_flow
prim
prize_steiner_tree
spanning_tree
steiner_tree
Abstraction Registry Procedures
Catalog And Projections Procedures
nexyron.abstraction_graph.project
nexyron.abstraction_graph.refresh
nexyron.aggregateview_create
nexyron.aggregateview_drop
nexyron.aggregateview_list
nexyron.aggregateview_read
nexyron.aggregateview_refresh
nexyron.graph.drop
nexyron.graph.list
nexyron.graph.project
nexyron.graph.refresh
nexyron.procedures
`nexyron.semantic.registry_expand`
`nexyron.semantic.search`
nexyron.semantic.edges
nexyron.semantic.mmrEdges
nexyron.semantic.mmrNodes
nexyron.semantic.nodes
Semantic Procedures
nexyron.entity_time_range
nexyron.global_time_bins
nexyron.global_time_range
nexyron.latest_global_temporal_event
nexyron.temporal_bucket_aggregate
nexyron.temporal_bucket_group_aggregate
nexyron.temporal_geo_dbscan
nexyron.temporal_geo_dbscan_many
nexyron.temporal_history
nexyron.temporal_rollup
Temporal And Streaming Procedures