Announcement

Collapse
No announcement yet.

sort by calculated column

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • sort by calculated column

    How to sort records by a calculated column.

    e.g {score} s a user defined feld not found in db.

    OnLoadRecord:

    $check_sql = "SELECT SUM(mark_index) from tbl_course WHERE student_id = '{student_id}'";
    sc_lookup(rs, $check_sql);

    $temp = {rs[0][0]};

    {score} = round($temp / 100);


    Now how to sort by this fied?

  • #2
    If you need to be able to sort upon a calculated field then try to do this as a new field within the sql statement. Calculated fields are created on a onload event. So they exist only for a short time. That's why there's no sort as this afaik is done by altering the order by on the sql select. Perhaps a bit cryptic but I hope you get the idea.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment

    Working...
    X