nuBuilder Forum

Hi
I discovered and tried nuBuilderPro and I really appreciated the proposed features. Thanks for this solution.

I used it to have differentiated access to the same table depending on the user:
- records are displayed to user A if the record matches a condition (i.e. if one field equals user's access level, thanks to #nu_access_level# hashtag). Such normal user can see some fields only and can't edit the data
- admin users have access to the whole table, all fields and can edit records.

To do that I created 2 forms on the same table, one for normal user that has a specific 'select SQL' clause, the other (for admin user) with a "normal" select (select * from table).
I used 2 different forms with 2 different set of objects because the readonly for the fields does not appear to be dependent of access level
Is it the right way to do it ?

I also put 2 different tabs on the home form such that each kind of user has access to the tables (thought button object) they have right to.
Is there a way to hide a tab depending of the user ?

I would like to have 2 different home for each user. I then tried to duplicate the home to home2 and to set home2 as home of a new user 'test'. But when login as user 'test', I get an error (see traces below).
I tried to allow access to home2 to the user, but this does not change anything.
I'm also confused by the home form that does not appear in the form list.

I also have some questions :
- if it is possible to do batch delete of forms (very useful when you tried some forms that you want to delete in one click) ?
- I tried to click on the login name at the bottom on f the form to edit the form (as globeadmin) as showed into video #4, but it does nothing...
- as long as there is 1-to-1 relation between access level and user group, why having user group ?

Thanks for any advice.

Regards

Olivier

===USER==========

test

===PDO MESSAGE===

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE = '-1'' at line 1

===SQL===========

SELECT * FROM WHERE = ?

===BACK TRACE====

/var/www/vhosts/zebradultes.ouvaton.org/httpdocs/nuBuilderPro-master/nucommon.php - line 508 (nuRunQuery)

/var/www/vhosts/zebradultes.ouvaton.org/httpdocs/nuBuilderPro-master/nucommon.php - line 466 (nuRecordArray)

/var/www/vhosts/zebradultes.ouvaton.org/httpdocs/nuBuilderPro-master/nuapi.php - line 16 (nuHashData)