Forum Discussion

HansHamm's avatar
HansHamm
Qrew Assistant Captain
9 years ago

Filter Table Records on Exact Form

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!

6 Replies

Sort By
  • HansHamm's avatar
    HansHamm
    Qrew Assistant Captain
    9 years ago
    It is a text-multiple choice. I have tried: HAS, CT, EX, Double Quotes etc... and cannot get it to work
  • HansHamm's avatar
    HansHamm
    Qrew Assistant Captain
    9 years ago
    Finally figured it out... the issue was within the quotes. 
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    9 years ago
    Would you share the solution?  Quotes are definitely touchy if not exact.
  • HansHamm's avatar
    HansHamm
    Qrew Assistant Captain
    9 years ago
    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