2. PHPRunner General questions
  3. [SOLVED]  Ordering Details on Master List Page
This topic is locked
[SOLVED]

 Ordering Details on Master List Page

 		8/28/2010 3:34:18 PM
PHPRunner General questions
S
 Supratec author

Hi everybody,
I have created a detail->master links where the Details are 7 for only 1 Master. On my case the details are the week days and master is a Week. But when the Master is listed the Details aren't in properly order:
Thursday

Monday

Sunday

Wednesday

Tuesday

Friday

Saturday
I have already changed the order on the HTM code inside {BEGIN semanastandard_dtable_column} tags from the respective Master List page. The semanastandar is the MAster table. It works perfect, but returns to the same state after next build process.

How may I fix this to be permanent?

Thanks

Regards
E
 		electromotive 8/29/2010

There are a few ways to do this.
You could add a day_of_week smallint field to your detail record putting the records in the particular order you want, ie., 0-6 = Mon-Sun or Sun-Sat as the case may be, then use the "order by" in your sql.
Or as an alternative, substitute your day_text field with a day_number. Then use a lookup to convert the day_number into day_text for display.
S
 		Supratec author 9/1/2010

Thanks indeed,

I have solved putting a number in the table detail name:

2_Thursday

1_Monday

7_Sunday

3_Wednesday

4_Tuesday

5_Friday

6_Saturday
And this way the sort becomes as I want.

Thanks

Regards