competence-rs.com / localhost / hmis / categories

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: localhost »

Database: hmis »

Table: categories

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 (608 total, Query took 0.0678 seconds.)

SELECT * FROM `categories`

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

Filter rows:

			id	cat_code	cat_group	level	module_desc	module_seq	module_id	page_id	page_code	page_desc	page_seq	page_url	created_date	modified_date	modified_by	locationname
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 1	1	HPATREG	1	Patient Registration	Registration	5	1	1	FPATREG	Medical Registration	1	registrations/index	2011-05-26 15:18:15	2011-06-21 00:00:00	000006	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 2	2	HPATREG	2	Patient Registration	Registration	5	1	2	FPATOP	Patient Appointment	2	outpatients/index	2011-05-26 15:18:15	0000-00-00 00:00:00	0	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 3	3	HPATREG	3	Patient Registration	Registration	5	1	3	FOPSERV	OP Service Order	3	opservices/index	2011-05-26 15:18:15	0000-00-00 00:00:00	0	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 4	4	HRENQRY	4	Reception Enquiry	Registration	5	1	4	FCURINPT	Current In-Patient	4	ipadmissions/currentinpatient	2011-05-26 15:18:15	0000-00-00 00:00:00	0	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 6	6	HRENQRY	6	Reception Enquiry	Registration	5	1	5	FPTDETL	Patient Details	6	patientdetails/index	2011-05-26 15:31:01	2011-12-12 00:00:00	000027	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 7	7	HOPDDT	7	OPD	Out-Patient Department	10	2	7	FOPDF	Out-Patient Department	1	opds/index	2011-05-26 15:40:18	0000-00-00 00:00:00	0	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 8	8	HOPDDT	8	OPD	Out-Patient Department	10	2	8	FEMR	EMR	2	emrs/index	2011-05-26 15:40:19	0000-00-00 00:00:00	0	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 9	9	HOPDDT	9	OPD	Out-Patient Department	10	2	9	FPTRNSFR	OP Patient Transfer	3	patienttransfers/index	2011-05-26 15:40:19	0000-00-00 00:00:00	0	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 13	13	HMCNBK	13	Booking	Diagnostic and OT Booking	12	13	13	FMCHNBK	Booking Form	1	otbooks/index	2011-05-27 15:26:19	2011-07-05 00:00:00	000006	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 14	14	HMCNBK	14	Booking	Diagnostic and OT Booking	12	13	14	FCANCLTN	Cancellation	2	cancellations/index	2011-05-27 15:26:19	2011-07-05 00:00:00	000006	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 15	15	HDRGISUE	15	Patient Drug Issue	Pharmacy	15	3	15	FDRGISU	OP Drug Issue	1	drugissues/index	2011-05-27 15:36:45	2011-07-05 00:00:00	000006	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 16	16	HSTRINV	16	Store Related	Pharmacy	15	3	163	FINDENT	Indent	1	indents/index	2011-05-27 15:36:45	2012-06-01 00:00:00	000127	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 17	17	HSTRINV	17	Store Related	Pharmacy	15	3	18	FISUACPT	Issue Acceptance	3	acceptissues/index	2011-05-27 15:36:45	2012-06-01 00:00:00	000127	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 18	18	HLBTEST	18	Lab Test	Laboratory	20	4	19	FOPIPSERV	OP/IP Service Order	1	opservices/index	2011-05-27 16:09:38	0000-00-00 00:00:00	0	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 19	19	HLBTEST	19	Lab Test	Laboratory	20	4	20	FOPIPSMPL	OP/IP Sample Collection	2	samplecollections/index	2011-05-27 16:09:38	0000-00-00 00:00:00	0	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 20	20	HLBTEST	20	Lab Test	Laboratory	20	4	21	FRSLTENTR	Result Entry Tray Wise	3	resulttryentries/index	2011-05-27 16:09:38	2011-07-05 00:00:00	000006	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 21	21	HLBTEST	21	Lab Test	Laboratory	20	4	22	FMICRSLT	Microbiology Result Entry	4	microbrentries/index	2011-05-27 16:09:38	0000-00-00 00:00:00	0	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 22	22	HLBTEST	22	Lab Test	Laboratory	20	4	23	FTSTREVSL	Test Reversal	5	testreversals/index	2011-05-27 16:09:38	0000-00-00 00:00:00	0	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 24	24	HLBENQ	23	Lab Enquiry	Laboratory	20	0	130	FLABREP	Lab Reports	6	labreports/index	2011-05-27 16:16:39	2011-12-24 00:00:00	000127	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 25	25	HRADTRAN	24	Transaction	Radiology & Nuclear Medicine	25	5	3	FOPSERV	OP Service Order	1	opservices/index	2011-05-27 16:38:42	0000-00-00 00:00:00	0	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 26	26	HRADTRAN	25	Transaction	Radiology & Nuclear Medicine	25	5	25	FTSTSCHDL	Test Scheduling	2	radiologytests/index	2011-05-27 16:38:42	0000-00-00 00:00:00	0	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 27	27	HRADTRAN	26	Transaction	Radiology & Nuclear Medicine	25	5	23	FTSTREVSL	Test Reversal	3	testreversals/index	2011-05-27 16:38:42	0000-00-00 00:00:00	0	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 29	29	HSTKDTL	28	Stock Detail	Radiology & Nuclear Medicine	25	5	16	FINDENT	Indent	1	indents/index	2011-05-27 16:38:42	0000-00-00 00:00:00	0	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 30	30	HSTKDTL	29	Stock Detail	Radiology & Nuclear Medicine	25	5	18	FISUACPT	Issue Acceptance	2	acceptissues/index	2011-05-27 16:38:42	0000-00-00 00:00:00	0	NULL
Edit	Copy	Delete DELETE FROM `categories` WHERE `categories`.`id` = 31	31	HIPPTRLTD	30	Patient Related	In-Patient Management	35	7	27	FIPADMS	IP Admission	1	ipadmissions/index	2011-05-27 18:01:04	2011-10-10 00:00:00	000027	NULL

Check all With selected:

Filter rows:

Query results operations

Print view

Export

Display chart

Create view