POST api/SaveUpdateQueryManager
Request Information
URI Parameters
None.
Body Parameters
QueryManager| Name | Description | Type | Additional information |
|---|---|---|---|
| QueryId | integer |
None. |
|
| QueryName | string |
None. |
|
| QDescription | string |
None. |
|
| QLongDescription | string |
None. |
|
| QueryCategory | integer |
None. |
|
| QueryCategoryName | string |
None. |
|
| QueryAccess | integer |
None. |
|
| CustomSql | string |
None. |
|
| Comments | string |
None. |
|
| CreatedBy | string |
None. |
|
| ModifiedBy | string |
None. |
|
| UserIdCreated | integer |
None. |
|
| CreatedDate | date |
None. |
|
| UserIdModified | integer |
None. |
|
| ModifiedDate | date |
None. |
|
| RowStatus | string |
None. |
|
| IsCutsom | boolean |
None. |
|
| LastRunBy | string |
None. |
|
| LastRunDate | date |
None. |
|
| Type | string |
None. |
|
| PreviousSQL | string |
None. |
|
| IsInnerQuery | boolean |
None. |
|
| Favourite | string |
None. |
|
| RowsCount | string |
None. |
|
| Permission | string |
None. |
|
| QueryDetailsList | Collection of QueryDetails |
None. |
|
| QueryJoinsList | Collection of QueryJoins |
None. |
|
| QueryWhereClauseList | Collection of QueryWhereClause |
None. |
|
| QueryGroupsList | Collection of QueryGroups |
None. |
|
| SubQueries | Collection of QueryManager |
None. |
|
| QueryPermissons | Collection of QueryPermissions |
None. |
|
| SendNotification | boolean |
None. |
|
| ErrorMessage | string |
None. |
Request Formats
application/json
Sample:
Sample not available.
text/json
Sample:
Sample not available.
application/xml
Sample:
Sample not available.
text/xml
Sample:
Sample not available.
application/x-www-form-urlencoded
Sample:
Sample not available.
Response Information
Resource Description
QueryManager| Name | Description | Type | Additional information |
|---|---|---|---|
| QueryId | integer |
None. |
|
| QueryName | string |
None. |
|
| QDescription | string |
None. |
|
| QLongDescription | string |
None. |
|
| QueryCategory | integer |
None. |
|
| QueryCategoryName | string |
None. |
|
| QueryAccess | integer |
None. |
|
| CustomSql | string |
None. |
|
| Comments | string |
None. |
|
| CreatedBy | string |
None. |
|
| ModifiedBy | string |
None. |
|
| UserIdCreated | integer |
None. |
|
| CreatedDate | date |
None. |
|
| UserIdModified | integer |
None. |
|
| ModifiedDate | date |
None. |
|
| RowStatus | string |
None. |
|
| IsCutsom | boolean |
None. |
|
| LastRunBy | string |
None. |
|
| LastRunDate | date |
None. |
|
| Type | string |
None. |
|
| PreviousSQL | string |
None. |
|
| IsInnerQuery | boolean |
None. |
|
| Favourite | string |
None. |
|
| RowsCount | string |
None. |
|
| Permission | string |
None. |
|
| QueryDetailsList | Collection of QueryDetails |
None. |
|
| QueryJoinsList | Collection of QueryJoins |
None. |
|
| QueryWhereClauseList | Collection of QueryWhereClause |
None. |
|
| QueryGroupsList | Collection of QueryGroups |
None. |
|
| SubQueries | Collection of QueryManager |
None. |
|
| QueryPermissons | Collection of QueryPermissions |
None. |
|
| SendNotification | boolean |
None. |
|
| ErrorMessage | string |
None. |
Response Formats
application/json
Sample:
Sample not available.
text/json
Sample:
Sample not available.
application/xml
Sample:
Sample not available.
text/xml
Sample:
Sample not available.