Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Sorting a portal

dailo
in Portals

Featured Replies

I have a portal setup and I thought it was sorting correctly, but I guess not. Its probably an error on my part so maybe there is something wrong with my logic.

Right now this is the order:

1. sort prioirty by custom values

2. sort by assigned (created) date by ascending order

3. sort by modified time by by ascending order

Basically its a queue for things that need to be done and priority is working fine, when set to high it goes right to the top. However for some reason it doesn't sort it correctly by modified time. I want the most recently modified item to be sorted to the bottom for that day. Currently everythign is sorted correctly by date and priority, but for some reason when I modify an item it doesn't move to the bottom of the queue for that day, instead it just moves to the middle. Any ideas why this may be happening? I checked the modified times and they are correct. Does assigned date have a time value stored as well? any help would be appreciated.

  • Author

Does indexing effect it at all? I noticed that my modified time field is indexed. I don't understand why it would sort would have the following order with my order. I checked the fields and it is sorting 3:23PM, 9:42AM, 2:21PM doesn't make any sense at all!

Does it not look at the AM and PM?!

Indexing shouldn't be a problem at all.

Is it possible that you post a cloned copy of your files. It may be a relationship problem or that the field in the portal doesn't come from this same relationship.

  • Author

I am working remotely so I don't have access to save a copy of it, but I pretty much just took this database and added a bunch of customized things to it.

http://www.bigabytes.net/ITJournalLite/index.php

All the relationships should be the same, except for him he just set it to that open tickets sourts by ticket number, while I'm sorting by priority, modified date, and modified time. Thanks for your help!

Oh Oh....may be

You defined the sort into the portal box as we did when in version 6.

Try opening the Relationship Graph view, double click into the square in between the tables and use the Sort options there to see if this changes.

At least check for both settings to see if they both match and if something is wrong in there.

  • Author

Thanks a lot that fixed it, didn't know I could sort in the tables themselves. Thanks a lot!!

Create an account or sign in to comment

https://fmforums.com/topic/29840-sorting-a-portal/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.