Filter Table Records on Exact Form | Discussions

Expand all | Collapse all

Filter Table Records on Exact Form

  • 1.  Filter Table Records on Exact Form

    Posted 04-05-2017 13:17
    On my exact form I have the following, which works 100%, if I want all records:
    Associates Itinerary - CarRental

    ~=qdb.GetURL("bmi6cp5q4", "API_GenResultsTable^query={'Related Reset'.EX.'"+ field["Record ID#"]+"'}&clist=80.46.28.29.30&options=nvw.ned.phd.nfg.sortorder-A^slist=80");~

    But when I try to filter column 46 to only give me the records that are not "".... I either get no records or all the records.

    There is something that I am not understanding on the proper way to filter out unwanted items.

    Thanks!



  • 2.  RE: Filter Table Records on Exact Form

    Bronze
    Contributor
    Posted 04-05-2017 14:11
    What type of field is fid 46?


  • 3.  RE: Filter Table Records on Exact Form

    Posted 04-05-2017 14:17
    It is a text-multiple choice. I have tried: HAS, CT, EX, Double Quotes etc... and cannot get it to work


  • 4.  RE: Filter Table Records on Exact Form

    Posted 04-05-2017 20:29
    Finally figured it out... the issue was within the quotes. 


  • 5.  RE: Filter Table Records on Exact Form

    Top
    Contributor
    Posted 04-05-2017 20:31
    Would you share the solution?  Quotes are definitely touchy if not exact.


  • 6.  RE: Filter Table Records on Exact Form

    Posted 04-05-2017 20:40
    Neil what I had was:
    ~=qdb.GetURL("bmi6cp5q4", "API_GenResultsTable^query={'Related Reset'.EX.'"+ field["Record ID#"]+"'}AND{�46�.CT.�National�}^clist=80.46.28.29.30^options=nvw.ned.phd.nfg.sortorder-
    A^slist=80");~

    After reading umpteen million posts... it finally dawned on me that it should be
    ~=qdb.GetURL("bmi6cp5q4", "API_GenResultsTable^query=({'Related Reset'.EX.'"+ field["Record ID#"]+"'})AND{'46'.CT. 'National'}^clist=80.46.28.29.30^options=nvw.ned.phd.nfg.sortorder-A^slist=80");~

    If you look VERY CLOSELY I had the MS Word version of a single quote which would not work. When I re-typed the whole thing in NotePad while reading a post that is when I noticed the difference. If you are having issues like that go back and put it into Notepad and retype all of the quotes.
    HTH



  • 7.  RE: Filter Table Records on Exact Form

    Top
    Contributor
    Posted 04-05-2017 21:00
    Like I said, exact.  I appreciate the help.

    Cheers!