---
title: "offlinedataQuery (Command)"
slug: "oas-fullsdk-soapref-offlinedataquery-command-3-28"
updated: 2025-07-04T10:05:19Z
published: 2025-07-07T15:34:07Z
canonical: "docs.onespan.com/oas-fullsdk-soapref-offlinedataquery-command-3-28"
---
> ## Documentation Index
> Fetch the complete documentation index at: https://docs.onespan.com/llms.txt
> Use this file to discover all available pages before exploring further.
# offlinedataQuery (Command)
The offlinedataQuery command allows to query offline authentication data (OAD) that matches specified search criteria.
## Parameters
| Parameter name | Data type | Description |
| --- | --- | --- |
| sessionID | String | Required. The session identifier of the current administrative session. The logon command returns this identifier after a successful logon (see [logon (Command)](/sec/docs/oas-fullsdk-soapref-logon-command-3-28)). |
| attributeSet | OfflineDataAttributeSet | Required. A set containing zero or more attribute fields that specify the query search criteria. See [OfflineDataAttributeSet (Data type)](/sec/docs/oas-fullsdk-soapref-offlinedataquery-command-3-28#offlinedataattributeset-data-type). |
| fieldSet | OfflineDataFieldSet | Optional. Specifies the attribute fields to be returned for all the records matching the search criteria. See [OfflineDataFieldSet (Data type)](/sec/docs/oas-fullsdk-soapref-offlinedataquery-command-3-28#offlinedatafieldset-data-type). If fieldSet is omitted, all possible output parameters are returned. If an attribute field is not set in the database, it is not returned for that specific record. |
| queryOptions | OfflineDataQueryOptions | Optional. Options to determine what results should be returned. See [OfflineDataQueryOptions (Data type)](/sec/docs/oas-fullsdk-soapref-offlinedataquery-command-3-28#offlinedataqueryoptions-data-type). |
| Parameter name | Data type | Description |
| --- | --- | --- |
| results | OfflineDataQueryResults | Required. Result structure containing return and status codes and a list of zero or more result attribute fields. See [OfflineDataQueryResults (Data type)](/sec/docs/oas-fullsdk-soapref-offlinedataquery-command-3-28#offlinedataqueryresults-data-type). |
### OfflineDataAttributeSet (Data type)
The attributes specified in this attribute set define the search criteria.
Search attribute fields are interpreted as follows:
- A wildcard character (*) can be added to the values at the start, the end, or both. They will be interpreted as the SQL LIKE statement.
- A list of comma-separated values can be specified for the attribute that specifies the domain name. In this case it will be interpreted as the logical OR of the given values.
You cannot use wildcard characters in comma-separated values.
- If none of the above applies, the search will be done using the exact match of the given value.
| Element name | Data type | Description |
| --- | --- | --- |
| attributes | OfflineDataAttribute | Attributes specifying the offline authentication data query search criteria (see [Table: OfflineDataAttribute (Data type)](/sec/docs/oas-fullsdk-soapref-offlinedataquery-command-3-28#Tab_OfflineDataAttributeDataType)). |
| Element name | Data type | Description |
| --- | --- | --- |
| attributeOptions | AttributeOptions | Specifies how to handle the attribute value during request processing, where each option is added as a single element to attributeOptions, e.g.: true Supported values: - negative. Indicates that the specified user attribute value should not be equal to the one specified. - null. Indicates that the specified attribute should be handled as zero-value. |
| value | Any | The attribute value. The data type has to be specified by setting the xsi:type XML attribute. |
| attributeID | OfflineDataAttributeIDEnum | The attribute identifier (see [Table: offlinedataQuery (Supported input attributes)](/sec/docs/oas-fullsdk-soapref-offlinedataquery-command-3-28#Tab_offlinedataQuerySupportedInputAttributes)). |
| Attribute name | Optionality |
| --- | --- |
| OFFLINEDATAFLD_COMPONENT_LOCATION | Optional |
| OFFLINEDATAFLD_COMPONENT_TYPE | Optional |
| OFFLINEDATAFLD_DOMAIN | Optional |
| OFFLINEDATAFLD_SERIALNO | Optional |
| OFFLINEDATAFLD_USERID | Optional |
For more information about the specific attributes, see [Table: offlinedataExecute field attributes](/sec/docs/oas-fullsdk-soapref-offlinedataexecute-command-3-28#Tab_offlinedataExecuteFieldAttributes).
### OfflineDataFieldSet (Data type)
The attributes specified in the fieldSet parameter specify the offline authentication data attribute fields that should be returned by OneSpan Authentication Server for the records matching the search criteria.
If fieldSet is omitted, all possible output parameters are returned. If an attribute field is not set in the database, it is not returned for that specific record.
| Element name | Data type | Description |
| --- | --- | --- |
| attributeID | OfflineDataAttributeIDEnum | The identifier of an attribute to return (see [Table: offlinedataQuery (Supported output attributes)](/sec/docs/oas-fullsdk-soapref-offlinedataquery-command-3-28#Tab_offlinedataQuerySupportedOutputAttributes)). |
| Attribute name | Returned? |
| --- | --- |
| OFFLINEDATAFLD_APPLNAME | If defined |
| OFFLINEDATAFLD_COMPONENT_LOCATION | Always |
| OFFLINEDATAFLD_COMPONENT_TYPE | Always |
| OFFLINEDATAFLD_CREATE_TIME | Always |
| OFFLINEDATAFLD_DOMAIN | Always |
| OFFLINEDATAFLD_END_TIME | If defined |
| OFFLINEDATAFLD_EVENT_COUNTER | Always |
| OFFLINEDATAFLD_EVENT_WINDOW | Always |
| OFFLINEDATAFLD_MODIFY_TIME | Always |
| OFFLINEDATAFLD_SERIALNO | Always |
| OFFLINEDATAFLD_START_TIME | If defined |
| OFFLINEDATAFLD_USERID | Always |
For more information about the specific attributes, see [Table: offlinedataExecute field attributes](/sec/docs/oas-fullsdk-soapref-offlinedataexecute-command-3-28#Tab_offlinedataExecuteFieldAttributes).
### OfflineDataQueryOptions (Data type)
This data type determines what results should be returned.
| Element name | Data type | Description |
| --- | --- | --- |
| count | Boolean | Flag to request OneSpan Authentication Server to return only the number of records in the result set, but not the result set itself. Default value: false |
| distinct | Boolean | Flag to request OneSpan Authentication Server to return only unique query results. Default value: false |
| rowcount | Unsigned Integer | Option to request OneSpan Authentication Server to return the specified number of result records, beginning with the record specified by rowoffset. If set to 0, all result records are returned. Default value: 0 |
| rowoffset | Unsigned Integer | Option to request OneSpan Authentication Server to return result records starting from the specified offset. Can only be used together with rowcount. Default value: 0 |
| sortfieldid | String | Optional. Required if you specify SortOrder. Determines the field attribute to use as sort key when sorting the result set using SortOrder. May contain any field attribute from the FieldSet parameter. |
| sortorder | String | Optional. Determines the sort order of the result set. By default, the result set is unsorted. Possible values: - QUERYOPTIONSORTORDER_ASCENDING. Result set in ascending order. - QUERYOPTIONSORTORDER_DESCENDING. Result set in descending order. |
### OfflineDataQueryResults (Data type)
| Element name | Data type | Description |
| --- | --- | --- |
| resultCodes | ResultCodes | Required. The result and status codes returned by the command. For more information, refer to the OneSpan Authentication Server SDK Programmer's Guide, Section "Error and Status Codes". |
| resultAttribute | OfflineDataAttributeList | Required. List containing the queried offline authentication data attributes. Each item is of type OfflineDataAttributeSet (see [OfflineDataAttributeSet (Data type)](/sec/docs/oas-fullsdk-soapref-offlinedataquery-command-3-28#offlinedataattributeset-data-type)). |
| resultCount | Integer | Required. The number of items in resultAttribute. |
| errorStack | ErrorStack | Required. The error stack, indicating that the command has not completed successfully. |
## Example
> ```markup
>
>
>
>
>
> 3JSK8cmRjw4E30wAA=0nUTL-~3fmifTO
>
>
> user
> OFFLINEDATAFLD_USERID
>
>
>
>
>
>
> ```
## Requirements
Required administrative privileges:
- View User
## Additional considerations
After upgrading OneSpan Authentication Server, server data is continuously migrated while the already-upgraded OneSpan Authentication Server service is running. Until data migration has been completed, the result of a query command may be incomplete and may include both migrated and non-migrated data. This means that values for new data fields may be missing or not set correctly in the query result.