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

Question

LaserFiche Query Language Wild Cards

Laserfiche SDK

Updated March 30, 2016

asked on March 30, 2016

How can I get the field values form LF.entry_prop when the field name has spaces or can I use a wildcard to get all the values?

Or

How can I use a wild card to get all the field values from LF.Entry_prop. The following query does not work:

SELECT LF.Entry_prop.*
From LF.Entry_prop
WHERE LF.Entry_prop.entry_id =45883

Thanks

0 0

Replies

replied on March 30, 2016

The query SELECT LF.Entry_prop.* From LF.Entry_prop WHERE LF.Entry_prop.entry_id =45883 should work, so I will investigate what is going on with that query. To name fields that have spaces or punctuation, you need to quote the field name using double-quotes, as follows:

SELECT LF.Entry_prop."This field name is quoted"
From LF.Entry_prop
WHERE LF.Entry_prop.entry_id =45883

If the field name contains double-quotes (admittedly unlikely), then you can escape double-quotes by doubling them up. This is identical to how single-quote characters are escaped in strings in standard SQL.

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked March 30, 2016
Updated March 30, 2016
244 views