Filter Table Records on Exact Form

  • 0
  • 2
  • Question
  • Updated 2 years ago
  • Answered
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!

Photo of Hans Hamm

Hans Hamm

  • 670 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 2
What type of field is fid 46?
Photo of Hans Hamm

Hans Hamm

  • 670 Points 500 badge 2x thumb
It is a text-multiple choice. I have tried: HAS, CT, EX, Double Quotes etc... and cannot get it to work
Photo of Hans Hamm

Hans Hamm

  • 670 Points 500 badge 2x thumb
Finally figured it out... the issue was within the quotes. 
Photo of Neil Shepard

Neil Shepard

  • 1,248 Points 1k badge 2x thumb
Would you share the solution?  Quotes are definitely touchy if not exact.
Photo of Hans Hamm

Hans Hamm

  • 670 Points 500 badge 2x thumb
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

Photo of Neil Shepard

Neil Shepard

  • 1,248 Points 1k badge 2x thumb
Like I said, exact.  I appreciate the help.

Cheers!