You are viewing limited content. For full access, please sign in.

Question

Question

LFQL: "LIKE" Operator

asked on May 5, 2014

I am trying to perform a wildcard search in LFQL using the LIKE operator. However, it appears it is not used in the conventional way. For example, here is a sample code snippet that would work in normal SQL but does not work the same way in LFQL:

session.LogIn( repository );

using( LfConnection connection = new LfConnection( session ) )
{
   connection.Open();

   // This works and returns results.
   ////string select = "SELECT entry_id, entry_name " +
   ////                "FROM lf.entry " +
   ////                "WHERE type = 'document' AND '1' = '1'";

   // This doesn't work, it returns no results.
   string select = "SELECT entry_id, entry_name " +
                   "FROM lf.entry " +
                   "WHERE type = 'document' AND '1' LIKE '1'";

   using( LfCommand command = new LfCommand( select, connection ) )
   using( LfDataReader reader = command.ExecuteReader() )
      if( reader.HasRows )
         while( reader.Read() )
         {
            // Create custom dataset from rows.
         }
}

session.LogOut();

Does Laserfiche support the LIKE operator or am I just using it in an incorrect way? Thank you very much!

0 0

Replies

replied on May 9, 2014

Hey, has anyone found a way to do this yet?

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.