Results 1 to 5 of 5

Thread: Custom Query Builder Select specific fields

  1. #1
    Senior Member
    Join Date
    Oct 2019
    Posts
    498

    Custom Query Builder Select specific fields

    In the Custom Query Builder you can select all fields of the table for the search, my question is, can you also make a setting so that only certain fields appear in the selection?
    Greetings Olaf

  2. #2
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    7,359
    Blog Entries
    22
    See doc.
    https://www.lianja.com/doc/index.php/QueryBuilder

    You can specify the columns parameter.
    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
    Oct 2019
    Posts
    498
    Thanks Barry, got it so far and was able to understand it too. However, I still have the problem that when the search function (magnifying glass) is switched on in the page/section, I have no way of specifying that only certain columns should be displayed. If I do the query builder via a function Lianja.showQueryBuilder(...) this works, but how can I redirect this result into a browse()? I hope you understand what i mean. With the command lianja.showQueryBuilder() I set the filter and get back the corresponding result of my query. I would now like to see this result then. Thank you and greetings Olaf
    Name:  Bild1.jpg
Views: 81
Size:  71.9 KB

  4. #4
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    7,359
    Blog Entries
    22
    Hi Olaf

    I will add a new section attribute where you can specify a comma separated list of columns for the querybuilder.
    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

  5. #5
    Senior Member
    Join Date
    Oct 2019
    Posts
    498
    Thanks Barry, really great! Greetings Olaf

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