Hash Operator (#) can be used to access members of objects in an array of objects as below.
Hash Operator (#) can be used to access members of objects in an array of objects as below.
−
Multiple keys can be comma separated, and subkeys can be separated with periods (.). Example: x#"id,email.official,address.zip" etc., where x is an array of objects with fields and subfields.
<pre>
<pre>
Line 226:
Line 225:
|}
|}
+
+
=====More Complex Keys and Queries to Arrays of Objects=====
+
+
Multiple keys can be comma separated, and subkeys can be separated with periods (.). Example: x#"id,email.official,address.zip" etc., where x is an array of objects with fields and subfields.
+
+
Simple numbers for indices will extract the specified objects at such indices. Example: a#1 extracts the element at index 1. a#1..3 gets elements at indices 1 to 3 etc.
+
+
These notations can be called from Calcis containing objects in cells etc.