Grid application with multiple (at lest two) user levels

Applications Grid / Reports
#1

Hello there,

I am pretty new with ScripCase; just in my testing period and thinking about purchasing it.

Before I do that, I need to know whether ScriptCase suffices my needs:
I want to create an web application, with different user levels:

    [li]guests are allowed to search the database using several criteria. When viewing the result set, the shall be shown a smaller grid, which is subset of all attributes; e.g. some 'columns' are not for normal users intended.[/li] [li]normal users are the same as guest, maybe they'll be allowed to bookmark some of the records (like in eBay when you follow an offer) for easier retrieval when returning to the website.[/li] [li]super users shall be allowed two view an extended version of the data and shall be able to modify existing data records and insert new records into the database[/li] [li]maybe there'll be admin users, which shall be able to see even more data attributes; maybe like SELECT * FROM ...[/li]
I'd greatly appreciate if some of you, with experience in ScriptCase, could answer if this can be done using ScriptCase.

Thanks in advance!
Sascha.

#2

Re: Grid application with multiple (at lest two) user levels

guests are allowed to search the database using several criteria. When viewing the result set, the shall be shown a smaller grid, which is subset of all attributes; e.g. some ‘columns’ are not for normal users intended.

option 1: You can create different forms/grids for each user (groups).
option 2: use sc_field_display/sc_apl_conf macros to display or hide fields depending on user group. User group must be passed to the application or you have to get it from within the application by querying the authorization tables.

normal users are the same as guest, maybe they’ll be allowed to bookmark some of the records (like in eBay when you follow an offer) for easier retrieval when returning to the website.

You have to program some cookie functionality yourself. Remember, SC is for web applications, it’s not a tool to build websites.

super users shall be allowed two view an extended version of the data and shall be able to modify existing data records and insert new records into the database

option 1: You can create different forms/grids for each user (groups).
option 2: use sc_apl_conf macros to enable/disable data entry functions.

maybe there’ll be admin users, which shall be able to see even more data attributes; maybe like SELECT * FROM …

see above.

Hope this helps in making a decision. If you choose to buy Scriptcase, be prepared: documentation is horrible… Requests from several users to improve this are simply being ignored. It seems they don’t want Scriptcase to become a worldwide hit.