reportes.kaligarirefrigeracion.com / 127.0.0.1 / kalidb / ot

Recent`performance_schema`.`cond_instances`
`mysql`.`time_zone_name`
`kalidb_bk`.`tecnicos`
`kalidb`.`sec_apps`
`phpmyadmin`.`pma_table_uiprefs`
`performance_schema`.`setup_consumers`
`kalidb`.`inventario`
`mysql`.`help_keyword`
`performance_schema`.`table_lock_waits_summary_by_table`
`performance_schema`.`events_statements_current`
FavoritesThere are no favorite tables.
New
cm9vdA==.Y2Rjb2w=cm9vdA==.Y2Rjb2w=0
cdcol
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1hcm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h0
information_schema
cm9vdA==cm9vdA==.a2FsaWRi0
 kalidb
cm9vdA==.a2FsaWRicm9vdA==.a2FsaWRi.0
kalidb
cm9vdA==.a2FsaWRiX2Jrcm9vdA==.a2FsaWRi.Yms=0
kalidb_bk
cm9vdA==.bXlzcWw=cm9vdA==.bXlzcWw=0
mysql
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1hcm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h0
performance_schema
cm9vdA==.cGhwbXlhZG1pbg==cm9vdA==.cGhwbXlhZG1pbg==0
phpmyadmin
cm9vdA==.dGVzdA==cm9vdA==.dGVzdA==0
test
cm9vdA==.d2ViYXV0aA==cm9vdA==.d2ViYXV0aA==0
webauth

Navigation panel
Navigation tree
Databases
Tables

Navigation panel

Customize appearance of the 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 tree

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

Databases

Databases display options.

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

Tables

Tables display options.

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-

Server: 127.0.0.1 »

Database: kalidb »

Table: ot

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

Browse mode

Customize 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 (161879 total, Query took 0.0000 seconds.) [idReporte: 162025... - 162001...]

SELECT * FROM `ot` ORDER BY `idReporte`  DESC

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

