pleytedts.online / 127.0.0.1 / palo_db / cenro_recv_incoming

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 (518 total, Query took 0.0072 seconds.) [records_outgoing_workgroup: ... - ...]

SELECT * FROM `cenro_recv_incoming` ORDER BY `records_outgoing_workgroup` ASC

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

Filter rows:

			id	records_transactionno	records_processor	records_section	records_workgroup	records_sender	records_address	records_daterecv	records_subject	records_documentsource	records_doctype	records_documentstatus	records_officeorigin	records_dateprocessed	records_time	records_receiver	cenro_recvdate	cenro_recvtime	cenro_processor	cenro_workgroup	cenro_section	cenro_priority	cenro_action	cenro_action_others	cenro_receiver	cenro_dateprocessed	cenro_time	section_recvdate	section_recvtime	section_processor	section_workgroup	section_section	section_priority	section_action	section_action_others	section_receiver	section_dateprocessed	section_time	focal_recvdate	focal_recvtime	focal_processor	focal_workgroup	focal_section	focal_action	focal_dateprocessed	focal_time	focal_receiver	section_outgoing_recvdate	section_outgoing_recvtime	section_outgoing_processor	section_outgoing_workgroup	section_outgoing_section	section_outgoing_action	section_outgoing_dateprocessed	section_outgoing_time	section_outgoing_receiver	cenro_outgoing_recvdate	cenro_outgoing_recvtime	cenro_outgoing_processor	cenro_outgoing_workgroup	cenro_outgoing_section	cenro_outgoing_action	cenro_outgoing_dateprocessed	cenro_outgoing_time	records_outgoing_recvdate	records_outgoing_recvtime	records_outgoing_processor	records_outgoing_workgroup 1	records_outgoing_section	records_outgoing_action	records_outgoing_dateprocessed	records_outgoing_time	section_reroute_recvdate	section_reroute_recvtime	section_reroute_processor	section_reroute_workgroup	section_reroute_section	section_reroute_remarks	section_reroute_dateprocessed	section_reroute_time	section_reroute_receiver	focal_reroute_recvdate	focal_reroute_recvtime	focal_reroute_processor	focal_reroute_workgroup	focal_reroute_section	focal_reroute_remarks	focal_reroute_dateprocessed	focal_reroute_time	focal_reroute_receiver
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 256	256	CP-2025-00131	JANELY MESIAS	RECORDS	RECORDS	SHIRLEY P. RAAGAN	JOSE RIZAL ST., SAWANG CARIGARA	04:58 PM	REQUEST FOR A&D CERTIFICATION OF LOT NO. 10608, BR...	WALK IN	A&D CERTIFICATION	FORWARDED FROM RECORDS	SHIRLEY P. RAAGAN	2025-04-23	04:58 PM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 768	768	CP-2025-00642	JANELY MESIAS	RECORDS	RECORDS	DR. LORETA YU-RAMA	62-B, KALIPAYAN SAGKAHAN TACLOBAN CITY	2025-05-30	REQUEST FOR LAND CLASSIFICATION STATUS OF LOT NO. ...	WALK IN	A&D CERTIFICATION	FORWARDED FROM RECORDS	DR. LORETA YU-RAMA	2025-05-30	11:06 AM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 1280	1280	CP-2025-01152	JANELY MESIAS	RECORDS	RECORDS	EDGAR B. TABACON, CESO IV	DPWH RO8, BRGY. BARAS PALO, LEYTE	2025-07-07	REQUEST FOR TREE CUTTING PERMIT FOR THE PROJECT CI...	WALK IN	PERMITS	FORWARDED FROM RECORDS	EDGAR B. TABACON, CESO IV	2025-07-07	02:42 PM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 769	769	CP-2025-00643	JANELY MESIAS	RECORDS	RECORDS	ALWINO R. DAGA	BRGY. TIBAK SANTA FE, LEYTE	2025-05-30	REQUEST FOR LAND CLASSIFICATION STATUS OF LOT NO. ...	WALK IN	A&D CERTIFICATION	FORWARDED FROM RECORDS	ALWINO R. DAGA	2025-05-30	11:22 AM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 1281	1281	CP-2025-01153	JANELY MESIAS	RECORDS	RECORDS	EDGAR B. TABACON, CESO IV	DPWH RO8, BRGY. BARAS PALO, LEYTE	2025-07-07	REQUEST FOR TREE CUTTING PERMIT FOR THE PROJECT CI...	WALK IN	PERMITS	FORWARDED FROM RECORDS	EDGAR B. TABACON, CESO IV	2025-07-07	02:44 PM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 1282	1282	CP-2025-01154	JANELY MESIAS	RECORDS	RECORDS	EDGAR B. TABACON, CESO IV	DPWH RO8, BRGY. BARAS PALO, LEYTE	2025-07-07	REQUEST FOR TREE CUTTING PERMIT FOR THE PROJECT CI...	WALK IN	PERMITS	FORWARDED FROM RECORDS	EDGAR B. TABACON, CESO IV	2025-07-07	02:46 PM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 515	515	CP-2025-00389	JANELY MESIAS	RECORDS	RECORDS	ARTURO P. MARGALLO	261 E MONGE ST. CAVITE WEST PALO, LEYTE	2025-05-14	REQUEST FOR A&D CERTIFICATION OF LOT NO. 878, BRGY...	WALK IN	A&D CERTIFICATION	FORWARDED FROM RECORDS	ARTURO P. MARGALLO	2025-05-14	11:34 AM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 771	771	CP-2025-00645	JANELY MESIAS	RECORDS	RECORDS	EMELITA ISIO	BRGY. BULOD DULAG, LEYTE	2025-05-30	REQUEST FOR LOT STATUS CERTIFICATION OF LOT NO. 87...	WALK IN	CERTIFICATION	FORWARDED FROM RECORDS	EMELITA ISIO	2025-05-30	11:38 AM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 1283	1283	CP-2025-01155	JANELY MESIAS	RECORDS	RECORDS	RENE GERARD B. GOZUM	GMA NET. CENTER, EDSA COR. TIMOG AVE., DILIMAN, QU...	2025-07-07	THIS IS TO ACKNOWLEDGE RECEIPT LETTER DATED MAY 14...	MAIL	LETTER	FORWARDED FROM RECORDS	RENE GERARD B. GOZUM	2025-07-07	02:51 PM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 516	516	CP-2025-00390	JANELY MESIAS	RECORDS	RECORDS	MARLON L. CONTAPAY	BRGY. CANDAHUG PALO, LEYTE	2025-05-14	REQUEST FOR LOT STATUS CERTIFICATION OF LOT NO. 13...	WALK IN	CERTIFICATION	FORWARDED FROM RECORDS	CENRO - PALO	2025-05-14	11:38 AM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 772	772	CP-2025-00646	JANELY MESIAS	RECORDS	RECORDS	JULITA A. SABELA	BRGY. SAN ISIDRO SANTA FE, LEYTE	2025-05-30	REQUEST FOR CERTIFIED TRUE COPY OF SUPPORTING DOCU...	WALK IN	CERTIFIED TRUE COPY OF DO	FORWARDED FROM RECORDS	JULITA A. SABELA	2025-05-30	11:40 AM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 1284	1284	CP-2025-01156	JANELY MESIAS	RECORDS	RECORDS	ATTY. ULPIANO U. ARPON, J	JOSON DE MATA ST., BRGY. BAYBAY CARIGARA, LEYTE	2025-07-07	IN RE: IN THE MATTER OF CANCELLATION OF FREE PATEN...	WALK IN	PROTEST	FORWARDED FROM RECORDS	ATTY. ULPIANO U. ARPON, J	2025-07-07	03:05 PM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 517	517	CP-2025-00391	JANELY MESIAS	RECORDS	RECORDS	JENNY G. OLMO	BRGY. SAN JUAN SANTA FE, LEYTE	2025-05-14	REQUEST FOR CERTIFIED TRUE COPY OF SUPPORTING DOCU...	WALK IN	CERTIFIED TRUE COPY OF DO	FORWARDED FROM RECORDS	JENNY G. OLMO	2025-05-14	11:41 AM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 773	773	CP-2025-00647	JANELY MESIAS	RECORDS	RECORDS	JULITA A. SABELA	BRGY. SAN ISIDRO SANTA FE, LEYTE	2025-05-30	REQUEST FOR LAND CLASSIFICATION STATUS OF LOT NO. ...	WALK IN	A&D CERTIFICATION	FORWARDED FROM RECORDS	JULITA A. SABELA	2025-05-30	11:40 AM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 1285	1285	CP-2025-01157	JANELY MESIAS	RECORDS	RECORDS	ATTY. GERONIMO Q. PUQUE	BRGY. SAGKAHAN CARIGARA, LEYTE	2025-07-07	LETTER PROTEST BY ANECITO M. VIOJELA COVERING OF L...	WALK IN	PROTEST	FORWARDED FROM RECORDS	ATTY. GERONIMO Q. PUQUE	2025-07-07	04:05 PM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 518	518	CP-2025-00392	JANELY MESIAS	RECORDS	RECORDS	ENGR. MA. DIOLETA C. VILL	BRGY. 2 TACLOBAN CITY	2025-05-14	REQUEST FOR A&D CERTIFICATION OF LOT NO. PSU-11808...	WALK IN	A&D CERTIFICATION	FORWARDED FROM RECORDS	DENR RO8	2025-05-14	11:49 AM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 774	774	CP-2025-00648	JANELY MESIAS	RECORDS	RECORDS	NELSON C. LABOGA	BRGY. CANAP SAN MIGUEL, LEYTE	2025-05-30	REQUEST FOR PERMIT TO TRANSPORT OF KILIKILI LUMBER...	WALK IN	PERMITS	FORWARDED FROM RECORDS	NELSON C. LABOGA	2025-05-30	11:51 AM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 519	519	CP-2025-00393	JANELY MESIAS	RECORDS	RECORDS	ARTURO P. MARGALLO	261 E MONGE ST. CAVITE WEST PALO, LEYTE	2025-05-14	REQUEST FOR A&D CERTIFICATION OF LOT NO. 878, BRGY...	WALK IN	CERTIFIED TRUE COPY OF DO	FORWARDED FROM RECORDS	ARTURO P. MARGALLO	2025-05-14	11:53 AM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 1287	1287	CP-2025-01159	JANELY MESIAS	RECORDS	RECORDS	MA. LISLEY CABALLERO	#038 BITO REAL ST., BRGY. BITO ABUYOG LEYTE	2025-07-08	REQUEST FOR LOT STATUS CERTIFICATION OF LOT NO. ...	WALK IN	CERTIFICATION	FORWARDED FROM RECORDS	MA. LISLEY CABALLERO	2025-07-08	11:01 AM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 776	776	CP-2025-00650	JANELY MESIAS	RECORDS	RECORDS	ENGR. WINSTON N. SOLITE	BRGY. BARAS PALO, LEYTE	2025-05-30	MEMO: THREE (3) PUBLIC LAND APPLICATION FOR COMPLI...	WALK IN	MEMORANDUM	FORWARDED FROM RECORDS	PENRO - LEYTE	2025-05-30	12:03 PM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 1288	1288	CP-2025-01160	JANELY MESIAS	RECORDS	RECORDS	JULITO LUCAÑAS	BRGY. SAGKAHAN CARIGARA, LEYTE	2025-07-08	REQUEST FOR LOT STATUS CERTIFICATION OF LOT NO. ...	WALK IN	CERTIFICATION	FORWARDED FROM RECORDS	JULITO LUCAÑAS	2025-07-08	12:52 PM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 777	777	CP-2025-00651	JANELY MESIAS	RECORDS	RECORDS	ROSALITA G. BERNALES	BRGY. DISTRICT IV PASTRANA, LEYTE	2025-05-30	REQUEST FOR TREE CUTTING PERMIT OF ONE (1) TUGOP T...	WALK IN	PERMITS	FORWARDED FROM RECORDS	ROSALITA G. BERNALES	2025-05-30	12:08 PM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 778	778	CP-2025-00652	JANELY MESIAS	RECORDS	RECORDS	ROSITA N. PARENA	CAPOOCAN LEYTE	2025-06-02	REQUEST FOR CERTIFIED TRUE COPY OF SUPPORTING DOCU...	WALK IN	A&D CERTIFICATION	FORWARDED FROM RECORDS	ROSITA N. PARENA	2025-06-02	02:42 PM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 267	267	CP-2025-00141	JANELY MESIAS	RECORDS	RECORDS	ADELINA P. MAASIN	BRGY. MABINI MAYORGA, LEYTE	10:32 AM	REQUEST FOR A&D CERTIFICATION OF LOT NO. 2893, BRG...	WALK IN	A&D CERTIFICATION	FORWARDED FROM RECORDS	ADELINA P. MAASIN	2025-04-24	10:32 AM
Edit	Copy	Delete DELETE FROM cenro_recv_incoming WHERE `cenro_recv_incoming`.`id` = 779	779	CP-2025-00653	JANELY MESIAS	RECORDS	RECORDS	LYDIA CANEJA	BRGY. BARUGOHAY SUR, CARIGARA, LEYTE	2025-06-02	REQUEST FOR CERTIFIED TRUE COPY OF A&D CERTIFICATI...	WALK IN	CERTIFIED TRUE COPY OF DO	FORWARDED FROM RECORDS	LYDIA CANEJA	2025-06-02	02:43 PM

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view