Skip to main content
Question

Filter Table Records on Exact Form

  • April 5, 2017
  • 0 replies
  • 25 views
Forum|alt.badge.img+8
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!

      This topic has been closed for replies.

      • EricJHansen
      • Registered
      • April 5, 2017
      What type of field is fid 46?
      Forum|alt.badge.img+8
      • HansHamm
      • Author
      • Registered
      • April 5, 2017
      It is a text-multiple choice. I have tried: HAS, CT, EX, Double Quotes etc... and cannot get it to work
      Forum|alt.badge.img+8
      • HansHamm
      • Author
      • Registered
      • April 6, 2017
      Finally figured it out... the issue was within the quotes. 
      • ArchiveUser
      • Registered
      • April 6, 2017
      Would you share the solution?  Quotes are definitely touchy if not exact.
      Forum|alt.badge.img+8
      • HansHamm
      • Author
      • Registered
      • April 6, 2017
      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

      • ArchiveUser
      • Registered
      • April 6, 2017
      Like I said, exact.  I appreciate the help.

      Cheers!
      Terms & ConditionsAccessibility statement