You can query a dataset for records that have been added at any time.
Methods
Call the QueryRelationalData API, specifying the scope and code of the RDD in the URL, and optionally a request body containing parameters. For example:
curl -X POST 'https://<your-domain>.lusid.com/api/api/relationaldatasets/MyDatasets/Addresses/$query'
-H 'Content-Type: application/json-patch+json'
-H 'Authorization: Bearer <your-API-access-token>'
-d '{
"queryMethod": "Latest",
"filter": "effectiveAt gt 2026-01-01",
"customSortBy": [
"fieldName": "Field1",
"priorityValues": ["Val1", "Val2"],
"remainderOrder": "ASC"
]
}'Navigate to the Data Management > Relational Datasets dashboard and click the Display name of the dataset you want to query, for example:
Every record in the dataset is returned when Query Method is set to Time Series. Switch to Latest to return just data series, or you can filter fields in the standard way to reduce the number of records:
Write a Luminesce SQL query using the Lusid.RelationalDataset.<rdd-scope>.<rdd-code> provider and execute it using a tool such as the LUSID web app, for example:
API request fields
This section supplements the API documentation.
If omitted, queryMethod defaults to TimeSeries and every record is returned (including data points within data series). To return just data series, set queryMethod to Latest. More information.
You can optionally specify a filter to restrict the data returned. See below.
You can optionally specify a customSortBy method to sort the data returned. More information coming soon.
API filtering syntax
You can use LUSID’s standard filter syntax to reduce the number of records returned by a query:
To filter on… | Syntax | Example(s) |
|---|---|---|
Primary key fields |
|
|
Effective date |
|
|
Series identifier fields |
|
|
Value fields |
|
|
Metadata fields |
|
|