Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 23

Thread: Changing GUI records programatically in web

  1. #11
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    7,360
    Blog Entries
    22
    Unless of course you have an order by on the section. In which case it will not follow a newly added record. It will follow the ordinal position in the order.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  2. #12
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    7,360
    Blog Entries
    22
    Simon,

    In a previous post in this thread I asked you to remove the order and set the "name" field as the "Search field" on your section.

    This causes the records to be ordered by "name" and when adding a record the "active record" will remain on the newly added record.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  3. #13
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    7,360
    Blog Entries
    22
    This all works as expected in 7.2Beta38.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  4. #14
    Senior Member
    Join Date
    Jan 2014
    Posts
    369
    Hi Barry

    Downloaded 7.2 Beta 38.

    That works great in development/runtime mode but cannot recreate your suggestion in web. Records are always displayed in unordered table record order.

    As before, we did :

    order by name removed from all sections. Same database and table in all sections.

    Name field (cust.name) set as search field - records displayed in table order in web

    Name field set as default search field - records displayed in table order in web

    Name field (cust.name) set as search field AND default search field - records displayed in table order in web


    What have we missed? Is the fact that we have both form and canvas sections in the same app relevant?

    Not sure what to do next with this one.

    Cheers


    Simon

  5. #15
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    7,360
    Blog Entries
    22
    Simon,

    it works perfectly fine for me.

    I would suggest you create a simple app with a form section and specify a search field and try it.

    If you want me to review your application and fix any logic errors that I find please email me.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  6. #16
    Senior Member
    Join Date
    Jan 2014
    Posts
    369
    Hi Barry

    Good idea.

    Created a new app and added one form section with some fields. Only used the GUI wizard. There is no code in this new app.

    Specified the name field as both search and/or default search (don't understand the difference) and the behaviour is as before.

    Tried with and without specifying the default search option in the wizard - same unordered behaviour.

    Replaced with a canvas section - same behaviour.

    Works great in dev (records displayed in name order) but in web the records are again always in unordered/table order.

    **********************************************

    Maybe its the data.

    Deleted the test app & remade it using the southwind database, table = customers. Form section.

    The southwind customer table is sorted on Customer ID so made the search field contact name.

    Ran the app in dev - works perfectly.

    Ran the app in web - same issue - table displayed in unordered/table order.

    How are you getting this to work?



    Simon

  7. #17
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    7,360
    Blog Entries
    22
    Simon,

    check the search field on the customerid formitem. Are you using the GUI to do this or what exactly.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  8. #18
    Senior Member
    Join Date
    Jan 2014
    Posts
    369
    The only odd thing we have noticed

    In our normal app, when we log in as admin (no App Center role level security) the instant search box works fine, displaying the appropriate records. The records are still displayed in table order but when exiting the instant search box, the correct "name" order record is displayed briefly before going back to table order.

    However, when we log in using a normal user (ie non admin) (example of filter from App Center role level security is "company_no = 31") the instant search box never works, despite there being plenty of records that should show up. It always returns "no records available"


    The instant search in the simple app with no code using our data never works, whether logged in as admin or some other user.

    Don't know if that is relevant

    Cheers



    Simon

  9. #19
    Senior Member
    Join Date
    Jan 2014
    Posts
    369
    Hi Barry

    Yes, only using the GUI

    Please see attached

    Cheers


    Simon
    Attached Images Attached Images  

  10. #20
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    7,360
    Blog Entries
    22
    Simon,

    I can’t debug your application on the forums.

    Please just follow what I’m asking you to do rather than jump all over.

    if you cannot get a simple app to work as I advised, package it up using southwind and attach to a ticket.

    Does the the example_webapp1 work on your machine? If it does not then you have messed up the distribution or have a programming error in your logic.
    Last edited by barrymavin; 2022-05-19 at 09:32.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

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