pleytedts.online / 127.0.0.1 / denr_db / document_table

There are no favorite tables.

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (1116 total, Query took 0.0017 seconds.) [denrtransactionno: [BLOB - 10 B]... - [BLOB - 10 B]...]

SELECT * FROM `document_table` ORDER BY `denrtransactionno` DESC

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

			id	denrtransactionno 1	denrname	denrsender	denraddress	denrdaterecv	denrformtime	denrsubject	denrdocumentsource	denrdoctype	denrdocumentstatus	denrdatetransmitted	denrofficeorigin	outgoing_frontdeskrecvtime	outgoing_frontdeskrecvdate	outgoing_frontdeskprocessor	outgoing_frontdeskdateprocessed	outgoing_frontdesktime	outgoing_frontdeskaction	outgoing_frontdeskactionother	outgoing_penrorecvtime	outgoing_penrorecvdate	outgoing_penroprocessor	outgoing_penroworkgroup	outgoing_penroaction	outgoing_penrodateprocessed	outgoing_penrotime	penrorecvtime	penrorecvdate	penropriority	penroprocessor	penrodateprocessed	penrotime	penroaction	penroactionother	penrodepartment	reroute_penroprocessor	reroute_penroworkgroup	reroute_penroaction	reroute_penrodateprocessed	reroute_penrotime	deptrecvtime	deptrecvdate	deptprocessor	deptdateprocessed	depttime	deptpriority	deptaction	deptactionother	deptworkgroup	deptto	reroute_deptprocessor	reroute_deptworkgroup	reroute_deptdateprocessed	reroute_depttime	reroute_deptaction	outgoing_deptrecvtime	outgoing_deptrecvdate	outgoing_deptprocessor	outgoing_deptworkgroup	outgoing_deptaction	outgoing_deptactionother	outgoing_deptdateprocessed	outgoing_depttime	unitrecvtime	unitrecvdate	unitprocessor	unitworkgroup	unitmyworkgroup	unitdateprocessed	unittime	unitaction	unitto	sectionrecvdate	sectionrecvtime	sectionprocessor	sectionworkgroup	sectionmyworkgroup	sectiondateprocessed	sectiontime	sectionaction	sectionto	outgoing_unitrecvdate	outgoing_unitrecvtime	outgoing_unitprocessor	outgoing_unitworkgroup	outgoing_unitdateprocessed	outgoing_unittime	outgoing_unitaction
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1083	1083	2025-14965	DANEKA NATULLA	JARESS NERI	PALO, LEYTE	2025-01-23	05:07 PM	FOLLOW UP ON THE MOTION TO INTERVENE ON THE ENTITL...	EMAIL	LETTER	Forwarded From Frontdesk	2025-01-23	JARESS NERI
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1082	1082	2025-14964	DANEKA NATULLA	PROVINCIAL LAND USE COMMITTE	TACLOBAN CITY	2025-01-23	04:54 PM	PROVINCIAL LAND USE COMMITTEE (PLUC) MEETING FOR T...	EMAIL	NOTICE	Forwarded From Frontdesk	2025-01-23	PROVINCIAL LAND USE COMMITTE
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1081	1081	2025-14963	DANEKA NATULLA	REGION	TACLOBAN CITY	2025-01-23	04:41 PM	IN THE MATTER OF THE APPREHENDED TWO HUNDRED EIGHT...	WALK IN	CERTIFICATE OF FINALITY	Forwarded From Frontdesk	2025-01-23	REGION
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1080	1080	2025-14962	DANEKA NATULLA	REGION	TACLOBAN CITY	2025-01-23	04:33 PM	RE: NOTICE FOR RE-EVALUATION OF COMMUNITY BASED FO...	WALK IN	MEMORANDUM	Forwarded From Frontdesk	2025-01-23	REGION
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1079	1079	2025-14961	DANEKA NATULLA	REGION	TACLOBAN CITY	2025-01-23	04:32 PM	RE: NOTICE FOR RE-EVALUATION OF COMMUNITY BASED FO...	WALK IN	MEMORANDUM	Forwarded From Frontdesk	2025-01-23	REGION
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1078	1078	2025-14960	DANEKA NATULLA	REGION	TACLOBAN CITY	2025-01-23	04:30 PM	RE: NOTICE FOR RE-EVALUATION OF COMMUNITY BASED FO...	WALK IN	MEMORANDUM	Forwarded From Frontdesk	2025-01-23	REGION
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1077	1077	2025-14959	DANEKA NATULLA	REGION	TACLOBAN CITY	2025-01-23	04:28 PM	APPROVED APPRAISAL REPORT: 1.) MLA NO. 083703-19 W...	WALK IN	MEMORANDUM	Forwarded From Frontdesk	2025-01-23	REGION
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1076	1076	2025-14958	DANEKA NATULLA	REGION	TACLOBAN CITY	2025-01-23	04:17 PM	APPROVED SUB-ALLOTMENT ADVICE NO. PL-2025-1-001 DA...	WALK IN	MEMORANDUM	Forwarded From Frontdesk	2025-01-23	REGION
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1075	1075	2025-14957	DANEKA NATULLA	REGION	TACLOBAN CITY	2025-01-23	04:15 PM	ENCOURAGING LOCAL GOVERNMENT UNITS TO USE THE GEOH...	WALK IN	MEMORANDUM	Forwarded From Frontdesk	2025-01-23	REGION
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1074	1074	2025-14956	DANEKA NATULLA	REGION	TACLOBAN CITY	2025-01-23	04:13 PM	APPROVED SUB-ALLOTMENT ADVICE NO. PL-2025-1-003 DA...	WALK IN	MEMORANDUM	Forwarded From Frontdesk	2025-01-23	REGION
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1073	1073	2025-14955	DANEKA NATULLA	CENRO PALO	PALO, LEYTE	2025-01-23	04:00 PM	MONTHLY ACCOMPLISHMENT REPORT OF THE PROTECTED ARE...	WALK IN	MEMORANDUM	Forwarded From TSD	2025-01-23	CENRO PALO															04:38 PM	2025-01-23	3	KEVIN MEMORACION	2025-01-23	04:38 PM	FOR APPROPRIATE ACTION		TSD						04:54 PM	2025-01-23	KEVIN MEMORACION	2025-01-23	04:57 PM	2	FOR REVIEW AND EVALUATION, FOR ENDORSEMENT PREPARA...		CDS	RAQUEL DABUET
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1072	1072	2025-14954	DANEKA NATULLA	REGION	TACLOBAN CITY	2025-01-23	03:56 PM	GUIDELINES ON THE USE OF DENR VIII HOSTEL.	EMAIL	MEMORANDUM	Forwarded From PENRO	2025-01-23	REGION															04:13 PM	2025-01-23	3	KEVIN MEMORACION	2025-01-23	04:39 PM	OTHERS	LET US ADOPT THIS GUIDELINES AND HARMONIZE IT WITH...	MSD
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1065	1065	2025-14953	DANEKA NATULLA	CENRO PALO	PALO, LEYTE	2025-01-23	03:14 PM	MONTHLY ACCOMPLISHMENT REPORT OF THE COMMUNITY-BAS...	WALK IN	MEMORANDUM	Forwarded From TSD	2025-01-23	CENRO PALO															04:09 PM	2025-01-23	2	KEVIN MEMORACION	2025-01-23	04:39 PM	FOR APPROPRIATE ACTION		TSD						04:54 PM	2025-01-23	KEVIN MEMORACION	2025-01-23	04:57 PM	2	FOR REVIEW AND EVALUATION, FOR ENDORSEMENT PREPARA...		CDS	RAQUEL DABUET
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1064	1064	2025-14952	DANEKA NATULLA	ANA LUZ E. DEL ROSARIO	TACLOBAN CITY	2025-01-23	02:38 PM	REMINDER LETTER FROM PAG-IBIG FUND FOR THE SHORT-T...	EMAIL	LETTER	Forwarded From PENRO	2025-01-23	PAG-IBIG FUND															04:09 PM	2025-01-23	3	KEVIN MEMORACION	2025-01-23	04:41 PM	FOR APPROPRIATE ACTION		MSD
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1063	1063	2025-14951	DANEKA NATULLA	R8 COA	TACLOBAN CITY	2025-01-23	02:32 PM	STATEMENT OF AUDIT SUSPENSIONS, DISALLOWANCES AND ...	WALK IN	SASDC	Forwarded From PENRO	2025-01-23	R8 COA															04:09 PM	2025-01-23	3	KEVIN MEMORACION	2025-01-23	04:42 PM	FOR APPROPRIATE ACTION, OTHERS	LET US COMPLY.	MSD
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1062	1062	2025-14950	DANEKA NATULLA	CENRO PALO	PALO, LEYTE	2025-01-23	02:28 PM	REQUEST FOR APPROVAL OF ORDER OF REVOCATION OF FRE...	WALK IN	MEMORANDUM	Forwarded From TSD	2025-01-23	CENRO PALO															04:09 PM	2025-01-23	3	KEVIN MEMORACION	2025-01-23	04:42 PM	FOR APPROPRIATE ACTION		TSD						04:54 PM	2025-01-23	KEVIN MEMORACION	2025-01-23	04:58 PM	3	FOR REVIEW AND EVALUATION, FOR ENDORSEMENT PREPARA...		RECORDS	LOVELEY ANN C. BASILIO
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1061	1061	2025-14949	DANEKA NATULLA	CENRO PALO	PALO, LEYTE	2025-01-23	02:24 PM	SUBMISSION OF TREE PLANTING ACTIVITIES WITHIN THE ...	WALK IN	MEMORANDUM	Forwarded From TSD	2025-01-23	CENRO PALO															04:09 PM	2025-01-23	3	KEVIN MEMORACION	2025-01-23	04:42 PM	FOR APPROPRIATE ACTION		TSD						04:54 PM	2025-01-23	KEVIN MEMORACION	2025-01-23	04:59 PM	3	FOR INFORMATION AND RECORD, OTHERS	FOR CONSOLIDATION.	NGP	Wincel Nuñez
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1060	1060	2025-14948	DANEKA NATULLA	CENRO PALO	PALO, LEYTE	2025-01-23	02:23 PM	SUBMISSION OF TREE PLANTING ACTIVITIES WITHIN THE ...	WALK IN	MEMORANDUM	Forwarded From TSD	2025-01-23	CENRO PALO															04:09 PM	2025-01-23	3	KEVIN MEMORACION	2025-01-23	04:42 PM	FOR APPROPRIATE ACTION		TSD						04:54 PM	2025-01-23	KEVIN MEMORACION	2025-01-23	05:00 PM	3	FOR INFORMATION AND RECORD, OTHERS	FOR CONSOLIDATION.	NGP	Wincel Nuñez
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1059	1059	2025-14947	DANEKA NATULLA	CENRO PALO	PALO, LEYTE	2025-01-23	02:17 PM	SUBMISSION OF THE MONTHLY REPORT ON THE MAINTENANC...	WALK IN	MEMORANDUM	Forwarded From TSD	2025-01-23	CENRO PALO															04:09 PM	2025-01-23	3	KEVIN MEMORACION	2025-01-23	04:42 PM	FOR APPROPRIATE ACTION		TSD						04:54 PM	2025-01-23	KEVIN MEMORACION	2025-01-23	05:01 PM	2	FOR ENDORSEMENT PREPARATION TO RO, FOR INFORMATION...		NGP	Wincel Nuñez
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1058	1058	2025-14946	DANEKA NATULLA	CENRO PALO	PALO, LEYTE	2025-01-23	02:14 PM	ENHANCED NATIONAL GREENING PROGRAM MONTHLY REPORT ...	WALK IN	MEMORANDUM	Forwarded From TSD	2025-01-23	CENRO PALO															04:12 PM	2025-01-23	3	KEVIN MEMORACION	2025-01-23	04:42 PM	FOR APPROPRIATE ACTION		TSD						04:54 PM	2025-01-23	KEVIN MEMORACION	2025-01-23	05:01 PM	2	FOR REVIEW AND EVALUATION, FOR ENDORSEMENT PREPARA...		NGP	Wincel Nuñez
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1057	1057	2025-14945	DANEKA NATULLA	ARLENE A. ROMASANTA	QUEZON CITY	2025-01-23	01:26 PM	GO-LIVE OF THE ENHANCED ADR-MONITORING AND RESULTS...	EMAIL	MEMORANDUM	Forwarded From TSD	2025-01-23	DENR CENTRAL OFFICE															04:12 PM	2025-01-23	3	KEVIN MEMORACION	2025-01-23	04:43 PM	FOR APPROPRIATE ACTION		TSD						04:54 PM	2025-01-23	KEVIN MEMORACION	2025-01-23	05:02 PM	3	FOR ENDORSEMENT PREPARATION TO CENRO BAYBAY, FOR E...		RPS	EVANGELINE LOPEZ
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1056	1056	2025-14944	DANEKA NATULLA	REGION	TACLOBAN CITY	2025-01-23	10:51 AM	CENRO PLAO LAWIN FOREST AND BIODIVERSITY PROTECTIO...	WALK IN	MEMORANDUM	Forwarded From TSD	2025-01-23	REGION															04:12 PM	2025-01-23	3	KEVIN MEMORACION	2025-01-23	04:43 PM	FOR APPROPRIATE ACTION		TSD						04:54 PM	2025-01-23	KEVIN MEMORACION	2025-01-23	05:02 PM	2	FOR REVIEW AND EVALUATION, FOR ENDORSEMENT PREPARA...		MES	MICHAEL MACALALAG
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1055	1055	2025-14943	DANEKA NATULLA	REGION	TACLOBAN CITY	2025-01-23	10:48 AM	APPLICATION FOR A SPECIAL LAND USE PERMIT (SLUP) O...	EMAIL	MEMORANDUM	Forwarded From TSD	2025-01-23	REGION															04:12 PM	2025-01-23	3	KEVIN MEMORACION	2025-01-23	04:43 PM	FOR APPROPRIATE ACTION		TSD						04:54 PM	2025-01-23	KEVIN MEMORACION	2025-01-23	05:03 PM	3	FOR ENDORSEMENT PREPARATION TO CENRO PALO, OTHERS	THIS IS IN CONNECTION TO TRANSACTION 14637 AND 145...	RPS	EVANGELINE LOPEZ
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1054	1054	2025-14942	DANEKA NATULLA	REGION	TACLOBAN CITY	2025-01-23	10:46 AM	REMINDERS ON THE SUBMISSION AND ENDORSEMENT OF COM...	EMAIL	MEMORANDUM	Completed From PENRO	2025-01-23	REGION															04:13 PM	2025-01-23	3	KEVIN MEMORACION	2025-01-23	04:46 PM	REOCCURRING DOCUMENT, OTHERS	REOCCURRING DOCUMENT (TRANSACTION 14875). THIS WAS...	FRONTDESK
Edit	Copy	Delete DELETE FROM document_table WHERE `document_table`.`id` = 1053	1053	2025-14941	DANEKA NATULLA	REGION	TACLOBAN CITY	2025-01-23	10:44 AM	UPLOADING OF E-FMS ENTRIES FOR CY 2025.	EMAIL	MEMORANDUM	Forwarded From TSD	2025-01-23	REGION															04:13 PM	2025-01-23	3	KEVIN MEMORACION	2025-01-23	04:48 PM	FOR APPROPRIATE ACTION		TSD						04:54 PM	2025-01-23	KEVIN MEMORACION	2025-01-23	05:03 PM	3	FOR APPROPRIATE ACTION, FOR ENDORSEMENT PREPARATIO...		MES	MICHAEL MACALALAG

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view