allow parameterized queries in MODE_QUERY. viewer may select values for the parameters when displaying visualization of query result

In n:m tables that are linked via T_LOOKUP/CARDINALITY_MULTIPLE fields, the linkage table might have additional required fields. Currently this can only be discovered through knowing or through the error raised when saving the record. Form validation should be built in for all linkage tables that have required fields which do not have a default values specified in the settings.

In MODE_NEW, each "Create New" button adds the resulting record only to the dropdown box to which the button is attached. All other dropdowns with the same linked entity type should be updated as well.

Whenever an upload is performed the browser sgouldn't freeze and instead visual feedback should be displayed; e.g. a moving hourglass.

... this allows users to edit e.g. image properties withouth having to reupload the original image.

Hi, is it compatible with mysql?
Thanks

Hi,

we need a method for the following situation: We want to add a default-value for T_TEXT_LINE. This value should be displayed when the site is requested by a user within the corresponding text-field.

Cheerz,

Kevin

Hello! This engine saved me a lot of time doing simple CRUD applications for our PostgreSQL instance. Overall it's pretty good, but I faced with one request I wasn't able to resolve. Table view. "Yeah, just like in Google Sheets, it would be way faster to insert a batch data here rather than in a form". Seems like a wise idea, so I am sharing it with you guys. Thanks for such a delightful solution for "hey, you kinda know computers, solve this" kind of people. ❤️

offer setting to limit returned results

Allow setting a custom page icon

Apologies if I'm missing something obvious but my installation displays list of records fine and I can search on columns, edit & add records but I can't see any way to access the SQL query box or the charts shown in the screenshots.

Do I need to write some plug-ins in PHP?

Allow user to initiate merging of any two records in a table (along with their "dependencies" established by lookup fields)

This looks like a great program that suits my needs well but I'm finding that all searches return null results. I have columns of various types - text, fixed length characters and boolean, but all searches return no results. My postgres log shows lines like:
2019-04-10 19:25:00.539 BST [3831] postgres@cases ERROR: could not determine data type of parameter $1
2019-04-10 19:25:00.539 BST [3831] postgres@cases STATEMENT: SELECT COUNT(*) FROM "cases" d WHERE "full_text"::text like concat('%', $1, '%')

I'm using Firefox (but get same issues on Vivaldi) on ubuntu 18.04.02 on an oracle VM.
Postgres is v 10.7
PHP v7.3.3

Any help would be much appreciated

The original issue is below but now I believe THERE must exist user-defined validation function!!! Such function should check field values and prevent form from submitting with error popup
Isn't it possible to implement drop down calendar and corresponding datatype/field type? Thank you very much for your great project I'd donate if I had money...

Isn't it possible to somehow restrict edit ability for some users for some tables? There is login functionality but no right management? Can it be implemmented by user? Maybe in login_success_proc I can define table rights depending on logged in user name?
I'll probably have write a separate php script which will after login

1. edit seetings.php of dbwebgen
2. open and pass login info to real dbwegen
   Or how do I allow certain users to see/edit certain tables For example
   user:Ivan{
   meals{view}
   hotels{view,edit}
   }
   user:maria{
   meals{view,edit}
   hotels{view}
   }

use select2 ajax functionality to dynamically populate dropdown box while typing

... when the null field display is disabled

When I display id (not "name" for example) in T_ForeignKeyLookup

'trip_id' =>
						array (
							'label' => 'Trip Id',
							'required' => true,
							'editable' => true,
							'type' => 'T_ForeignKeyLookup',
							'lookup' =>
								array (
									'cardinality' => 'CARDINALITY_SINGLE',
									'table' => 'trips',
									'field' => 'id',
									'display' => 'id',
									'label_display_expr_only' => true,
								),
						),

And when I create a new "trip" clicking near "Trip Id" field the dropdown IS NOT UPDATED and is not autosubstituted..
When I use for example

 'hotel_id' => 
      array (
        'label' => 'Hotel Id',
        'required' => true,
        'editable' => true,
        'type' => 'T_ForeignKeyLookup',
        'lookup' => 
        array (
          'cardinality' => 'CARDINALITY_SINGLE',
          'table' => 'hotels',
          'field' => 'id',
          'display' => 'name',
          'label_display_expr_only' => true,
        ),
      ),
    ),

So when I use 'display' => 'name', there is no such bug...
Why there is a bug with using 'display' => 'id', ?

Hi, I would like to know if you agree to include js and css in the project ?

Indeed, dbWebGen cannot render pages in 'offline' mode.
New directories /content should be used :

/dbWebGen/inc/bootstrap/js
bootstrap.min.js
jquery.min.js
select2.min.js
transliteration.min.js

/dbWebGen/inc/bootstrap/css
bootstrap.min.css
select2-bootstrap.css
select2.min.css
/dbWebGen/inc/fonts
glyphicons-halflings-regular.ttf
glyphicons-halflings-regular.woff
glyphicons-halflings-regular.woff2

Searching related data does not work properly in n-m-relations

Hello.
First, congratulations for your great work! An excellent tool to manage queries in a database!!
I use your tool to make many queries, and store that.
But when I get the result, and try to order pressing in the heading of the column, the numeric column values dont get ordered.
If there are two values, for example, 234 and 1234, the app get first 1234 than 234.
It work with the numbers as strings: the "1" before the "2", not the 234 before the 1234.
Can I correct that in any way?
Thanks!

We require a method for the following use-case:
Behind input-fields symbols may be displayed. Once a symbol is clicked by the user, the textfields value is set to a pre-defined value. E.g.: Symbol is "hammer and sickle" and value should by ´communism'.

Right now we have 1:N (T_LOOKUP with CARDINALITY_SINGLE) and N:M (T_LOOKUP with CARDINALITY_MULTIPLE). We lack some kind of a N:1 (a reversed 1:N) relationship.

Example: brand 1:N model. Right now it is possible to use a 1:N lookup in model and assign the brand to the model. In many cases, e.g. to reduce the form editing effort, it makes sense to allow assigning models to brands in the brand editing form. Supporting this should be possible in dbWebGen

The bootstrap version used into package.json is version 3.4.1

This version is got an issue with popover widget. moving back to bootstrap 3.4.0 resolve the issue....

The clean way is to tune sanitizer rules.

We need a function that allows common users to change their password within the application.

We need a function that allows users that submited an email to reset the password via that email adress

something like

  'lookup' => [
    'predefined_values' => [
      'name' => 'Marl Calone', // e.g. for T_TEXT_LINE
      'locations' => '[2,19]', // e.g. for T_LOOKUP/CARDINALITY_MULTIPLE
      'age' => 9 // e.g. for T_NUMBER
    ]
  ]

"search_string_transformation" setting should be used for comparing T_LOOKUP async lookups