Comments (6)
Thanks for opening the issue. Unfortunately your issue does not contain enough information. Please try to provide as much info as possible, generally following these three main questions:
- What did you do?
- What did you expect to happen?
- What happened instead?
Please also describe what steps you took to analyze the issue and what (failed) attempts you made to fix the problem yourself.
Your issue should contain everything that might help in analyzing and reproducing the issue. That includes but isn't limited to:
- versions of the involved software
- exact error messages
- debug logs (also check your JavaScript console for web related issues)
Thanks for your help.
PS: You may want to refer to How to Ask Questions the Smart Way for more tips on improving your issue creation game ;-)
from dokuwiki-plugin-data.
Error description:
a) First problem:
For example:
I have an aggregation of our company employees with the following syntax:
---- datatable ----
cols : Anrede, %pageid%, Kurzzeichen, Abteilung_person-abt, Telefon, Mobil, Email_mail
header : Anr., Name, Kurzz. , Abt., Tel., Mobil, Email
filter : %pageid%~personal:personalstammdaten:*
sort : %pageid%
dynfilters : 1
----
The aggregation brings as extract this result:
As you can see, from line 2 onwards, the entries are duplicated.
Here is the definition for the item in line 2:
---- dataentry personendaten ----
Anrede : Hr. #
Nachname : Gerold #
Vorname : Udo #
Kurzzeichen : #
Bereich_person-bers : Verwaltung #
Abteilung_person-abts : MW, MWS #
Unterbereichs : ML #
Arbeitsplatz : #
After some tests, I've found out the following:
The error seems to be dependent on the type aliases, if they allow multiple values. If I delete the second value for "Abteilung_person-abts" the aggregation is correct.
Our release is "2022-07-31a Igor". There are no error logs.
b) Second problem:
I have a syntax like this:
---- datatable ----
cols : Abteilung, %pageid%, Telefon, Mobil
header : Abt., Name, Tel., Mobil/Extern
widths : 5em,20em,5em,10em
filter : %class% = personendaten
and : Abteilung ~ WM*
and : Personalfunktion >
and : Arbeitsplatz =
sort : %pageid%
----
When I edit the page the preview shows the right aggregation:
But when I look at the result (sometimes only after refreshing), the output is destroyed:
The aggregation shows values from totally different data classes.
Attempts to fix the problem:
I have deactivated and reactivated the data plugin, but nothing has changed. I haven't yet dared to delete the plugin and reinstall it because I'm afraid of losing the definition of the type aliases in the process.
Best regards
Juergen
from dokuwiki-plugin-data.
I second this issue. However, it seems the issue is really with the sqlite plugin and not with the data plugin. My workaround was downgrading the sqlite plugin to version 2022-11-29. I noticed that between the releases there were some attempts to switch to sqlite's native group_concat. Perhaps there are some leftovers after reverting?
from dokuwiki-plugin-data.
@jnv can you give the devel branch a try?
from dokuwiki-plugin-data.
@splitbrain I'm running a fork of this plugin with numeric sorting (#204), but from a quick glance I should be able to rebase that on top of devel. I'll give it a try, thanks!
from dokuwiki-plugin-data.
Closing this, since no further feedback has been given.
from dokuwiki-plugin-data.
Related Issues (20)
- generated tables missing border lines when using bootstrap3 template
- Pull-down menues for filtering datatable
- Feature : make some field visible but not editable in the dataentry
- [BUG] datatable don't display multiple links from a dataentry field
- Bug: Some column names breaks the whole page rendering
- Using Dataentry with Ckgedit HOT 1
- Comparators "<" and ">" not working as expected
- missing datas - bug or am I stupid? HOT 2
- PHP 7.3: "Parameter must be an array or an object that implements Countable" HOT 5
- URLs in datalist output don't use rewrite HOT 1
- How many datatables are allowed per page HOT 5
- First item selected by default in multiselect when using Bureaucracy plugin form
- No editor for edit target plugin_data found
- filteror doesn't work with non-wildcard operators
- Multiple values with type aliases broken HOT 2
- datatable alingment error HOT 1
- deprecation warnings helper_plugin_data
- 📢 State of the Plugin
- Warning: Undefined array key HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dokuwiki-plugin-data.