Forum Discussion
HansHamm
8 years agoQrew Assistant Captain
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
~=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