View source for Kexi/TODOs/Archive

{{Warning|Mar 2023 [jstaniek]: Relevant TODOs moved to https://invent.kde.org/office/kexi/-/issues, links added here. Continue working with the tasks there.}}

See Also: [[Calligra/Schedules/Feature_Plan#Kexi|Calligra Feature Plan]].

==General==
{{TableStart}}
! Status !! Description !! Assigned To
{{FeatureDone|Use KPluginInfo for any kind of plugins, what would allow for creating main window (esp. the project navigator) without loading any plugins in advance|jstaniek [2.6]}}
{{FeatureDone|Re-add all the missing actions to the toolbars; [[/Menu Actions Checklist|look at the .rc files of Kexi 1.x for reference]].|jstaniek [2.5]}}
{{FeatureDone|Refresh icons:
*copy view-form as form
*copy view-form-table as table
*create query icon from view-form-table
*reports from view-pim-journal
*use view-multiple-objects
*use emblem-new instead of "*" everywhere
*replace * in object_new with emblem-new
*use the thunder from view-form-action for 'assign action' and display it in designer over buttons and in the widget tree
*refresh script icon (and maybe add name "js", "py"" to the script icon)
*show data-source-pkey-tag icon for widgets with pkey field assigned
'''Done by moving to the breeze icons in the meantime and designing them'''
|jstaniek [2.5]}}
{{FeatureWish|Set the script language project-wide, <strike>and use a single Kross::Action to retain state between scripts</strike>
https://invent.kde.org/office/kexi/-/issues/82|}}
{{FeatureWish|Add translation module for any user-visible text in database. Perform research on reusing core parts of [http://userbase.kde.org/Lokalize Lokalize] or Qt Linguist. Refactoring Lokalize may be needed (better) or just forking some code (worse). Contact the Lokalize team to be sure. GNU gettext .po files format is preffered. Storage: database as everything in Kexi. Strict integration means there should be no external programs executed in the foreground and the workflow should resemble other workflows in Kexi, so the translating interface would be displayed within a tab.
https://invent.kde.org/office/kexi/-/issues/83|}}

|}

==Main Window==
{{TableStart}}
! Status !! Description !! Assigned To
{{FeatureDone|Create lightweight nonmodal web-like startup screen|jstaniek [2.4]}}
{{FeatureWish|Create XML-based tabbed toolbar framework
https://invent.kde.org/office/kexi/-/issues/84|}}
{{FeatureWish|Create XML-based sidebar toolbox framework
https://invent.kde.org/office/kexi/-/issues/85|}}
|}

==Table View==
{{TableStart}}
! Status !! Description !! Assigned To
{{FeatureDone|Fix rendering problems when the number of columns exceeds the view width. Issuess when scrolling (after porting to Qt 4)|jstaniek}}
{{FeatureDone|Port to Qt 4|jstaniek [2.9]}}
{{FeatureDone|Port to QScrollArea|jstaniek [2.9]}}
{{FeatureWish|Zooming. After porting to QScrollArea
https://invent.kde.org/office/kexi/-/issues/86|}}
|}

==KoProperty==
{{TableStart}}
! Status !! Description !! Assigned To
{{FeatureDone|Transition to KoProperty2|jstaniek}}
{{FeatureDone|Create QSizeF and QPointF properties|piggz}}
{{FeatureDone|Improve rendering|jstaniek}}
{{FeatureDone|Add missing properties: QColor, KoUnit, LineStyle|jstaniek}}
{{FeatureTodo|Mising border below the last item when its editor is visible|jstaniek}}
{{FeatureTodo|When started to change the editor's value: "revert" button should appear, if the property has parent, the item for the parent should be repainted|jstaniek}}
{{FeatureWish|Fix or reimplement spin box widgets: look bad with oxygen and probably other styles|jstaniek}}
{{FeatureWish|Create QRectF property|piggz}}
{{FeatureWish|Add multiselection combo, i.e. for QFlags, e.g. [http://www.fgcu.edu/support/office2007/access/Images/ClearFiilter.gif]<br>QListWidget has a Qt::ItemIsUserCheckable flaf for items that adds a check box. For more advanced use cases kdeui offers a mini-framework called [http://techbase.kde.org/Development/Tutorials/Introduction_to_Goya_usage Goya] that makes it easier to insert widgets into model views than plain Qt use. '''Optionally''' use subproperties, like it is done with x, y for QPoint type.|jstaniek}}
{{FeatureTodo|Add Maps Theme manager as a QMap<string, variant>|Radek Wicik[2.6]}}
|}

==Tables==
Includes table data view and Table Designer.

{{TableStart}}
! Status !! Description !! Assigned To
{{FeatureTodo|Fix setting primary key using toolbar button|jstaniek}}
|}

==Queries==
Includes query data view, Query Designer and SQL Editor.

{{TableStart}}
! Status !! Description !! Assigned To
{{FeatureTodo|Use the real KEXISQL parser for criteria column in the design view. Currently simple regexp is used there. Especially support LIKE operator.|jstaniek [2.6]}}
{{FeatureTodo|Reimplement relationship editor using GraphicsView|jstaniek [2.?]}}
{{FeatureWish|Add support for grouping/totaling; {{Bug|195360}}|jstaniek [2.?]}}
|}

==Forms==
Includes form data view and Form Designer.

===Forms - general ===

{{TableStart}}
! Status !! Description !! Assigned To
{{FeatureDone|Port the plugin|jstaniek}}
{{FeatureDone|Fix the rectangle and repainting when inserting widgets with specified size|jstaniek}}
{{FeatureDone|Port Widgets Tree tab (it's hidden in 2.2)|jstaniek [2.3]}}
{{FeatureTodo|FormManager::FormManager: register factory (port to koproperty2)|jstaniek}}
{{FeatureTodo|Port KFDPixmapEdit, PropertyFactory|jstaniek}}
{{FeatureDone|Add support for paletteForegroundColor and paletteBackgroundColor properties of Kexi 1.x|jstaniek}}
{{FeatureTodo|Add translation and simplify "textInteractionFlags" for QTextEdit and QLabel|jstaniek [2.?]}}
{{FeatureDone|Fix setting "enabled" property to false|jstaniek}}
{{FeatureTodo|(Windows-only?) when right-clicking again after context menu has been displayed, update selection, otherwise the context menu items won't be adequate to the selection|jstaniek}}
{{FeatureTodo|Make sorting work in forms - {{Bug|150372}}|jstaniek [2.?]}}
{{FeatureTodo|Port Tab Order dialog (it's hidden in 2.2)|jstaniek [2.?]}}
{{FeatureWish|Implement tabular layout|jstaniek [2.?]}}
{{FeatureWish|Implement editing mode in data view|jstaniek [2.?]}}
{{FeatureWish|Implement scripting ability for forms similar to reports|? [2.?]}}
{{FeatureWish|Implement/renew the simplified form layouts:
*Stretch top/bottom/left/right/top&down/etc.
*Inserting/pulling out widgets out of the layout
*Moving/resizing entire layout
*Support 'Size to shortest'/'To fit'/etc. in layouts
|jstaniek [2.?]}}
|}

===Form widgets ===
Form widgets implementation.
{{TableStart}}
! Status !! Description !! Assigned To
{{FeatureDone|Fix/port text box widget support|jstaniek}}
{{FeatureDone|Fix/port image box widget support|jstaniek}}
{{FeatureDone|Fix/port text editor widget support|jstaniek}}
{{FeatureDone|Fix/port tab widget support|jstaniek}}
{{FeatureDone|Fix/port combo box widget support|jstaniek}}
{{FeatureTodo|Fix/port/reimplement auto field widget support|jstaniek [2.6]}}
{{FeatureTodo|Use KRichTextWidget or KRichTextEdit instead of KTextEdit|jstaniek [2.6]}}
{{FeatureTodo|Fix setting alignment property (e.g. for text box) - does not work because it is numeric now|jstaniek}}
{{FeatureTodo|Fix/port the Spring element|jstaniek [2.?]}}
{{FeatureTodo|Display "data" icon and data source name in combo boxes and labels|jstaniek [2.6]}}
{{FeatureDone|Implement web browser widget|[[Kexi/Junior Jobs/Web Browser Form Widget|Junior Job]], Shreya Pandit [2.4]}}
{{FeatureDone|Implement map browser widget|[[Kexi/Junior Jobs/Map Browser Form Widget|Junior Job]], Radek Wicik [2.4]}}
{{FeatureTodo|Switch to the new New Date/Time Widgets from kdeui [https://git.reviewboard.kde.org/r/101575/]|jstaniek [2.6]}}
{{FeatureTodo|Add Maps Theme manager for MapBrowserWidget|Radek Wicik[2.6]}}
|}

==Reports==
Relates to the new Reports Plugin (data view and the designer)

{{TableStart}}
! Status !! Description !! Assigned To
{{FeatureDone|Rename reportspgz to reports everywhere|piggz [2.2]}}
{{FeatureDone|Fix javascript kross plugin, or disable as it seems buggy, qtscript is ok|piggz [2.2]}}
{{FeatureDone|Export to KWord (OpenDocument Text Format, ODT)|piggz [2.3]}}
{{FeatureDone|Make report entities (label/field etc) plugins, so its easier to add new ones|piggz [2.3]}}
{{FeatureTodo|Add subreport item {{bug|330219}}|piggz [2.5]}}
{{FeatureTodo|Improve Section Editor: move first/last sections (4) to an advanced mode somehow for powerusers. Making the dialog use ok/cancel buttons instead of Close.|piggz [2.4]}}
{{FeatureTodo|Maybe use flakes, or create a report 'shape' that can be embedded elsewhere|piggz [2.4]}}
{{FeatureTodo|Add more math functions?|piggz [2.4]}}
{{FeatureTodo|Undo/Redo support|piggz [2.4]}}
{{FeatureTodo|Custom page sizes [https://git.reviewboard.kde.org/r/115314/]|[2.8]}}
{{FeatureTodo|Labels|piggz [2.4]}}
{{FeatureTodo|Table Item|piggz [2.4]}}
{{FeatureWish|Create a flake based report designer|piggz [2.6]}}
{{FeatureDone|Implement web browser element|[[Kexi/Junior Jobs/Web Browser Form Widget|Junior Job]], Shreya Pandit [2.4]}}
{{FeatureDone|Implement map browser element|[[Kexi/Junior Jobs/Map Browser Form Widget|Junior Job]], Radek Wicik [2.4]}}
{{FeatureTodo|[[Kexi/Junior_Jobs/Implement_"Do_you_want_to_open"_question_after_exporting_report|Implement "Do you want to open" question after exporting report to Text/Spreadsheet/as Web Page]]
|}}

|}

==Database Support==
{{TableStart}}
! Status !! Description !! Assigned To
{{FeatureDone|Merge recent changes of KexiDB into [[KDb]]|jstaniek [2.3]}}
{{FeatureDone|Port Kexi to [[KDb]]|jstaniek [3.0]}}
{{FeatureWish|Publish tutorial about development with [[KDb]]|jstaniek [2.?]}}
{{FeatureInProgress|Add unit tests to [[KDb]] using QTestLib. Certain type of tests could be executed with several drivers. That would validate any change made in KDb against different drivers. Consider testing agains different versions of backends. What we have currently is explained in {{BugComment|254188|9}}|jstaniek [2.?]}}
{{FeatureWish|Perform benchmarks using QTestLib (valging, callgrind) and cachegrind, and propose improvements.|? [2.?]}}
{{FeatureWish|Export [[KDb]] API thought QJSEngine.|? [2.?]}}
{{FeatureWish|Integrate one or more backends for Kexi with [http://owncloud.org ownCloud], e.g. PostgreSQL (+middleware for easier user account mgmt)|[2.?]}}
|}

==Migration==
{{TableStart}}
! Status !! Description !! Assigned To
{{FeatureDone|Add mdb driver to cmake|piggz [2.2]}}
{{FeatureInProgress|Finish dialog for importing a table into the current database|piggz}}
{{FeatureInProgress|Add ability to existing migration drivers to read a single table|piggz}}
{{FeatureWish|Add kross script bindings to kexiscripting for migration|piggz [2.?]}}
{{FeatureTodo|[[../Migration#Porting_to_non-modal_assistants|Porting to non-modal assistants]]|?? [2.?]}}
|}

==Import/Export==

{{TableStart}}
! Status !! Description !! Assigned To
{{FeatureDone|Fix "Export to CSV" dialog|piggz, jstaniek [2.3]}}
{{FeatureInProgress|Port CSV Export wizard to KAssistantDialog|??? [2.?]}}
{{FeatureWish|Add support for fixed width text export ({{Bug|254621}})|jstaniek [2.?]}}
|}

==Printing==

{{TableStart}}
! Status !! Description !! Assigned To
{{FeatureWish|Reimplement simple printing using Kexi Reports|jstaniek [2.?]}}
|}

==Mobile==

{{TableStart}}
! Status !! Description !! Assigned To
{{FeatureDone|Abstract or disable features not used on mobile target (mostly done, merge branch kexi-mobile-adam_pigg with master, reviewed by jstaniek)|piggz [2.4]}}
|}