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

Question

Question

LFQL Field Query with Period in Field Name

asked on July 5, 2017

I'm trying to run the following query in LFQL, however I keep getting an error "An unrecognized name was encountered. [9086]" from having the period in the field name. The query runs fine without the period.   

SELECT e.entry_id, p."Acct No." FROM LF.Entry e LEFT JOIN LF.Entry_Prop p ON e.entry_id = p.entry_id WHERE type='document'

I tried running with both the aliased table "p" and the non-aliased table with the same results.  I am using RA 9.2 to run the query.  

0 0

Replies

replied on July 5, 2017

Thanks for pointing this out, it appears to be a bug in the LF server. we will look into fixing it in a future version (bug# TFS-33933).

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

Sign in to reply to this post.