Results 1 to 4 of 4

Thread: How to change the index in a Web App

  1. #1
    Senior Member
    Join Date
    Feb 2012
    Location
    Germany, near Jena and Weimar
    Posts
    213

    How to change the index in a Web App

    I have a web app with personal data in a canvas section and
    I want to change the sorting while working
    (e.g. from Index FamilyName+Prenome to City+FamilyName.)
    What could a click event look like?
    Thanks George

  2. #2
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    2,150
    Hi George,

    By changing the Orderby of the section, Lianja will (IIRC) use an existing index, or if one is not present will create an index). I suspect a refresh of the section might be needed.

    Note that for grids, you can use column sorting.

    Hank

  3. #3
    Senior Member
    Join Date
    Feb 2012
    Location
    Germany, near Jena and Weimar
    Posts
    213
    Hi Hank,

    thanks for your answer!
    How is the syntax for OrderBy (f.e. field names separated by comma, or an expression, or name of an existing index) ?

    My Web App consists of a tab view with 2 tabs. Have I to write in the OrderBy of both tabs?

    Georg

  4. #4
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    2,150
    Hi Georg,

    Yes: it's not like VFP where the "alias" would be available to both sections.

    While the table name may be the same, think of the "table" as being a "token" that points to the backend for DML (data manipulation language) operations. If you look at the JSON that shuttles back and forth (press F12 in the browser, and fiddle with the debugger to find it), you will see that is exactly how it works.

    Hank

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us