app-ho.tailad8925.ts.net / 127.0.0.1 / incidencereport / transtablejournal

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.

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.

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.

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

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

Press Ctrl+Enter to execute query

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

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

			upload_id	upload_date	Narration	CustomerName	Credit_Amount	Debit_Amount	Debit_AccountNumber	Credit_AccountNumber	Company	Status	Upload_By	Upload_Month	upload_day	UploadYear	upload_time	Authoriser	Transid	Paid_By	Paid_Month	Paid_Year	Paid_Day	Paid_Date	Paid_Contact1	Paid_Contact2	Paid_Time 1	Approval_Time	idtype	idnumber	BankBranch
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 256	256	20191130	Salary Withdrawal For Nov 2019	SANDRA ANEEFI	NULL	385.30	CA65221130	CA6522	BlueSkies	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT201911197211	BRIGHT AFFUL	NULL	NULL	NULL	20191119	0555764885	NULL	NULL	NULL	NHIS	46844199	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 512	512	20191130	Salary Withdrawal For Nov 2019	MAVISON AFIA KONADU	NULL	333.70	CA79361130	CA7936	BlueSkies	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT201912108735	BARBARA ASAMOAH	NULL	NULL	NULL	20191210	0246637089	NULL	NULL	NULL	NHIS	20226856	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 768	768	20191231	Salary Withdrawal For Dec 2019	PATIENCE LAMPTEY	NULL	279.81	CA46671230	CA4667	BlueSkies	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT201912188813	BARBARA ASAMOAH	NULL	NULL	NULL	20191218		NULL	NULL	NULL	NIA	G1615310	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 1024	1024	20191220	Salary Withdrawal For Dec 2019	LINDA	NULL	499.85	DP21151230	DP2115	Bomart	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT202001021239	BRIGHT AFFUL	NULL	NULL	NULL	20200102	0558556429	NULL	NULL	NULL	VOTER ID	5885000975	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 1280	1280	20200131	Salary Withdrawal For Jan 2020	GLORIA ABORDO	NULL	764.31	CA80642001	CA8064	BlueSkies	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT202001174765	BARBARA ASAMOAH	NULL	NULL	NULL	20200117	0550201042	NULL	NULL	NULL	NHIS	384379512001	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 1536	1536	20200131	Salary Withdrawal For Jan 2020	KATE ABOAGYEWAA	NULL	587.90	CA20642001	CA2064	BlueSkies	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT202001204994	BARBARA ASAMOAH	NULL	NULL	NULL	20200120	0248136836	NULL	NULL	NULL	NHIS	8394102	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 1792	1792	20200130	Salary Withdrawal For Jan 2020	SULOH MARTHA	NULL	131.81	DP28460120	DP2846	Bomart	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT202002037615	BRIGHT AFFUL	NULL	NULL	NULL	20200203	0547227559	NULL	NULL	NULL	VOTER ID	1804312781	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 1	1	20191130	Salary Withdrawal For Jan 1970	PHILIP OFORI	NULL	484.66	CA51911130	CA5191	BlueSkies	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT201911157574	BRIGHT AFFUL	NULL	NULL	NULL	20191115	0242724785	NULL	NULL	NULL	NIA	71255178-2	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 257	257	20191130	Salary Withdrawal For Nov 2019	JAMILATU ABDULAI	NULL	410.69	CA78481130	CA7848	BlueSkies	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT201911197833	BRIGHT AFFUL	NULL	NULL	NULL	20191119	0548291284	NULL	NULL	NULL	VOTER ID	5407006773	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 513	513	20191130	Salary Withdrawal For Nov 2019	COMFORT AGYARE	NULL	138.45	CA86641130	CA8664	BlueSkies	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT201912108805	BARBARA ASAMOAH	NULL	NULL	NULL	20191210	0247187482	NULL	NULL	NULL	VOTER ID	1479901249	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 769	769	20191231	Salary Withdrawal For Dec 2019	GLADYS BERCHIE	NULL	798.47	CA04121230	CA0412	BlueSkies	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT201912188867	BARBARA ASAMOAH	NULL	NULL	NULL	20191218		NULL	NULL	NULL	NHIS	42040057	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 1025	1025	20191220	Salary Withdrawal For Dec 2019	QUARCOO COLLINS	NULL	2330.13	AD00651230	AD0065	Bomart	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT202001025415	BRIGHT AFFUL	NULL	NULL	NULL	20200102	0548621166	NULL	NULL	NULL	NIA	GHA-00089657-6	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 1281	1281	20200131	Salary Withdrawal For Jan 2020	MAVIS WOETSA TOGBO	NULL	694.13	CA59892001	CA5989	BlueSkies	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT202001176394	BRIGHT AFFUL	NULL	NULL	NULL	20200117	0240531307	NULL	NULL	NULL	SSNIT	E248704270029	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 1537	1537	20200131	Salary Withdrawal For Jan 2020	BERNICE ARYEE	NULL	618.88	CA28352001	CA2835	BlueSkies	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT202001202710	BRIGHT AFFUL	NULL	NULL	NULL	20200120	0543149901	NULL	NULL	NULL	VOTER ID	3659007763	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 1793	1793	20200130	Salary Withdrawal For Jan 2020	ERNESTINA OPOKU	NULL	352.19	DP22220120	DP2222	Bomart	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT202002036673	BRIGHT AFFUL	NULL	NULL	NULL	20200203	0546462796	NULL	NULL	NULL	SSNIT	G119008250021	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 258	258	20191130	Salary Withdrawal For Nov 2019	MATILDA ASANTEWAA DOMPREH	NULL	203.08	CA89081130	CA8908	BlueSkies	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT201911198925	BRIGHT AFFUL	NULL	NULL	NULL	20191119	0545096331	NULL	NULL	NULL	NHIS	31379367	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 514	514	20191130	Salary Withdrawal For Nov 2019	ABIGAIL ABBAN	NULL	252.41	CA33811130	CA3381	BlueSkies	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT201912101447	BARBARA ASAMOAH	NULL	NULL	NULL	20191210	0249623913	NULL	NULL	NULL	NHIS	73120670	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 770	770	20191231	Salary Withdrawal For Dec 2019	ABDUL MUMIN MORO	NULL	802.42	CA79641230	CA7964	BlueSkies	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT201912187790	BARBARA ASAMOAH	NULL	NULL	NULL	20191218		NULL	NULL	NULL	NHIS	14220432	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 1026	1026	20200131	Salary Withdrawal For Jan 2020	EUNICE ACHEAMPOMAA AKOWUAH	NULL	530.80	CA55592001	CA5559	BlueSkies	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT202001151059	BRIGHT AFFUL	NULL	NULL	NULL	20200115	0554439113	NULL	NULL	NULL	SSNIT	E039403140029	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 1282	1282	20200131	Salary Withdrawal For Jan 2020	CHRISTIANA ADJEI	NULL	295.11	CA80952001	CA8095	BlueSkies	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT202001174536	BRIGHT AFFUL	NULL	NULL	NULL	20200117	0542204164	NULL	NULL	NULL	SSNIT	E039204250063	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 1538	1538	20200131	Salary Withdrawal For Jan 2020	DEBORAH TIMAH	NULL	539.85	CA74902001	CA7490	BlueSkies	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT202001206205	BRIGHT AFFUL	NULL	NULL	NULL	20200120	0554043090	NULL	NULL	NULL	SSNIT	E179309250042	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 1794	1794	20200130	Salary Withdrawal For Jan 2020	AHIAMADZI ELLEN	NULL	487.42	DP28210120	DP2821	Bomart	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT202002034321	BRIGHT AFFUL	NULL	NULL	NULL	20200203	0556042460	NULL	NULL	NULL	VOTER ID	27800768	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 3	3	20191130	Salary Withdrawal For Jan 1970	HASSAN MOHAMMED	NULL	484.66	CA77491130	CA7749	BlueSkies	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT201911153971	BRIGHT AFFUL	NULL	NULL	NULL	20191115	0248366683	NULL	NULL	NULL	NHIS	14817478	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 259	259	20191130	Salary Withdrawal For Nov 2019	PAUL OHENE OPOKU	NULL	138.45	CB01121130	CB0112	BlueSkies	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT201911198418	BRIGHT AFFUL	NULL	NULL	NULL	20191119	0541612592	NULL	NULL	NULL	SSNIT	E039303100056	NULL
Edit	Copy	Delete DELETE FROM transtablejournal WHERE `transtablejournal`.`upload_id` = 771	771	20191231	Salary Withdrawal For Dec 2019	MICHAEL ANAAH	NULL	138.45	CB01191230	CB0119	BlueSkies	Paid	NULL	NULL	NULL	NULL	NULL	NULL	TT201912181808	BARBARA ASAMOAH	NULL	NULL	NULL	20191218		NULL	NULL	NULL	NHIS	40023945	NULL

Customize appearance of the navigation panel.

Customize the navigation tree.

Servers display options.

Databases display options.

Tables display options.

SQL upload ( 0 ) x -

Customize browse mode.

Navigation panel

Customize appearance of the navigation panel.

Navigation tree

Customize the navigation tree.

Servers

Servers display options.

Databases

Databases display options.

Tables

Tables display options.

SQL upload ( 0 ) x -

Browse mode

Customize browse mode.