Jump to content
Sign in to follow this  

a simple portal..

Recommended Posts

Hello All,

Please help.. I just want to make a simple portal

in my email DB thats shows the emailaddress field of all

found records in my main DB....

I'm just not Getting it...



Share this post

Link to post
Share on other sites

Hi Erick,

Well, you've not said much about what you don't *get* ooo.gif Are you having problems creating a portal or are your results not what you want? A portal should be placed in your MAIN dB and will show related records. Your post sounds like you're trying to place the portal in your related dB.

So your main dB would show a portal of your related email dB. If your main record has a related email record (or records) they will display in the portal if you place your email field (from email dB) in the portal.

If you could explain a bit more about what you have tried (indicate your main and related dB names and email fields) and what your problem is, we'll be able to help you more smile.gif



Share this post

Link to post
Share on other sites

Hi Erick,

Unfortunately, portals are *not* restricted to a found set in the child (related) file. They will show all records that match the relationship.

So, you need to make your relationship based on something that will return what it is you want to see. In this case, use a field in both files that will bring in the expected results. Good examples would be Company ID for all emails for a particular company. A Group ID to return members of a particular Group, etc.




LaRetta anwser came in while I was off composing this, sorry if there is conflecting or duplicate information


Share this post

Link to post
Share on other sites

>Unfortunately, portals are *not* restricted to a found set in the child (related) file....

...but you can perform a find, "flag" those found records by inserting a value in a flag field, and then base the relationship on that.

This is for Situations where you have complex find requests which cannot be calculated. script would be like this:

perform find, NOT stored request


show omitted

replace (flagfield,"")

Share this post

Link to post
Share on other sites


A Simple Portal !

Keeping almost Christian's idea....

Create a layout in the related db with only one field ("contact_ID" in that case)- Call it "FoundsLayout"

Create a global or preferably a text field called "Founds_Ids"

Then create a script in the "related file"

Script 1:

Perform Find

(Whatever your script does search)

Go to Layout "FoundsLayout"

Go to Field "Contact_ID"

Copy all records

And another in the "Main File"

Script 2 :

Go to Layout (where your "Founds_Ids" is)

Go to Field (Select "Founds_Ids")


Go to Layout (where your portal is)

The final script, attached to a button near the portal would be :

PerformExternal (Script 1)


Now, you would need to create a portal with relationship :


Ultimately, if your querry was to display "ALL" records from your file in a portal, this is made by a ConstantSelfJoin relationship with a constant key for left side (makes it a global and populate it with a 1---> g_constant) and a constant match for right side (indexed calculation = 1---> c_indexconstant)

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  

  • Who Viewed the Topic

    1 member has viewed this topic:
  • Create New...

Important Information

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