Discussions

Expand all | Collapse all

How can I minimize my search to just specific tables?

  • 1.  How can I minimize my search to just specific tables?

    Posted 09-09-2016 04:13
    We have a ticketing app that is linked to a document  library app. I created a search button which when we select a product on  the ticket it will automatically search the related  document on the documentation library which has many tables.  

    Our problem  is that, it will search  on all  the tables under the document library app. What we want is to search only on the Product, TroubleShooting, and Course table on  document library app.  

    I attached a screenshot on that is happening when i click the search button.

    Below is my  syntax:



    var text customer =(If([Product Name]<>""

    ,URLEncode ("+OR+&")&[Product Name]));





    If([Product Name]="E2"

    or [Product Name]="E2E"

    or [Product Name]="Site Manager"

    or [Product Name]="Ultrasite"

    ,"https://emersonclimate-retailsolutions.quickbase.com/db/bk22afrvs?act=QuickSearch2&srchtxt="&[Concer..."

    ,"https://emersonclimate-retailsolutions.quickbase.com/db/bk22afrvs?act=QuickSearch2&srchtxt="&[Produc... Name]&"&srchWhich=_all")



  • 2.  RE: How can I minimize my search to just specific tables?

    Posted 03-31-2018 19:55
    Without building a custom 'search' code page to only canvas those three tables, I think the best native option is to add 3 different 'search widgets' to your dashboard.   Then just search those tables individually.

    Not ideal, but maybe an easy work around for now.


    Matthew Neil - Product Specialistmneil@mcftech.com Phone: 440-201-6050 ext. 476" width="300px">


  • 3.  RE: How can I minimize my search to just specific tables?

    Posted 03-31-2018 20:01
    I'm wondering if Mary actually waited 2 years to get that answer.


  • 4.  RE: How can I minimize my search to just specific tables?

    Posted 03-31-2018 20:07
    #KnowledgeBase