{"action":"created","comment":{"url":"https://api.github.com/repos/framgia/hrm_1/pulls/comments/46026200","id":46026200,"diff_hunk":"@@ -139,14 +157,95 @@ private void displayView(int position) {\n             getSupportActionBar().setTitle(title);\n         }*/\n     }\n+    private void displayResults(String query) throws SQLException {\n+       // mDbHelper.db_value();\n+        add_data();\n+        Cursor cursor = mdDatabaseHelper.searchByInputText((query != null ? query : \"@@@@\"));\n+\n+        if (cursor != null) {\n+\n+            String[] from = new String[]{mdDatabaseHelper.FTS_COLUMN_NAME, mdDatabaseHelper.FTS_COLUMN_PHONE,\n+                    mdDatabaseHelper.FTS_BIRTH_PLACE_FIELD,mdDatabaseHelper.FTS_BIRTH_DATE_FIELD};\n+\n+              /*  for (int i=0;i<from.length;i++){\n+\n+                    Toast.makeText(getApplicationContext(),\"From  \"+from[i],Toast.LENGTH_LONG).show();\n+\n+                }*/\n+\n+\n+            int[] to = new int[]{R.id.search_result_text_view, R.id.result_number, R.id.birth_place,R.id.birth_date};\n+\n+            SimpleCursorAdapter cursorAdapter1 = new SimpleCursorAdapter(this, R.layout.result_search_item, cursor, from, to);","path":"app/src/main/java/com/framgia/hrm/activity/MainActivity.java","position":72,"original_position":72,"commit_id":"2ce68ce3f4de789414ebcf8bb4d53c54f97cf4eb","original_commit_id":"2ce68ce3f4de789414ebcf8bb4d53c54f97cf4eb","user":{"login":"nvmanh","id":2127662,"avatar_url":"https://avatars.githubusercontent.com/u/2127662?v=3","gravatar_id":"","url":"https://api.github.com/users/nvmanh","html_url":"https://github.com/nvmanh","followers_url":"https://api.github.com/users/nvmanh/followers","following_url":"https://api.github.com/users/nvmanh/following{/other_user}","gists_url":"https://api.github.com/users/nvmanh/gists{/gist_id}","starred_url":"https://api.github.com/users/nvmanh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nvmanh/subscriptions","organizations_url":"https://api.github.com/users/nvmanh/orgs","repos_url":"https://api.github.com/users/nvmanh/repos","events_url":"https://api.github.com/users/nvmanh/events{/privacy}","received_events_url":"https://api.github.com/users/nvmanh/received_events","type":"User","site_admin":false},"body":"cursorAdapter1 re-name this please","created_at":"2015-11-27T08:38:53Z","updated_at":"2015-11-27T08:38:53Z","html_url":"https://github.com/framgia/hrm_1/pull/7#discussion_r46026200","pull_request_url":"https://api.github.com/repos/framgia/hrm_1/pulls/7","_links":{"self":{"href":"https://api.github.com/repos/framgia/hrm_1/pulls/comments/46026200"},"html":{"href":"https://github.com/framgia/hrm_1/pull/7#discussion_r46026200"},"pull_request":{"href":"https://api.github.com/repos/framgia/hrm_1/pulls/7"}}},"pull_request":{"url":"https://api.github.com/repos/framgia/hrm_1/pulls/7","id":51969792,"html_url":"https://github.com/framgia/hrm_1/pull/7","diff_url":"https://github.com/framgia/hrm_1/pull/7.diff","patch_url":"https://github.com/framgia/hrm_1/pull/7.patch","issue_url":"https://api.github.com/repos/framgia/hrm_1/issues/7","number":7,"state":"open","locked":false,"title":"searchview_added","user":{"login":"AhsanBracu","id":9347388,"avatar_url":"https://avatars.githubusercontent.com/u/9347388?v=3","gravatar_id":"","url":"https://api.github.com/users/AhsanBracu","html_url":"https://github.com/AhsanBracu","followers_url":"https://api.github.com/users/AhsanBracu/followers","following_url":"https://api.github.com/users/AhsanBracu/following{/other_user}","gists_url":"https://api.github.com/users/AhsanBracu/gists{/gist_id}","starred_url":"https://api.github.com/users/AhsanBracu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AhsanBracu/subscriptions","organizations_url":"https://api.github.com/users/AhsanBracu/orgs","repos_url":"https://api.github.com/users/AhsanBracu/repos","events_url":"https://api.github.com/users/AhsanBracu/events{/privacy}","received_events_url":"https://api.github.com/users/AhsanBracu/received_events","type":"User","site_admin":false},"body":"","created_at":"2015-11-27T08:22:39Z","updated_at":"2015-11-27T08:38:53Z","closed_at":null,"merged_at":null,"merge_commit_sha":"0da9246a770a0cc49c69197467fe9145181007fa","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/framgia/hrm_1/pulls/7/commits","review_comments_url":"https://api.github.com/repos/framgia/hrm_1/pulls/7/comments","review_comment_url":"https://api.github.com/repos/framgia/hrm_1/pulls/comments{/number}","comments_url":"https://api.github.com/repos/framgia/hrm_1/issues/7/comments","statuses_url":"https://api.github.com/repos/framgia/hrm_1/statuses/2ce68ce3f4de789414ebcf8bb4d53c54f97cf4eb","head":{"label":"AhsanBracu:46741_searchview_database","ref":"46741_searchview_database","sha":"2ce68ce3f4de789414ebcf8bb4d53c54f97cf4eb","user":{"login":"AhsanBracu","id":9347388,"avatar_url":"https://avatars.githubusercontent.com/u/9347388?v=3","gravatar_id":"","url":"https://api.github.com/users/AhsanBracu","html_url":"https://github.com/AhsanBracu","followers_url":"https://api.github.com/users/AhsanBracu/followers","following_url":"https://api.github.com/users/AhsanBracu/following{/other_user}","gists_url":"https://api.github.com/users/AhsanBracu/gists{/gist_id}","starred_url":"https://api.github.com/users/AhsanBracu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AhsanBracu/subscriptions","organizations_url":"https://api.github.com/users/AhsanBracu/orgs","repos_url":"https://api.github.com/users/AhsanBracu/repos","events_url":"https://api.github.com/users/AhsanBracu/events{/privacy}","received_events_url":"https://api.github.com/users/AhsanBracu/received_events","type":"User","site_admin":false},"repo":{"id":46537707,"name":"hrm_1","full_name":"AhsanBracu/hrm_1","owner":{"login":"AhsanBracu","id":9347388,"avatar_url":"https://avatars.githubusercontent.com/u/9347388?v=3","gravatar_id":"","url":"https://api.github.com/users/AhsanBracu","html_url":"https://github.com/AhsanBracu","followers_url":"https://api.github.com/users/AhsanBracu/followers","following_url":"https://api.github.com/users/AhsanBracu/following{/other_user}","gists_url":"https://api.github.com/users/AhsanBracu/gists{/gist_id}","starred_url":"https://api.github.com/users/AhsanBracu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AhsanBracu/subscriptions","organizations_url":"https://api.github.com/users/AhsanBracu/orgs","repos_url":"https://api.github.com/users/AhsanBracu/repos","events_url":"https://api.github.com/users/AhsanBracu/events{/privacy}","received_events_url":"https://api.github.com/users/AhsanBracu/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/AhsanBracu/hrm_1","description":"Human Resource Management Application (training)","fork":true,"url":"https://api.github.com/repos/AhsanBracu/hrm_1","forks_url":"https://api.github.com/repos/AhsanBracu/hrm_1/forks","keys_url":"https://api.github.com/repos/AhsanBracu/hrm_1/keys{/key_id}","collaborators_url":"https://api.github.com/repos/AhsanBracu/hrm_1/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/AhsanBracu/hrm_1/teams","hooks_url":"https://api.github.com/repos/AhsanBracu/hrm_1/hooks","issue_events_url":"https://api.github.com/repos/AhsanBracu/hrm_1/issues/events{/number}","events_url":"https://api.github.com/repos/AhsanBracu/hrm_1/events","assignees_url":"https://api.github.com/repos/AhsanBracu/hrm_1/assignees{/user}","branches_url":"https://api.github.com/repos/AhsanBracu/hrm_1/branches{/branch}","tags_url":"https://api.github.com/repos/AhsanBracu/hrm_1/tags","blobs_url":"https://api.github.com/repos/AhsanBracu/hrm_1/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/AhsanBracu/hrm_1/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/AhsanBracu/hrm_1/git/refs{/sha}","trees_url":"https://api.github.com/repos/AhsanBracu/hrm_1/git/trees{/sha}","statuses_url":"https://api.github.com/repos/AhsanBracu/hrm_1/statuses/{sha}","languages_url":"https://api.github.com/repos/AhsanBracu/hrm_1/languages","stargazers_url":"https://api.github.com/repos/AhsanBracu/hrm_1/stargazers","contributors_url":"https://api.github.com/repos/AhsanBracu/hrm_1/contributors","subscribers_url":"https://api.github.com/repos/AhsanBracu/hrm_1/subscribers","subscription_url":"https://api.github.com/repos/AhsanBracu/hrm_1/subscription","commits_url":"https://api.github.com/repos/AhsanBracu/hrm_1/commits{/sha}","git_commits_url":"https://api.github.com/repos/AhsanBracu/hrm_1/git/commits{/sha}","comments_url":"https://api.github.com/repos/AhsanBracu/hrm_1/comments{/number}","issue_comment_url":"https://api.github.com/repos/AhsanBracu/hrm_1/issues/comments{/number}","contents_url":"https://api.github.com/repos/AhsanBracu/hrm_1/contents/{+path}","compare_url":"https://api.github.com/repos/AhsanBracu/hrm_1/compare/{base}...{head}","merges_url":"https://api.github.com/repos/AhsanBracu/hrm_1/merges","archive_url":"https://api.github.com/repos/AhsanBracu/hrm_1/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/AhsanBracu/hrm_1/downloads","issues_url":"https://api.github.com/repos/AhsanBracu/hrm_1/issues{/number}","pulls_url":"https://api.github.com/repos/AhsanBracu/hrm_1/pulls{/number}","milestones_url":"https://api.github.com/repos/AhsanBracu/hrm_1/milestones{/number}","notifications_url":"https://api.github.com/repos/AhsanBracu/hrm_1/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/AhsanBracu/hrm_1/labels{/name}","releases_url":"https://api.github.com/repos/AhsanBracu/hrm_1/releases{/id}","created_at":"2015-11-20T03:48:24Z","updated_at":"2015-11-20T01:11:10Z","pushed_at":"2015-11-27T08:22:05Z","git_url":"git://github.com/AhsanBracu/hrm_1.git","ssh_url":"git@github.com:AhsanBracu/hrm_1.git","clone_url":"https://github.com/AhsanBracu/hrm_1.git","svn_url":"https://github.com/AhsanBracu/hrm_1","homepage":null,"size":161,"stargazers_count":0,"watchers_count":0,"language":null,"has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"framgia:develop","ref":"develop","sha":"1cfb8e6ee2e026c17088ee3d1eb66533ffccef03","user":{"login":"framgia","id":2322183,"avatar_url":"https://avatars.githubusercontent.com/u/2322183?v=3","gravatar_id":"","url":"https://api.github.com/users/framgia","html_url":"https://github.com/framgia","followers_url":"https://api.github.com/users/framgia/followers","following_url":"https://api.github.com/users/framgia/following{/other_user}","gists_url":"https://api.github.com/users/framgia/gists{/gist_id}","starred_url":"https://api.github.com/users/framgia/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/framgia/subscriptions","organizations_url":"https://api.github.com/users/framgia/orgs","repos_url":"https://api.github.com/users/framgia/repos","events_url":"https://api.github.com/users/framgia/events{/privacy}","received_events_url":"https://api.github.com/users/framgia/received_events","type":"Organization","site_admin":false},"repo":{"id":46488780,"name":"hrm_1","full_name":"framgia/hrm_1","owner":{"login":"framgia","id":2322183,"avatar_url":"https://avatars.githubusercontent.com/u/2322183?v=3","gravatar_id":"","url":"https://api.github.com/users/framgia","html_url":"https://github.com/framgia","followers_url":"https://api.github.com/users/framgia/followers","following_url":"https://api.github.com/users/framgia/following{/other_user}","gists_url":"https://api.github.com/users/framgia/gists{/gist_id}","starred_url":"https://api.github.com/users/framgia/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/framgia/subscriptions","organizations_url":"https://api.github.com/users/framgia/orgs","repos_url":"https://api.github.com/users/framgia/repos","events_url":"https://api.github.com/users/framgia/events{/privacy}","received_events_url":"https://api.github.com/users/framgia/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/framgia/hrm_1","description":"Human Resource Management Application (training)","fork":false,"url":"https://api.github.com/repos/framgia/hrm_1","forks_url":"https://api.github.com/repos/framgia/hrm_1/forks","keys_url":"https://api.github.com/repos/framgia/hrm_1/keys{/key_id}","collaborators_url":"https://api.github.com/repos/framgia/hrm_1/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/framgia/hrm_1/teams","hooks_url":"https://api.github.com/repos/framgia/hrm_1/hooks","issue_events_url":"https://api.github.com/repos/framgia/hrm_1/issues/events{/number}","events_url":"https://api.github.com/repos/framgia/hrm_1/events","assignees_url":"https://api.github.com/repos/framgia/hrm_1/assignees{/user}","branches_url":"https://api.github.com/repos/framgia/hrm_1/branches{/branch}","tags_url":"https://api.github.com/repos/framgia/hrm_1/tags","blobs_url":"https://api.github.com/repos/framgia/hrm_1/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/framgia/hrm_1/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/framgia/hrm_1/git/refs{/sha}","trees_url":"https://api.github.com/repos/framgia/hrm_1/git/trees{/sha}","statuses_url":"https://api.github.com/repos/framgia/hrm_1/statuses/{sha}","languages_url":"https://api.github.com/repos/framgia/hrm_1/languages","stargazers_url":"https://api.github.com/repos/framgia/hrm_1/stargazers","contributors_url":"https://api.github.com/repos/framgia/hrm_1/contributors","subscribers_url":"https://api.github.com/repos/framgia/hrm_1/subscribers","subscription_url":"https://api.github.com/repos/framgia/hrm_1/subscription","commits_url":"https://api.github.com/repos/framgia/hrm_1/commits{/sha}","git_commits_url":"https://api.github.com/repos/framgia/hrm_1/git/commits{/sha}","comments_url":"https://api.github.com/repos/framgia/hrm_1/comments{/number}","issue_comment_url":"https://api.github.com/repos/framgia/hrm_1/issues/comments{/number}","contents_url":"https://api.github.com/repos/framgia/hrm_1/contents/{+path}","compare_url":"https://api.github.com/repos/framgia/hrm_1/compare/{base}...{head}","merges_url":"https://api.github.com/repos/framgia/hrm_1/merges","archive_url":"https://api.github.com/repos/framgia/hrm_1/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/framgia/hrm_1/downloads","issues_url":"https://api.github.com/repos/framgia/hrm_1/issues{/number}","pulls_url":"https://api.github.com/repos/framgia/hrm_1/pulls{/number}","milestones_url":"https://api.github.com/repos/framgia/hrm_1/milestones{/number}","notifications_url":"https://api.github.com/repos/framgia/hrm_1/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/framgia/hrm_1/labels{/name}","releases_url":"https://api.github.com/repos/framgia/hrm_1/releases{/id}","created_at":"2015-11-19T11:45:53Z","updated_at":"2015-11-20T01:11:10Z","pushed_at":"2015-11-27T08:22:39Z","git_url":"git://github.com/framgia/hrm_1.git","ssh_url":"git@github.com:framgia/hrm_1.git","clone_url":"https://github.com/framgia/hrm_1.git","svn_url":"https://github.com/framgia/hrm_1","homepage":null,"size":173,"stargazers_count":0,"watchers_count":0,"language":null,"has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":4,"mirror_url":null,"open_issues_count":3,"forks":4,"open_issues":3,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/framgia/hrm_1/pulls/7"},"html":{"href":"https://github.com/framgia/hrm_1/pull/7"},"issue":{"href":"https://api.github.com/repos/framgia/hrm_1/issues/7"},"comments":{"href":"https://api.github.com/repos/framgia/hrm_1/issues/7/comments"},"review_comments":{"href":"https://api.github.com/repos/framgia/hrm_1/pulls/7/comments"},"review_comment":{"href":"https://api.github.com/repos/framgia/hrm_1/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/framgia/hrm_1/pulls/7/commits"},"statuses":{"href":"https://api.github.com/repos/framgia/hrm_1/statuses/2ce68ce3f4de789414ebcf8bb4d53c54f97cf4eb"}}}}