LQL Syntax/Examples?

I'm wondering if there are any more examples of Livelink Query Language syntax out there? The LAPI documentation has the following:To find all projects that started before June 1, 1999, and whose name contains words that begin with P, specify the following in a Search field:(OTSubType : 202) AND (DateStarted : (< 19990601)) AND (OTName : QLRIGHT-TRUNCATION P)Is there a list of all the LQL functions like QLRIGHT-TRUNCATION? More examples like date range queries?How could you possibly figure this stuff out without a list of available functions and examples? The LAPI documentation is severly lacking in syntax and examples. Hoping for some help.Thanks.

Find more posts tagged with

Comments

Carsten_Kulms

Message from Carsten Kulms via eLink"For more information about LQL including lists of keywords,conventions, and other usage information, see the Livelink Online Help."Not many examples but (afaik) a complete list of operators, keywords,etc.

Appu_Nair

One option if I may suggest is to completely forget about LAPI and search is to use the XMLsearchAPI.It has a very simple forms based(read javascript) interface replete with very good hand holding examples.Once you figure out the syntax you can either use programming with xmlsearchapi(basic xml programming) or at least use the syntax you perfected with that.

Carsten_Kulms

Message from Carsten Kulms via eLinkI second Appu: The XML Search API -- btw: which is officially called "Search API"(without "XML") -- is the better approach. It is a different interface than LAPI, so some non-LAPI coding needed,but not really difficult. (At least in environments where HTTP and XMLparsing is out-of-the-box supported, e.g. Java and .NET)

Hans_Giger

Message from Hans Giger via eLinkThe Search API documentation can be found here:Livelink ECM - Enterprise Server Search API Programming Guidehttps://knowledge.opentext.com/knowledge/llisapi.dll/properties/13621465-----Original Message-----From: eLink Discussion: LAPI Discussion [mailto:lapi@elinkkc.opentext.com] Sent: Friday, March 20, 2009 4:10 PMTo: eLink RecipientSubject: One option if I may suggest is to completely forget about LAPI and search is to...One option if I may suggest is to completely forget about LAPI and search is to... Posted by anair@alitek.com (Nair, Appu) on 2009/03/20 11:05 In reply to: RE LQL Syntax/Examples? Posted by ckulms (Kulms, Carsten) on 2009/03/20 10:59 One option if I may suggest is to completely forget about LAPI and search is to use the XMLsearchAPI.It has a very simple forms based(read javascript) interface replete with very good hand holding examples.Once you figure out the syntax you can either use programming with xmlsearchapi(basic xml programming) or at least use the syntax you perfected with that.

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

I agree with Carsten. The best documentation I've found for LQL is in the online Help. If you do a search against the "Help" slice for the quoted phrase:"Livelink Query Language"...then you should get hits on pages with titles like:Sample Queries. Searching with Basic Queries. Specifying Query Attributes Using LQL. Understanding LQL Conventions. Understanding LQL Keywords. Searching with Complex Queries. Searching Livelink: Working with Regular Expressions using LQL- Bhupinder----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: LAPI Discussion [mailto:lapi@elinkkc.opentext.com]
Sent: Friday, March 20, 2009 11:00 AM
To: eLink Recipient
Subject: RE LQL Syntax/Examples?

RE LQL Syntax/Examples?		Posted by ckulms (Kulms, Carsten) on 2009/03/20 10:59
In reply to: LQL Syntax/Examples?		Posted by metlif01 (Benjamin, David) on 2009/03/20 10:45

Message from Carsten Kulms <carsten.kulms@opentext.com> via eLink

"For more information about LQL including lists of keywords,
conventions, and other usage information, see the Livelink Online Help."

Not many examples but (afaik) a complete list of operators, keywords,
etc.