• Rest service with Search

    By Tenzing Sangmo 1 decade ago
        <p>
            When Search property is used in the Rest Service(viewItemFileService), the Dojo Data grid shows the documents which matches the criteria and also some empty rows,as shown in the figure. how to eliminate these empty rows?</p>
        <p>
            <img alt="" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAIgAAACGCAIAAACJ0lV1AAAD0ElEQVR4nO2dTW7bMBSE56i+UpZadqeFtjlGljlBW7QwiiIIGrTpn7MQwD6TlCpL9BM5ng8DgaJI+jGTsezAdXFiYei7vUsoCf6KKsEfFoa+27uEkvAYQwZ+szD03d4llAS/RJXgJwtD30U9MCxZYeGwi0auBq+8AMi2y658JfCDhaHvoh4AaXsMUNpOx9tT2xNSWLT8GHznxT6V2c7tDbvglcALC0PfRT1AZnehc74RyC6VXbks+MYLkNld6FzSmJqVXbkseGZh6LuoB8jsznaOmZi5NDU4unQN8GSwEX5awMJh2ZGh56JHvCo11BDAVwOAbHs76WqhJ22sY+i7LdPL7nc7+GIAkLbHX+e0nY63p7YnZCL7WFML3jg4GuxTme3c3rALTo3MDlvO0Her51YIPhuAs9Ooc74RyC6VrpwdmS3gNsEnA3B2GnUuaUzN+u+AqUdfztB3W6bXBj4agLPTtHPMxMylqcHRJTs3nViKqVKbAB82AGyaXpah76Ke0e/Qdq9oE3i/FmD9XB9GY0I76reXIqYW8aT2H+5yhr6LesYfqD2mVy9tuNFYwC/CPo/Zp7KQjHRYdmI03YfGbokzDH0X9WRfeqxr+LPpFWrl2Nff9kV5IL2UnWgHu7H+nXZtsL3z37sAkYfHGLbE3N3dHY9HjuPuBRQ84vDuKFUoHmMeH+53r6GgeIwhE48xSozkIR5jlBjJQ7Exp9NpqlG5solppfhUZ8a060pWTRf/z5iZf9q8e5VLFCUmKr6tvRxuJDEtbofHmPQe0/R2eIxJ1fR2eIyZScyh9XsMq1r8PeMxZv6df1txOTAZQyYeY/S3MslDPMawJWbcD8dx9wIKHvH88ipVKB5jHh/ud6+hoHiMIROPMUqM5CEeY5QYyUM8xigxkod4jFFiJA/xGKPESB46MwbAVKN+pYlpejvNFHpr4jFG9xjJQzzGKDGSh3iMYUvMuB+O4+4FFDzi0v+fUfjAY8zjw/3eJZSExxgyeIxRYoQHPMYoMcIDHmOUGOEBjzFKjPCAxxglRnhwZgyAqUb9pIlpejvNFHpr8Bije4zwgMcYJUZ4wGMMW2LG/XAcdy+g4JHn40tk4jEmfIKJQzzGkInHGCVG8hCPMUqM5CEeY5QYyUM8xigxkod4jFFiJA/pmzEqVTOF3pp4jNE9RvIQjzFKjOQhHmPYErP7V0AUPO5eQMEjz8eXyOAxJnyCiQMeY8jgMUaJER7wGKPECA94jFFihAc8xigxwgMeY5QY4YG+GaNSmin01uAxRvcY4QGPMUqM8IDHGLLEvAHHbTJu3RwZlgAAAABJRU5ErkJggg=="/></p>
    </div>
    

  • Need more information...

    By Stephen Auriemma 1 decade ago

    I would need to know more about the blank entries being returned. It appears that the entries some how meet the criteria of the search but, do not contain the fields you are trying to display. Try the same search query from a view in the Notes UI. Then change you query to filter out these entries.

    IS PRESENT    Requires that the field before it must be non-blank. There should be spaces between 'IS PRESENT' and words surrounding it. This operator can be used to find all documents that do (or do not) contain a value in a particular field.
        Example
        [Subject] IS PRESENT
        Finds documents whose Subject field is non-blank.
     

    • Re-Rest Service with Search

      By Tenzing Sangmo 1 decade ago

      Hi Stephen,

         I tried with the "IS PRESENT" filter query. But the result is  same. Actually, in the backend view, there are 3 documents which has value "abc", "def" and "xyz" for the field "Name". There is only 1 field in the form. Using the Rest service without any Search properties, the documents in  Dojo Datagrid is displayed as:

       

      And if "abc" is the Search keyword, the result is shown as below in the Datagrid.

      I have check In the NotesUI, the document with the field value "abc" only is shown. 

      Is it the default behaviour of the Rest service and Dojo data grid?

       

       

       

      • Workaround

        By Tenzing Sangmo 1 decade ago

        Hi,

          I found a workaround for this problem. When Search property is used in the Rest "viewJsonService" Service, the Dojo Data grid  shows only those documents which matches the criteria. 

        Thanks