2. PHPRunner General questions
  3. Moving Records Up and Down
This topic is locked

Moving Records Up and Down

 		6/14/2010 11:51:02 AM
PHPRunner General questions
P
 projectpop author

Hi, i am using the latest version of PHPRunner.
Is there any way that i can move records up and down directly from the list page?
For example I have 3 record.
id | name

1 | product 1

2 | product 2

3 | product 3
How can I move product 3 up to 2nd row? That means the table will be like this..
id | name

1 | product 1

2 | product 3

3 | product 2
Is it possible to do this directly from list page?
Thanks
lewisgr 6/14/2010



Hi, i am using the latest version of PHPRunner.
Is there any way that i can move records up and down directly from the list page?
For example I have 3 record.
id | name

1 | product 1

2 | product 2

3 | product 3
How can I move product 3 up to 2nd row? That means the table will be like this..
id | name

1 | product 1

2 | product 3

3 | product 2
Is it possible to do this directly from list page?
Thanks


I do something like that. I make the list page incline edit and added and new field in my table called orderedby. Then in the PHPrunner query designer I sort by orderedby with it being number 1 in the sort order. Add the orderedby to the list page and publish. Just change the number in the application as needed.
P
 		projectpop author 6/14/2010

I do something like that. I make the list page incline edit and added and new field in my table called orderedby. Then in the PHPrunner query designer I sort by orderedby with it being number 1 in the sort order. Add the orderedby to the list page and publish. Just change the number in the application as needed.


Hi, yes I am aware of this method (i'm also using this method currently) but I am wondering if I can do this by using arrows on each list, so if I click UP on record id 3, it will become record id 2 and so on... (like in CMSes)..
J
 		Jane 6/15/2010

Hi,
in general it's possible. Create new field in the database, set up this field as custom on the "View as" settings dialog and apply your custom code on this dialog.

Unfortunately we don't have a ready to go solution for this.