Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

Posted

I have a portal showing LAST NAME, FIRST NAME

The relationship is dynamic in that the user can choose via clicking a button, to show only last names starting with A or B or C etc. They can also type in and see all names starting with JONES, SMITH (or any partial letters).

All of this works perfectly. However, the portal doesn't always sort correctly.

I have tried sorting at the relationship level (LAST NAME, FIRST NAME)

I tried sorting at the portal in the layout in the same way.

I've tried with both on or one or the other on.

Every time - it usually sorts. However, when I click in the portal, then click on the letter choices outside the portal, it sorts in record creation order (FM default).

Refreshing the window doesn't work.

I have checked to be sure the fields are correct (in the correct relationship), etc. Everything seems perfect. Just, sometimes, it doesn't sort as it's told to.

Non of the scripts triggered by user actions call any sorting into play.

I'm stumped - an ideas?

Posted (edited)

Hmm. Some things worth checking/trying:

Fields are of type Text.

The language for sorting (in Storage options).

Spaces or unvisible characters in fields.

Rebuild the indexes for the sort fields.

Does it sort OK in the source table?

Edited by Guest
Posted

I am not sure how to rebuild the indexes, though I checked them and they appear correct.

Everything else checks out. It also sorts fine from at the source table.

It must be in my scripting, however - my scripts don't take any action on sorting that I can see. The scripts set globals that are used to filter the portal.

Running a sfilter cript sorts it incorrectly - immediately running it again sorts it correctly. I've tried COMMIT RECORD steps, refreshes, etc.

I'll keep troubleshooting. Are you aware of any sort issues after they patched 7.0v2?

Posted

OK - sorry for the delay - I needed to pull out all the graphics, etc to get the size down.

The attached looks strange (no graphics) but the problem is visible.

User is: Admin

No password

Portal lists all names in alpha order (as per relationship and portal sort)

Click a name down the list - that name appears on right of portal, but doesn't move in the portal. This would be highlighted if graphics were still there.

Now click ALL button. Portal is sorted by creation date - not the sort I selected at relationship.

Click ALL button again - now it sorts.

Relationship is CONTACTS to HOME - as this is for navigation.

It must be a script issue, right?

Also - scripts refer to things that are gone - I deleted to get the file smaller. But, the workings are the same - as is the issue.

Thanks in advance for any advice!

Test.zip

Posted

Also - the ALL button was one of many buttons in the real solution. You can click a letter and see just the names starting with the letter, etc.

I pulled all those off to shrink the file.

The sort messes up with any letter or ALL selected - if you select a record in the portal other than the first, then hit another button (ALL or any letter). It sorts wrong. Then, if you click the same button you just clicked - it sorts correctly.

Posted

I really cannot take the time to analyze what your scripts and relationships are doing in detail. It seems to me your solution is way more complicated than it needs to be (but then I am looking only at a portion of it).

However, I think I found the culprit - it is a screen refesh issue (probably caused by cacading relationships somewhere). If you add a Commit Records[] step at the end of your Select_Row_Highlight script, it should work.

Posted (edited)

I appreciate you looking at this. The Commit Record step seems to work - I needed to adjust another couple steps elsewhere to make it work for the whole solution.

I agree it's complicated, but in the scope of the whole solution, which is very large, it seems to be the most compact I could make it and still have it work within the complete solution (with my average skills). Thanks!

Edited by Guest

This topic is 6864 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.