GET api/userquery/search

Request Information

URI Parameters

Name	Type	Additional information
QueryType	QueryType	None.
SearchFields	Collection of KeyValueSearch	None.
UserQueryID	integer	None.
ProcessID	integer	None.
Keyword	string	None.
DateFrom	date	None.
DateTo	date	None.
LoginUserId	integer	None.
IsPublicUser	boolean	None.
PublicAccountID	integer	None.
TenantID	integer	None.
PageNo	integer	None.
RowLimit	integer	None.
RecordCount	integer	None.
Offset	integer	None.
PageCount	integer	None.

Body Parameters

None.

Response Information

Resource Description

Collection of DTOSYSUserQueryView

Name	Type	Additional information
UserQueryID	integer	None.
QueryTypeID	integer	None.
QueryTitle	string	None.
ServerName	string	None.
ServerIP	string	None.
DatabaseName	string	None.
DatabaseType	string	None.
CommandString	string	None.
CommandType	string	None.
DatabaseUserId	string	None.
DatabasePassword	string	None.
DateCreated	date	None.
DateUpdated	date	None.
CreatedBy	integer	None.
VoidFlag	boolean	None.
SqlAuthentication	boolean	None.
FlagDeleted	boolean	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "UserQueryID": 1,
    "QueryTypeID": 2,
    "QueryTitle": "sample string 3",
    "ServerName": "sample string 4",
    "ServerIP": "sample string 5",
    "DatabaseName": "sample string 6",
    "DatabaseType": "sample string 7",
    "CommandString": "sample string 8",
    "CommandType": "sample string 9",
    "DatabaseUserId": "sample string 10",
    "DatabasePassword": "sample string 11",
    "DateCreated": "2025-10-26T11:15:50.8494987+08:00",
    "DateUpdated": "2025-10-26T11:15:50.8494987+08:00",
    "CreatedBy": 14,
    "VoidFlag": true,
    "SqlAuthentication": true,
    "FlagDeleted": true
  },
  {
    "UserQueryID": 1,
    "QueryTypeID": 2,
    "QueryTitle": "sample string 3",
    "ServerName": "sample string 4",
    "ServerIP": "sample string 5",
    "DatabaseName": "sample string 6",
    "DatabaseType": "sample string 7",
    "CommandString": "sample string 8",
    "CommandType": "sample string 9",
    "DatabaseUserId": "sample string 10",
    "DatabasePassword": "sample string 11",
    "DateCreated": "2025-10-26T11:15:50.8494987+08:00",
    "DateUpdated": "2025-10-26T11:15:50.8494987+08:00",
    "CreatedBy": 14,
    "VoidFlag": true,
    "SqlAuthentication": true,
    "FlagDeleted": true
  }
]

application/xml, text/xml

Sample:

<ArrayOfDTOSYSUserQueryView xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/PTI.AF.DTO">
  <DTOSYSUserQueryView>
    <CommandString>sample string 8</CommandString>
    <CommandType>sample string 9</CommandType>
    <CreatedBy>14</CreatedBy>
    <DatabaseName>sample string 6</DatabaseName>
    <DatabasePassword>sample string 11</DatabasePassword>
    <DatabaseType>sample string 7</DatabaseType>
    <DatabaseUserId>sample string 10</DatabaseUserId>
    <DateCreated>2025-10-26T11:15:50.8494987+08:00</DateCreated>
    <DateUpdated>2025-10-26T11:15:50.8494987+08:00</DateUpdated>
    <FlagDeleted>true</FlagDeleted>
    <QueryTitle>sample string 3</QueryTitle>
    <QueryTypeID>2</QueryTypeID>
    <ServerIP>sample string 5</ServerIP>
    <ServerName>sample string 4</ServerName>
    <SqlAuthentication>true</SqlAuthentication>
    <UserQueryID>1</UserQueryID>
    <VoidFlag>true</VoidFlag>
  </DTOSYSUserQueryView>
  <DTOSYSUserQueryView>
    <CommandString>sample string 8</CommandString>
    <CommandType>sample string 9</CommandType>
    <CreatedBy>14</CreatedBy>
    <DatabaseName>sample string 6</DatabaseName>
    <DatabasePassword>sample string 11</DatabasePassword>
    <DatabaseType>sample string 7</DatabaseType>
    <DatabaseUserId>sample string 10</DatabaseUserId>
    <DateCreated>2025-10-26T11:15:50.8494987+08:00</DateCreated>
    <DateUpdated>2025-10-26T11:15:50.8494987+08:00</DateUpdated>
    <FlagDeleted>true</FlagDeleted>
    <QueryTitle>sample string 3</QueryTitle>
    <QueryTypeID>2</QueryTypeID>
    <ServerIP>sample string 5</ServerIP>
    <ServerName>sample string 4</ServerName>
    <SqlAuthentication>true</SqlAuthentication>
    <UserQueryID>1</UserQueryID>
    <VoidFlag>true</VoidFlag>
  </DTOSYSUserQueryView>
</ArrayOfDTOSYSUserQueryView>