Jump to content
  • 0

Question

Hello;

Does anybody know a way to dynamically set the data source of a data page?

 

For example:

 

tblData_[@authfield:AccountID]

 

AccountID = 1

DataPage -> Data Source = tblData_1

 

AccountID = 2

DataPage -> Data Source = tblData_2

 

Much Thanks!!

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0

Hello EIQ,

 

There is the standard feature Record Level Security allows to restrict access to records based on the current user’s profile data. For example, based on AccountID. You can see the video about this Feature.

It seems, it can help.

 

Also, you can create user-specific redirect after login (video), but in this case it requires to create a separate DataPage for every DataSource.

 

As far as I know, it is impossible to dynamically set the data source of a DataPage.

Share this post


Link to post
Share on other sites
  • 0

Thanks for the reply!

 

Your first suggestion is employed for my tblUser and tblAccount tables, but the rest of my tables will be too large if I combine accounts and use RLS.

 

Your secound suggestion is my current plan for scaling deployment to many users, and your remark about needing multiple data pages is what I am trying to avoid.  My app currently has 65 (and counting) data pages and copying the app, copying the web-site, and re-deploying each data page is a task I am not looking forward to.

 

Anybody know any workarounds?

THANKS

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...