LQL OR Brackets

I have following livelink query...

[QLREGION OTLocation] 211322 AND ([QLREGION Attr_212644_2] O OR [QLREGION Attr_212644_2] N)

For an uknown reason livelink doesn't take into account brackets surrounding two OR conditions so it returns back all the data that has value N in category 212644_2 despite first condition with specific location.

I tried this on two cs instances, both 16.0 version.

Does anyone know what is the problem?

Find more posts tagged with

Comments

AKropp

For what it’s worth I tried similar construction – I just copy-pasted your query and replaced the attrs - on a pretty much blank-slate 16.0.11 instance and it worked fine. So a good place to start would be to look at the search query log to make sure the OTSQL being produced matches what you think the query parameters are or should be (head to the bottom of the func=admin.configurelogging page – no restart required). There could be settings/templates/etc. that are introducing additional terms or something along those lines. Otherwise I don’t recall anything in any of the earlier 16.0 updates that would’ve explained that though I suspect one of the other smart folks will chime in with that if I’m forgetting something.

If you need a hand by all means open up a support ticket and the team can help with interpretation.

From: eLink Entry: Content Server Development Forum <development@elinkkc.opentext.com>
Sent: Tuesday, January 15, 2019 7:09 AM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: LQL OR Brackets

LQL OR Brackets

Posted bydejan.lipovec@akademika.si (Lipovec, dejan) On 01/15/2019 07:01 AM

I have following livelink query...

[QLREGION OTLocation] 211322 AND ([QLREGION Attr_212644_2] O OR [QLREGION Attr_212644_2] N)

I tried this on two cs instances, both 16.0 version.

Does anyone know what is the problem?

[To post a comment, use the normal reply function]
Forum:	Content Server Development Forum
Content Server:	My Support

Dejan Lipovec

HI,

Thank for your help. I enabled logs and found out following...

THIS DOES NOT WORK

[QLREGION OTLocation] 211322 AND ([QLREGION Attr_212644_2] O OR [QLREGION Attr_212644_2] N)

BUT THIS WORKS...

[region "OTLocation"] 211322 AND ([region "OTMeta":"Attr_212644_2"] O OR [region "OTMeta":"Attr_212644_2"] N)

Advanded search is using OTMeta . Is this something new? I always used QLREGION.

Regards

Patrick Pidduck

Older versions / updates of Content Server require quotes around the region names. Try [qlregion "OTLocation"] …

The META should not be required.

Patrick

From: eLink Entry: Content Server Development Forum <development@elinkkc.opentext.com> "
Sent: Wednesday, January 16, 2019 4:40 AM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: RE LQL OR Brackets

RE LQL OR Brackets

Posted bydejan.lipovec@akademika.si (Lipovec, dejan) On 01/16/2019 04:38 AM

HI,

Thank for your help. I enabled logs and found out following...

THIS DOES NOT WORK

[QLREGION OTLocation] 211322 AND ([QLREGION Attr_212644_2] O OR [QLREGION Attr_212644_2] N)

BUT THIS WORKS...

[region "OTLocation"] 211322 AND ([region "OTMeta":"Attr_212644_2"] O OR [region "OTMeta":"Attr_212644_2"] N)

Advanded search is using OTMeta . Is this something new? I always used QLREGION.

Regards

[To post a comment, use the normal reply function]
Topic:	LQL OR Brackets
Forum:	Content Server Development Forum
Content Server:	My Support