Being fond of the intuitive Google, I've made a $$return field, that translates
a Google style search query into Notes style. This means you don't have to put
operators like "AND" or "NOT" in the query. "AND" is automatically added, a
hyphen can be used for "NOT". "OR" is the same in Notes as in Google. If anyone
can do this in Javascript, I'd be more than happy.
Here is the code:
REM "this code works for maximum of 2 pairs of quotation marks, though you can
extend using more subsets";
REM "hyphen can be part of a word, or can be used as NOT placed at the
beginning of a search string, before a quotation mark and before a searchterm";
REM "the hyphens that are not part of a word-combination are replaced by NOT
and before and after quotation marks # (pound-keys) are placed";
t00:=@ReplaceSubstring(t000;
"- " :" -" : "not\""
: " \"" :"\" " ;
"not " :" not " : "not \"" :
"#\"" :"\"#"
);
t0:=@Explode(t00;"#");
REM "the query is split into elements, where everything between quotation marks
is a seperate element";
t1:=@Subset(t0;1);
t2:=@Subset(@Subset(t0;2);-1);
t3:=@Subset(@Subset(t0;3);-1);
t4:=@Subset(@Subset(t0;4);-1);
t5:=@Subset(@Subset(t0;5);-1);
REM "Replace the space characters in an element that starts with a quotation
mark by %20";
tt1:=@If(@Begins(t1;"\"")=1;@ReplaceSubstring(t1;" ";"%20");t1);
tt2:=@If(@Begins(t2;"\"")=1;@ReplaceSubstring(t2;" ";"%20");t2);
tt3:=@If(@Begins(t3;"\"")=1;@ReplaceSubstring(t3;" ";"%20");t3);
tt4:=@If(@Begins(t4;"\"")=1;@ReplaceSubstring(t4;" ";"%20");t4);
tt5:=@If(@Begins(t5;"\"")=1;@ReplaceSubstring(t5;" ";"%20");t5);
REM "the elements are combined again with spaces in between them";
xt1:=@Trim(@Implode(@Unique(tt1:tt2:tt3:tt4:tt5:tt5);" "));
REM "replaces spaces with AND and make corrections made for NOT and OR in
combination with spaces";
xt2:=@ReplaceSubstring(xt1;
" & " :" or " : "not " : " contains ": " " ;
"%20%26%20" :"%20or%20": "not%20": "%20contains%20" : "%20and%20");
The search tips for users to use with this way of queriying. It is quite the
same as the google syntax:
search tips:
- "AND" is automatically placed between your search terms
- use a hyphen "-" to exclude words from your search
- use asterix "*" as wildcard, e.g. 'codesto*'
- use quotation marks for a combination of words e.g. "jake howlett"
Dear all,
Being fond of the intuitive Google, I've made a $$return field, that translates a Google style search query into Notes style. This means you don't have to put operators like "AND" or "NOT" in the query. "AND" is automatically added, a hyphen can be used for "NOT". "OR" is the same in Notes as in Google. If anyone can do this in Javascript, I'd be more than happy.
Here is the code:
REM "this code works for maximum of 2 pairs of quotation marks, though you can extend using more subsets"; REM "hyphen can be part of a word, or can be used as NOT placed at the beginning of a search string, before a quotation mark and before a searchterm";
t0000:=@LowerCase(@Trim(Your_Query_Field)); t000:=@If(@Begins(t0000;"-")=1;" "+t0000;t0000);
REM "the hyphens that are not part of a word-combination are replaced by NOT and before and after quotation marks # (pound-keys) are placed"; t00:=@ReplaceSubstring(t000; "- " :" -" : "not\"" : " \"" :"\" " ; "not " :" not " : "not \"" : "#\"" :"\"#" ); t0:=@Explode(t00;"#");
REM "the query is split into elements, where everything between quotation marks is a seperate element"; t1:=@Subset(t0;1); t2:=@Subset(@Subset(t0;2);-1); t3:=@Subset(@Subset(t0;3);-1); t4:=@Subset(@Subset(t0;4);-1); t5:=@Subset(@Subset(t0;5);-1);
REM "Replace the space characters in an element that starts with a quotation mark by %20"; tt1:=@If(@Begins(t1;"\"")=1;@ReplaceSubstring(t1;" ";"%20");t1); tt2:=@If(@Begins(t2;"\"")=1;@ReplaceSubstring(t2;" ";"%20");t2); tt3:=@If(@Begins(t3;"\"")=1;@ReplaceSubstring(t3;" ";"%20");t3); tt4:=@If(@Begins(t4;"\"")=1;@ReplaceSubstring(t4;" ";"%20");t4); tt5:=@If(@Begins(t5;"\"")=1;@ReplaceSubstring(t5;" ";"%20");t5);
REM "the elements are combined again with spaces in between them"; xt1:=@Trim(@Implode(@Unique(tt1:tt2:tt3:tt4:tt5:tt5);" "));
REM "replaces spaces with AND and make corrections made for NOT and OR in combination with spaces"; xt2:=@ReplaceSubstring(xt1; " & " :" or " : "not " : " contains ": " " ; "%20%26%20" :"%20or%20": "not%20": "%20contains%20" : "%20and%20");
"[/" + Your_Database + "/Your_Search_View?SearchView&Query=" + xt2 + "]"
The search tips for users to use with this way of queriying. It is quite the same as the google syntax:
search tips: - "AND" is automatically placed between your search terms - use a hyphen "-" to exclude words from your search - use asterix "*" as wildcard, e.g. 'codesto*' - use quotation marks for a combination of words e.g. "jake howlett"