locked
Filtering Drop Down Order RRS feed

  • Question

  • I have a Search Data Screen with a Customer Name parameter used to search for Invoices. When I go to the filter I can select a customer and all their Invoices will show up. However, the Customer Names in the Drop Down List are listed as they are in the database not alphabetically. How can override the sorting of the Drop Down List? I do not see where I can edit this query. I can see how I can edit the query of the results, but not the actual Drop Down Lists values used for the filtering.

    Thanks!



    • Edited by CTRLIT Tuesday, December 10, 2013 7:54 PM
    Tuesday, December 10, 2013 7:50 PM

Answers

  • You can to create a Query to sort the name of all your customers:

    Then add the sort criteria:

    After that add the Query in your Screen:

    In your Autocompletebox you will find "Choices", just select the added Query:

    I hope this help you. (Sorry for my english, is not my first language)

    • Edited by NESTicle 8Bit Tuesday, December 10, 2013 8:19 PM
    • Marked as answer by CTRLIT Wednesday, December 11, 2013 9:19 PM
    Tuesday, December 10, 2013 8:18 PM

All replies

  • You can to create a Query to sort the name of all your customers:

    Then add the sort criteria:

    After that add the Query in your Screen:

    In your Autocompletebox you will find "Choices", just select the added Query:

    I hope this help you. (Sorry for my english, is not my first language)

    • Edited by NESTicle 8Bit Tuesday, December 10, 2013 8:19 PM
    • Marked as answer by CTRLIT Wednesday, December 11, 2013 9:19 PM
    Tuesday, December 10, 2013 8:18 PM
  • Do you know how I would change the columns displayed? It seems to automatically select which columns to display in the drop down list, but if I wanted to have more control over the display. Either changing the column or even combining column values would be cool.

    Thanks!

    Wednesday, December 11, 2013 9:19 PM
  • Absolutely yes, u can do anything with Lightswitch :)

    In the screen, you need to reveal your Combobox

    then you can do anything you want, like this.


    And u see the items like this:

    You can play with the controls, if you want something let me know

    Thursday, December 12, 2013 1:36 AM