portal not working on filtered self-relation

[innodes]

I have searched the forum, but can't find this topic, though I am sure it is here somewhere.

I have a portal that is based on a self-related table. The relationships are name=name and X=status. The X field is a constant set up in the table. The status field has an X inserted as appropriate based on where the item is in the work flow.

The primary problem is the portal is showing blank. We added some navigation tools and found that what it is doing is showing only one record at a time. Without the navigation tools, it is locked up as blank. With the tools, you can navigate to a record. It's like it is sorting via X instead of Y.

With navigation, it is showing all 5000 records (using navigation tools), but those without the X are blank.

thanks in advance for the help

[Raybaudi]

Hi

if you change the relationship to only:

gName = name

( where gName is a global field ) and write inside the gName filed a name that you know that exist more than a time in your DB, will appear those records in the portal ?

[innodes]

Hi,

Thanks, I think it worked. What I needed though was the X_filter=X in the relationship in order to filter the list down. I have some more digging and cleaning to do, but it looks like that did it.

Thanks for the help and have a great weekend.

mike

[Raybaudi]

What I needed though was the X_filter=X in the relationship in order to filter the list down.

Yes, I knew that...

My post only suggest you the right way to see something in the portal, and that was the first step.

The second will be to add the new condition to the relationship:

cFieldX = fieldX

where cFieldX is a calculated text field with calc:

"X"