Quote from Vadim on March 6, 2020, 2:57 pm

Good day!

I was asked, and I became interested. :)

How to make a composite query using the NeoBookDB (NeoDB) plugin.
I mean the ability to search in already found.

I did this using the NeoBookDBpro (NeoDBpro) plugin:

:InFound
If "[CheckBoxInFound]" "=" ""
   dbpQuery "NB" "Commands" "fSOURCE LIKE [#34]%[sourceX]%[#34] AND fTEAM LIKE [#34]%[teamX]%[#34] AND fDESCRIPTION LIKE [#34]%[descriptionX]%[#34]"
Else
    If "[InFound]" "=" ""
       dbpQuery "NB" "Commands" "fSOURCE LIKE [#34]%[sourceX]%[#34] AND fTEAM LIKE [#34]%[teamX]%[#34] AND fDESCRIPTION LIKE [#34]%[descriptionX]%[#34]"
       SetVar "[InFound]" "fSOURCE LIKE [#34]%[sourceX]%[#34] AND fTEAM LIKE [#34]%[teamX]%[#34] AND fDESCRIPTION LIKE [#34]%[descriptionX]%[#34]"
    Else
       dbpQuery "NB" "Commands" "[InFound] AND fSOURCE LIKE [#34]%[sourceX]%[#34] AND fTEAM LIKE [#34]%[teamX]%[#34] AND fDESCRIPTION LIKE [#34]%[descriptionX]%[#34]"
       SetVar "[InFound]" "[InFound] AND fSOURCE LIKE [#34]%[sourceX]%[#34] AND fTEAM LIKE [#34]%[teamX]%[#34] AND fDESCRIPTION LIKE [#34]%[descriptionX]%[#34]"
    EndIf
EndIf
Return

1. How can I do this with the NeoBookDB (NeoDB) plugin?
2. Can brackets be used in a query?