12345678910111213141516171819202122232425262728 |
- var input = JSON.parse(decodeURIComponent(INPUT));
- var search = function(){
- var rtn = null;
- var mqlStr = "";
- try{
-
- var compiled = _.template("SELECT <%= bucket%><%= key%>.time('<%= time%>')<%= words%><%= limit%> FROM <%= className%> where id='<%= id%>'");
-
- mqlStr = compiled({
- bucket: input.field,
- key: input.file?"['"+input.file+"']":'',
- time: input.time.join("','"),
- className: input.class,
- id: input.id,
- words: input.words.length>0?".find('"+input.words.join("','")+"')":'',
- limit: '.limit(2000)'
- });
- log.debug(mqlStr)
- rtn = {result:odb.mql(mqlStr).data[0][input.field],mql:mqlStr};
-
- }catch(err){
- return {result:err,mql:mqlStr};
- }
- return rtn;
- }
- OUTPUT = search();
|