First of, I honestly didn’t expect an answer over the weekend, thank you for taking some time on this.
I were just looking from a security perspective what users of this platform think is the best way. I saw the StandardClientEntity and the init and exception. At first I couldn’t find the filters then I found it in Administration area within the app itself, so it made sense how it was done first. I don’t dislike it, dynamic queries is something I enjoy due to the flexibility, but I always monitor overhead and the SQL explain plan to make sure it doesn’t break under load. I worked on realtime transactions before and I just have a habit of planning for overhead But since this is not a realtime solution I work on this might not be something I should be too concerned about.
As for what I want to do :
- Admin user which sees all (The basic OOTB system after generated)
- Anonynous users can register, and are inserted as “users” in the database. So they fill in a scaled down user form (Not the full one, thus my question where it is kept)
- The users have their own dashboard (Was originally thinking Portal, but I think I could get away with the app itself since I want to use the premium addons after I buy it to allow nice charts for the end users)
- Comment section (Pseudo forum like style) where users can comment and look at others feeds (Very simplistic)
That is basically it in a nutshell. I am linking into two major systems (Salesforce etc), and that code I will integrate later on. Thus the account segregation questions.