Jump to content

what is the found set?


GlennC

This topic is 7354 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello,

What is the found set in a portal? When searching for specific records the portal of course has all the associated records with it. Does this mean functions like lookups etc will apply to all the records?

Or am I just hopelessly confused?

Thanks,

Glenn

Link to comment
Share on other sites

There is no such thing as "the found set in a portal." Relationships and found sets are two different things.

A "portal" is a somewhat limited way of thinking about what you're seeing. The relationship that the portal is based on is what matters. It doesn't really matter how many records are visible in the portal; that's just a layout thing; like making your field too small; the data is still all there.

It's often better not to think so much of related records as rows in portals. Think of them as the records matching the relationship in the other file.

Now, a lookup occurs in a field when another field on its same record, in its file, has its value changed. So if you changed a field in a portal, it may trigger a lookup in that row, in that record in the related file, but it has no affect on its "parent" record, which is in the file the portal is in (unless it's the same file, ie. a self-relationship).

And vice versa, changing a field outside of the portal is not going to trigger a lookup inside the portal.

If you do something affecting the entire found set, in either file, then it's just the same thing repeated many times. But to do that with the "portal rows" you would have to go to them, in the other file first; via the relationship.

Link to comment
Share on other sites

This topic is 7354 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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