Jump to content
Sign in to follow this  

displaying in portal based on a value

Recommended Posts


i have 2 databases, one which has user,level,mid and another database (say db2) has only user.So i setup portal relation between those 2 db's using user.

The field 'level' takes only 3 values say "1,2,3". i have three portals in db2.What i want is all which has level=1 should go to portal1 and level=2 goes to portal2 and so on.

how to do that?

Hope this makes sense



Share this post

Link to post
Share on other sites

To do what you want you will need to create three new calculating fields (result type = text) in your db2 file, with the formulae:

user & "1"

user & "2"

user & "3"


Then create a stored calculating field in db1 (result type = text) which has the formula:

user & level

Finally, create three separate relationships to db1 from within db2, one linking each of the new calculating fields in db2 to the calculating field in db1. Now assign one of these new relationships to each of your three portals.

That's it. Now all the entries for the same user in db1 which have a level of 1 will show in the first protal, level=2 in the second and level=3 in the third. Records for the current user in the db1 for which a level has not been specified (ie level=null) will not appear in any of the three portals.

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.

Reply to this topic...

×   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.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.