Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Refresh Navpanel

  1. #1
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,862

    Refresh Navpanel

    Hi all,
    when I use the "Custom query", how can I update the Navigation Panel?

    Can I know the filter set on the Query builder?

    thanks
    Fabio

  2. #2
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,739
    Hi Fabio,

    Can you explain what you are doing in the UI. What “Custom Query” are you referring to?

    There is a Query Builder and a Query Picker. These are shown in a variety of places.
    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. #3
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,862
    Sorry Barry,
    Query Builder ..Name:  2018-10-22 11_12_30-Window.jpg
Views: 22
Size:  36.1 KB

    I've prepared the image but I've forget to add as attachment.. :-)

  4. #4
    Lianja MVP
    Join Date
    Dec 2012
    Location
    Croatia, Zagreb
    Posts
    1,099
    Hi Fabio,

    Try this after completing custom query:

    Code:
    oNav = Lianja.get("YourPage").navigationpanel
    oNav.rowsource="select ... from yourtable"
    ...and navigation panel will refresh itself.

    See: https://www.lianja.com/community/sho...ll=1#post13216
    Last edited by josipradnik; 2018-10-22 at 06:28.

  5. #5
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,862
    Thanks Josip,
    you're right, but the problem is to know the filter applied on the Query builder..

  6. #6
    Lianja MVP
    Join Date
    Dec 2012
    Location
    Croatia, Zagreb
    Posts
    1,099
    Did you study this? For "filter"

    https://www.lianja.com/doc/index.php/QueryBuilder
    Last edited by josipradnik; 2018-10-22 at 06:36.

  7. #7
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,739
    Clicking that icon will activate the query builder against the search field section or the first section if there is no search field. It has nothing to do with the navigation panel which belongs to the page containing the sections.
    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. #8
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,862
    Yes, but the "filter" is passed as a parameters.. not a property to read

    Or I wrong?

  9. #9
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,739
    Quote Originally Posted by josipradnik View Post
    Did you study this? For "filter"

    https://www.lianja.com/doc/index.php/QueryBuilder
    You can probably use the onselect parameter if you activate this manually in your own custom query code.
    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

  10. #10
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,739
    Quote Originally Posted by phabio View Post
    Yes, but the "filter" is passed as a parameters.. not a property to read

    Or I wrong?
    onselect is what you need to look at.
    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

Page 1 of 2 12 LastLast

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