Comment in element admin - also for MySQL?

[Jaanus]

In element admin there is a textarea "Comment". This is "an internal memo allowing administrators to make a comment about the element's usage. Not shown in the form or view."

In MySQL, the database fields have also a place for comments for the same purposes.

Have you thought about adding another textarea in element admin form for MySQL comment? Would it be possible to submit the content of one element admin form field to the database field's comment area (even if list settings doesn't allow to change the field type)? Of course with a warning that changing this in one element would change the comment for all elements using this db field.

It would help us in case when we build some applications with Fabrik and want to give one of them (or show, explain etc) to someone other. For this we export the needed tables in phpmyadmin, isn't it? But it's very hard to understand the purpose of such fields named as 'parent_id' etc if there are no explaining comments at them.

The already existing "comment" would remain as individual comment area for each Fabrik element.

Another idea. In element admin list, would it be possible to display the element name and label in one cell
e.g
elementname /
Element label

and use the remaining space for displaying comments

e.g
MySQL comment if such feature will be implemented /
existing element comment

It would just give better overview than hover

 

[rob]

I think the issue here is that the comment property can only be accessed via some mysql specific queries, which is something we are trying to avoid (and move away from) so that at some point in the future we only use Joomla's database query builder to build queries. This will allow fabrik to be used on Joomla sites using databases other than mySQL.

 

[Jaanus]

So in other db-s the field comment properties are not available? Hmm, in this case we could add a warning that "works only in MySQL" or "Doesn't work in (database type)"

Here is also a picture just to better illustrate what I mean