• Mikael Eriksson
    January 18, 2017 at 7:38 am #3506



    The table.search() function allows the caller to specify either a single column or that the search should be globally in the table.

    We want to be able to search in some columns but not all. An addition where several columns can be specified would be great 🙂 Until such a thing occurs would you have some suggestion to do it with the control? (Otherwise it seems we need to do  the filtering ourself on the original list and then let the table show an already filtered list.)



    /Mikael E


    SPARK Support
    January 23, 2017 at 3:53 pm #3540

    Hi Mikael,

    The column being searched needs to be specified. Please see the documentation:


    The approach you have outlined for displaying a filtered table is most likely the best method.


    Stephen P.

    Mikael Eriksson
    March 9, 2017 at 6:34 am #3961


    The current documentation mentions that col could be a function:

    When the type is “number” this is the column to be searched or null for all columns. When type is “string” this is the property name in the table to be searched. When the type is “function” this is the comparator function to use for the search. Note that when the type is function, the other parameters are ignored.
    Where can I find information on how to use such a function?

    SPARK Support
    March 21, 2017 at 3:54 pm #4050

    Hi Mikael,

    The search method passes the list item into the function.  To use the function, compare a property of the list to some logic, and the return the list item to be pushed to the temporary filtered list.

    Lets say that I have a Business Object of myComplexType with properties str1, str2, int1 and dec1 (String, String, Integer, Decimal).  I can use this function to look for integer values matching greater than 14:

    function mySearch(listItem) {

    if(listItem.int1 > 14){

    return listItem;}


    To filter multiple columns, modify the logic for which conditions should be returned:

    function mySearch2(listItem) {

    if(listItem.int1 > 14 && listItem.dec1 < 18.0){

    return listItem;}



    Stephen P.

    Stephan Janssen
    April 25, 2017 at 4:14 am #4215

    Hi Stephen,

    I’ve been trying to get this to work with a function in “Inline Javascript” of a coach view, but I can’t get it to call the function.

    Can you give some more pointers on how to actually make this work?



    Mikael Eriksson
    April 25, 2017 at 5:34 am #4216

    Just giving the function as the first parameter to the search function in the table should work.


    function mySearchFunction(row) {

    if (shouldShowRow(row)) return row;

    return null;



    var myTable = page.ui.get(“tabletosearch”);



Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic.

Start typing and press Enter to search