Returns search results

GET

api/databases/{dbid}/search

The query string can contain the characters:
'*' - Any set of characters
'?' - Any one character

Search string should describe fully the word you are looking for. For example query 'aa?b' will find 'aaab', 'aabb', etc., but will not find 'aaabb', 'caaab'. etc.

Also you can use operators AND, OR, NOT.

Request:

Argument	Type	Description
dbid	GUID	The ID of the database

Query parameter	Required	Default	Options	Description
highlight		1	1/0	Hightlights search results
query	1			Returns search query
skip				Returns data starting from the given item
top			Max 200	Returns the given number of data items

Response:

Content

Type name	Description
Object

The following query finds the task with the code T100, as well as other entities that refer to this task or have T100 in the fields of string type.

Request:

GET api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/search?query=T100
Accept: text/json
Accept-Encoding: deflate
Host: localhost:6496
Cookie: sid=20715d87-29dc-429e-9a86-4b3c60cd8a45

Response:

Transfer-Encoding: chunked
Content-Encoding: 
Cache-Control: no-store
Content-Type: text/json; charset=utf-8
Date: Fri, 21 Dec 2012 16:04:36 GMT
Set-Cookie: sid=20715d87-29dc-429e-9a86-4b3c60cd8a45; path=/;
Server: Microsoft-HTTPAPI/2.0
 
{
  "Data": [
    {
      "Id": "05f4fb92-2721-4cb7-a31a-c316f9d218d5",
      "DocumentType": "Entity",
      "DocumentName": "Entity_Task",
      "Code": "T101",
      "Content": "Owner: admin ; Creator: admin ; Name: New Task name 100; Project: ; State: In Progress; Reason: Started; Folder: ; Parent: ; Time Log: User: admin...  ",
      "Title": "(T101) New Task name 100"
    },
    {
      "Id": "3b8f6008-abad-4fc4-be01-417a6849dd29",
      "DocumentType": "Entity",
      "DocumentName": "Entity_Task",
      "Code": "T201",
      "Content": "Owner: admin ; Creator: admin ; Name: New Task name 100; Project: ; State: In Progress; Reason: Started; Folder: ; Parent: ; Time Log: User: admin...  ",
      "Title": "(T201) New Task name 100"
    },
    {
      "Id": "d36d4471-bb0f-4dbe-92c2-47ef3d9373c4",
      "DocumentType": "Entity",
      "DocumentName": "Entity_Task",
      "Code": "T301",
      "Content": "Owner: admin ; Creator: admin ; Name: New Task name 100; Project: ; State: In Progress; Reason: Started; Folder: ; Parent: ; Time Log: User: admin...  ",
      "Title": "(T301) New Task name 100"
    },
    {
      "Id": "0a1de68f-2b18-490d-90bb-5de93921f00b",
      "DocumentType": "Entity",
      "DocumentName": "Entity_Task",
      "Code": "T589",
      "Content": "Owner: admin ; Creator: admin ; Name: New Task name 100; Project: ; State: Created; Reason: New; Folder: ; Parent: ; Assigned To: admin Note: abcdef...  ",
      "Title": "(T589) New Task name 100"
    },
    {
      "Id": "504ecc7e-4dfc-49bf-b906-5c4d3d06403f",
      "DocumentType": "Entity",
      "DocumentName": "Entity_Task",
      "Code": "T1287",
      "Content": "Owner: admin ; Creator: admin ; Name: New Task name 100; Project: ; State: Created; Reason: New; Folder: ; Parent: ; Assigned To: admin Note: abcdef...  ",
      "Title": "(T1287) New Task name 100"
    },
    {
      "Id": "4f4c3f65-ede5-481a-9731-5b887f91730c",
      "DocumentType": "Entity",
      "DocumentName": "Entity_Task",
      "Code": "T1427",
      "Content": "Owner: admin ; Creator: admin ; Name: New Task name 100; Project: ; State: Created; Reason: New; Folder: ; Parent: ; Assigned To: admin Note: abcdef...  ",
      "Title": "(T1427) New Task name 100"
    },
    {
      "Id": "167c80b2-9875-46e4-98c9-aa7e54cf4505",
      "DocumentType": "Entity",
      "DocumentName": "Entity_Task",
      "Code": "T1787",
      "Content": "Owner: admin ; Creator: admin ; Name: New Task name 100; Project: ; State: Created; Reason: New; Folder: ; Parent: ; Assigned To: admin Note: abcdef...  ",
      "Title": "(T1787) New Task name 100"
    },
    {
      "Id": "24106d98-249a-40fa-ad82-cc0cf6d28606",
      "DocumentType": "Entity",
      "DocumentName": "Entity_Task",
      "Code": "T1938",
      "Content": "Owner: admin ; Creator: admin ; Name: New Task name 100; Project: ; State: Created; Reason: New; Folder: ; Parent: ; Assigned To: admin Note: abcdef...  ",
      "Title": "(T1938) New Task name 100"
    },
    {
      "Id": "20c9d543-2fa3-4456-9997-7cc68f639be3",
      "DocumentType": "Entity",
      "DocumentName": "Entity_Task",
      "Code": "T2227",
      "Content": "Owner: admin ; Creator: admin ; Name: New Task name 100; Project: ; State: Created; Reason: New; Folder: ; Parent: ; Assigned To: admin Note: abcdef...  ",
      "Title": "(T2227) New Task name 100"
    },
    {
      "Id": "bf8b0e04-20ed-4ff1-bc91-a29c453ec611",
      "DocumentType": "Entity",
      "DocumentName": "Entity_Task",
      "Code": "T2427",
      "Content": "Owner: admin ; Creator: admin ; Name: New Task name 100; Project: ; State: Created; Reason: New; Folder: ; Parent: ; Assigned To: admin Note: abcdef...  ",
      "Title": "(T2427) New Task name 100"
    },
    {
      "Id": "6380772a-ae70-4ee9-88ea-1d686dc55a00",
      "DocumentType": "Entity",
      "DocumentName": "Entity_Task",
      "Code": "T2627",
      "Content": "Owner: admin ; Creator: admin ; Name: New Task name 100; Project: ; State: Created; Reason: New; Folder: ; Parent: ; Assigned To: admin Note: abcdef...  ",
      "Title": "(T2627) New Task name 100"
    },
    {
      "Id": "2ad5640e-bdec-72fc-7953-1d1778c6c2dc",
      "DocumentType": "Entity",
      "DocumentName": "Entity_Countries",
      "Code": "CNTR26",
      "Content": "Number: 100; IANA Country Code TLD: .bg; Creator: System...  ",
      "Title": "Bulgaria ( BG / BGR )"
    }
  ],
  "LoadedResultsCount": 12,
  "AllResultsCount": 12
}