digi-gov.com / 127.0.0.1 / qpsii_systemlogs / ecao_faas_land_value_adj

There are no favorite tables.

New
accounting
bac_lgu
budget
cenro
dbfederation
db_meter_readings
documenttracker
el_laravue
general
humanresource
information_schema
lgis
- lgis_app
- lgis_dum_app
lgu_repository
mysql
online_hr
performance
- performance_management
- performance_schema
qpsii
queue
repository
service_request_db

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 :

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 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

Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

Showing rows 0 - 24 (1633 total, Query took 0.0004 seconds.)

SELECT * FROM `ecao_faas_land_value_adj`

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

Filter rows:

dtl_id	faas_id	PKGUID	PKTransID	market_value	adjustment_factor	area	perc_adjustment	value_adjustment	adj_marketvalue	adj_type	isupdated	cur_userid	cur_date	cur_uiid
17270	327629	35CEEE7B57B540DA8D0FE2A405AE6BAE	2320201129120019	503200.00	CORNER INFLUENCE	0	10	50320.00	NULL	Add	0	68	2024-09-07 14:34:31	3a1dd43c-6ce3-11ef-8244-000c297f8656
17275	327629	35CEEE7B57B540DA8D0FE2A405AE6BAE	2320201129120019	299970.00	CORNER INFLUENCE	0	10	29997.00	NULL	Add	0	68	2024-09-07 14:37:37	a88628bc-6ce3-11ef-8244-000c297f8656
17318	334943	3E5A56A27F524EA396C99148295A2453	2320210817103250	173853.22	NO ROAD OUTLET	0	9	15646.79	NULL	Sub	0	68	2024-09-09 08:20:47	5937c32b-6e41-11ef-8244-000c297f8656
17342	334927	87D21E8E1BF84D21970525C5F7DC61B0	2320210817101924	66438.85	NO ROAD OUTLET	0	9	5979.50	NULL	Sub	0	68	2024-09-09 10:03:56	c1ae7354-6e4f-11ef-8244-000c297f8656
17343	334920	B00E806B4A8043F5B2C7462E4089ACCB	232021081795722	91053.65	NO ROAD OUTLET	0	9	8194.83	NULL	Sub	0	68	2024-09-09 10:05:19	f336fa7a-6e4f-11ef-8244-000c297f8656
17344	334917	83D8D57857F14E82B6C72B099D486295	232021081795608	97651.33	NO ROAD OUTLET	0	9	8788.62	NULL	Sub	0	68	2024-09-09 10:05:57	0a253cef-6e50-11ef-8244-000c297f8656
17345	334911	393A1E4348C341499AAAF725A3F0E652	232021081795543	33919.40	NO ROAD OUTLET	0	10	3391.94	NULL	Sub	0	68	2024-09-09 10:06:34	201842c8-6e50-11ef-8244-000c297f8656
17346	334909	751A114D917D462284BBAFC37AB03519	232021081795402	66691.55	NO ROAD OUTLET	0	9	6002.24	NULL	Sub	0	68	2024-09-09 10:07:11	36268d47-6e50-11ef-8244-000c297f8656
17347	334901	B41F7F48C101447CBB410D29D30CFD8A	232021081794603	59282.08	NO ROAD OUTLET	0	10	5928.21	NULL	Sub	0	68	2024-09-09 10:07:52	4e687355-6e50-11ef-8244-000c297f8656
17348	334900	076F3BC6F4134B50AFA4AB2344A49795	232021081794532	33246.71	NO ROAD OUTLET	0	10	3324.67	NULL	Sub	0	68	2024-09-09 10:08:21	5fc22d85-6e50-11ef-8244-000c297f8656
17349	334928	0D8B4456D5864814B1CBF94CBF9479DF	2320210817102020	83608.95	NO ROAD OUTLET	0	9	7524.81	NULL	Sub	0	68	2024-09-09 10:09:36	8c5780ef-6e50-11ef-8244-000c297f8656
17350	334930	C4BBC909D3E1435BBB265AE1F3F75FA0	2320210817102114	81024.56	NO ROAD OUTLET	0	9	7292.21	NULL	Sub	0	68	2024-09-09 10:11:06	c23986ea-6e50-11ef-8244-000c297f8656
17352	334937	79DB7E1E955C4E97B80D542EECB8130E	1202208091346576234	213554.40	NO ROAD OUTLET	0	9	19219.90	NULL	Sub	0	68	2024-09-09 10:14:11	30674a3b-6e51-11ef-8244-000c297f8656
17353	334947	202598EEC0D44A8A8DF64FFDE90204B4	2320210817104115	25531.67	NO ROAD OUTLET	0	9	2297.85	NULL	Sub	0	68	2024-09-09 10:20:05	03334b1c-6e52-11ef-8244-000c297f8656
17356	334966	B37DC678D36C4EF9BC7660BC31D90242	2320210817142606	94015.26	NO ROAD OUTLET	0	9	8461.37	NULL	Sub	0	68	2024-09-09 10:27:45	15b1db46-6e53-11ef-8244-000c297f8656
17376	335147	05C6567052E44BDDBA1E140CD5A8796F	2320210817144420	73564.08	NO ROAD OUTLET	0	9	6620.77	NULL	Sub	0	68	2024-09-09 14:05:07	737ed965-6e71-11ef-8244-000c297f8656
17393	335236	CBED2641431C403EA3CF8895B4C58D25	2320210817155135	59319.18	NO ROAD OUTLET	0	9	5338.73	NULL	Sub	0	68	2024-09-09 16:06:37	6ba0e02e-6e82-11ef-8244-000c297f8656
17414	335297	F32528425654493BA28334FFDA19E5D9	232021081884037	178081.05	NO ROAD OUTLET	0	9	16027.29	NULL	Sub	0	68	2024-09-10 09:28:30	f8639810-6f13-11ef-8244-000c297f8656
17423	93643	410BD8E94193445E8DF14404A3155EAE	232021081884537	33037.11	NO ROAD OUTLET	0	10	3303.71	NULL	Sub	0	68	2024-09-10 09:37:46	440f4b51-6f15-11ef-8244-000c297f8656
17424	93642	8E13AE6C1289489583384741B2F3DC22	232021081884500	33399.45	NO ROAD OUTLET	0	9	3005.95	NULL	Sub	0	68	2024-09-10 09:38:28	5ccca76c-6f15-11ef-8244-000c297f8656
17426	93641	369851EDF4D54205B4BCC7F8A8105B57	232021081884230	33399.45	NO ROAD OUTLET	0	9	3005.95	NULL	Sub	0	68	2024-09-10 09:39:08	74a2de06-6f15-11ef-8244-000c297f8656
17435	335352	947B47F866954480B858221563F4A319	2320210605104859	8143.51	NO ROAD OUTLET	0	10	814.35	NULL	Sub	0	76	2024-09-10 10:00:22	6bc79796-6f18-11ef-8244-000c297f8656
17445	93731	8C3B5C416B95493FAC75AA93D51C2F27	232021081885107	593483.70	ROAD OUTLET	0	9	53413.53	NULL	Sub	0	68	2024-09-10 10:42:24	4b7d11c6-6f1e-11ef-8244-000c297f8656
17451	335413	8443F7164BAF4B70AEDE88F8C1B580D4	2320210605110602	7426.96	NO ROAD OUTLET	0	10	742.70	NULL	Sub	0	76	2024-09-10 11:01:36	f9a0f11d-6f20-11ef-8244-000c297f8656
17451	335413	8443F7164BAF4B70AEDE88F8C1B580D4	2320210605110602	7426.96	NO ROAD OUTLET	0	10	742.70	NULL	Sub	0	76	2024-09-10 11:02:08	0cf67a1d-6f21-11ef-8244-000c297f8656

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)

Connection for controluser as defined in your configuration failed.