Filter rows:

			idReporte 1	OT	FechaSolicitud	FechaEjecucion	Cliente	PuntodeVenta	Servicio Tipo de servicio que requiere el cliente	NumeroReporte	Activo	Falla	TrabajoRealizado	Tecnico	HoraInicio	HoraFinal	FechaFacturado	Recibe	Garantia	ReporteGarantia	CreatedDate
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162025	162025	321151	2026-04-29	2026-04-29	2	17	Correctivo	131719	560	EMPAQUE	REPORTE 131719 TK 321151 EQUIPO 1000402-48 CG T2...	11	08:40:00	09:45:00	NULL	CLAUDIA	0	7725	2026-05-21 16:49:51
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162024	162024		2026-04-30	2026-04-30	145	1774	Correctivo	131951	11189	FABRICACIÓN	REPORTE: 131951 EQUIPO: CG K-27 PDV I57 FRISBY S...	11	08:00:00	22:00:00	NULL	JAQUELINE DE LEON	0	7725	2026-05-19 21:42:53
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162023	162023		2026-05-11	2026-05-11	2	4	Preventivo	131270	5560	BENEFICIO MTO PREVENTIVO	REPORTE 131270 TK BENEFICIO MTTO EQUIPO 5 EQUIPO...	291	08:00:00	12:30:00	NULL	FIRM ANO LEGIBLE	0	7725	2026-05-19 19:15:38
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162022	162022	600059166	2026-04-28	2026-04-28	192	2428	Correctivo	1041895A	13184	RETIRO MANIJA	REPORTE: 1041895A SOLPED: 600059166 EQUIPO: CA00...	25	16:30:00	17:15:00	NULL	DEIVER CARMONA RUIZ	0	7725	2026-05-19 15:44:24
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162021	162021	600059166	2026-04-24	2026-04-24	192	2428	Correctivo	1042002A	13185	MANTENIMIENTO	REPORTE: 1042002A SOLPED: 600059166 EQUIPO: CA01...	297	16:30:00	17:10:00	NULL	DEIVER CARMONA RUIZ	0	7725	2026-05-19 15:39:56
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162020	162020	600060141	2026-04-24	2026-04-24	192	2431	Correctivo	1042001A	13188	MANTENIMIENTO PREVENTIVO	REPORTE: 1042001A SOLPED: 600060141 EQUIPO: CA00...	297	15:30:00	16:10:00	NULL	FIRMA ILEGIBLE	0	7725	2026-05-19 15:32:15
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162019	162019	600060051	2026-04-23	2026-04-23	192	2430	Correctivo	1041950A	13187	CAMBIO MANIJA	REPORTE: 1041950A SOLPED: 600060051 EQUIPO: CA0182...	297	14:40:00	16:00:00	NULL	FIRMA NO LEGIBLE	0	7725	2026-05-19 15:25:38
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162018	162018	600059293	2026-04-17	2026-04-17	192	2429	Correctivo	1041867A	13186	RETIRO MANIJA ESQUINERO MAGENTA	REPORTE: 1041867A SOLPED: 600059293 EQUIPO: CA00...	25	14:15:00	16:45:00	NULL	FIRMA NO LEGIBLE	0	7725	2026-05-19 15:18:04
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162017	162017	600059293	2026-04-15	2026-04-15	192	2429	Correctivo	1041858A	13186	EQUIPO BAJO PARAMETROS	REPORTE: 1041858A SOLPED: 600059293 EQUIPO: CA00...	25	13:20:00	14:00:00	NULL	FIRMA NO LEGIBLE	0	7725	2026-05-19 15:10:43
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162016	162016	600059293	2026-04-14	2026-04-14	192	2429	Correctivo	1041906A	13186	CONDESADOR SUCIO	REPORTE: 1041906A SOLPED: 600059293 EQUIPO: CA00...	297	11:30:00	13:20:00	NULL	MAURICIO	0	7725	2026-05-16 19:54:23
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162015	162015	600059166	2026-04-04	2026-04-04	192	2428	Correctivo	1041799A	13184	SE RETIRA MANIJA CUADRO MAJENTE	REPORTE: 1041799A SOLPED:600059166 EQUIPO:CA0072...	25	08:30:00	09:20:00	NULL	BEATRIZ TOBON	0	7725	2026-05-16 19:39:45
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162014	162014	320396	2026-04-30	2026-04-30	2	823	Correctivo	131807	5171	REVISION	REPORTE 131807 TK 320396 EQUIPO 1033760-51 CG FO...	266	14:20:00	15:14:00	NULL	JULIO MOCOY	0	7725	2026-05-15 22:11:20
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162013	162013	RF BEVERAGE 27	2026-04-23	2026-04-23	192	2263	Correctivo	131617	12611	MANGERA DE DESAGUE	REPORTE 131617 TK 600059835 EQUIPO RF BEVERAGE 2...	281	16:00:00	18:20:00	NULL	ISAAC NICO	0	7725	2026-05-13 22:44:03
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162012	162012	600059835	2026-04-23	2026-04-23	192	2263	Correctivo	131706	12611	BANDEJA DESAGUE	REPORTE 131706 TK 600059835 EQUIPO RF 27 BEVERAG...	11	14:25:00	15:32:00	NULL	CAMILA V	0	7725	2026-05-13 22:40:52
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162011	162011	600059760	2026-04-23	2026-04-23	192	2383	Correctivo	131616	13023	TUBO LED	REPORTE 131616 TK 600059760 EQUIPO CG INDUCO 16 ...	281	14:30:00	14:59:00	NULL	WILFREDO	0	7725	2026-05-13 22:14:16
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162010	162010	600059763	2026-04-23	2026-04-23	192	2386	Correctivo	131614	13026	ILUJMINACIÓN	REPORTE 131614 TK 600059763 EQUIPO CG INDUCOL 16 H...	281	13:26:00	13:40:00	NULL	FIRMA NO LEIBLE	0	7725	2026-05-13 22:05:03
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162009	162009	600059755	2026-04-22	2026-04-22	192	2385	Correctivo	131613	13025	ILMINACION	REPORTE 131613 SOLPED 600059755 EQUIPO CG INDUCOL...	281	19:40:00	20:17:00	NULL	RIVERA	0	7725	2026-05-13 21:50:04
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162008	162008		2026-04-30	2026-04-30	88	1383	Correctivo	131773	8225	REVISION	REPORTE: 131773 EQUIPO: CTO FRIO CG TRABAJO ...	303	17:01:00	19:00:00	NULL	JOSE RODRIGUEZ	0	7725	2026-05-13 18:08:53
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162007	162007		2026-04-28	2026-04-28	2	1124	Correctivo	131718	6645	EMPAQUE	REPORTE: 131718 EQUIPO: 000624 RF K-DES 2PTA ...	11	14:52:00	15:33:00	NULL	JAMY P.	0	7725	2026-05-13 17:48:08
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162006	162006		2026-04-28	2026-04-28	2	769	Correctivo	131636	10962	REVISION	REPORTE: 131636 EQUIPO: RF K-DES 2PTA FQ50-1085 ...	281	19:25:00	20:25:00	NULL	FIRMA NO LEGIBLE	0	7725	2026-05-13 17:43:29
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162005	162005		2026-04-13	2026-04-13	145	1774	Correctivo	130124	12371	FABRICACION	REPORTE 130124 EQUIPO CG K49 PDV C.C. GUATAPURI ...	11	08:00:00	22:00:00	NULL	LAURA TORO	0	7725	2026-05-12 22:02:45
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162004	162004	315559	2026-04-27	2026-04-27	145	1911	Correctivo	130129	11195	CALIBRACIÓN Y PARAMETRIZACIÓN	REPORTE 130129 TK 315559 EQUIPO 1069675-23 CG K2...	11	08:00:00	22:00:00	NULL	FIRMA NO LEGIBLE	1	7725	2026-05-12 21:59:15
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162003	162003	318874	2026-04-25	2026-04-25	145	1911	Correctivo	130128	11195	PUESTA A PUNTO	REPORTE 130128 TK 318874 EQUIPO CG K23 MEDIDAS E...	11	08:00:00	22:00:00	NULL	PAULA ANDREA	0	7725	2026-05-12 21:54:03
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162002	162002		2026-04-22	2026-04-22	88	1398	Preventivo	131702	8309	MTO	REPORTE: 131702 EQUIPO: 1EQ TRABAJOS REALIZADO...	303	14:55:00	15:44:00	NULL	JULIO ORTIZ	0	7725	2026-05-12 18:02:51
Edit	Copy	Delete DELETE FROM `ot` WHERE `ot`.`idReporte` = 162001	162001		2026-04-22	2026-04-22	88	1383	Preventivo	131682	8366	MTO	REPORTE: 131682 EQUIPO: 5EQ TRABAJOS REALIZAD...	266	07:00:00	10:30:00	NULL	DIEGO CANATE	0	7725	2026-05-12 18:00:09

Check all With selected:

Filter rows:

Query results operations

Print view

Export

Display chart

Create view