Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

Foreign Key ordering not functioning 27 Mar 2014 13:54 #12364

I'm attempting to order items in Table 1 based on a foreign key in Table 2, which is a field selected in the items in Table 1.

The items appear to move around fine, and the database is being updated with new ordering, but refreshing the page in the backend is reordering the items again without the user moving them around. I'm not sure, but it seems like it's automatically reordering the database on page refresh based on some other sort of sorting, but I'm not sure why.

Any ideas if this is a bug? I'm fairly sure this is set up correctly in my project.

- Andrew

Please Log in or Create an account to join the conversation.

Foreign Key ordering not functioning 28 Mar 2014 12:51 #12373

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 986
Did you setted this FK as group in the ordering wizard ?

Because this could be your problem.
When you define a group, it separate the items in differents ordering groups.

Are the items correctly ordered within the same FK value ?
Can you provide the PTL ? (Project Table Layout), so I can check manually ...
Coding is now a piece of cake

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.190 seconds

This is what you call a component builder. I was able to master using this in a very short time and the resulting component works like a charm. Not just a basic component builder but a fully working component builder with forms fields tables all ready to go. You can make the list and item views to display in the front and back end. Also there is a great forum just starting to evolve and I'm sure this will grow very rapidly when you all realise how good this tool is.
Kevin (JED)

         

Get Started