LQL - how to search null dates

Hi.

I Have two questions

1. I have a category cotaining a datetime attribute. This attribute isn't required so, documents, can have this attribute not setted. How to search these documents using LQL?

Using [qlregion "Attr_11369_5"]="" I have this error: Error in Full Text component. Could not convert [qlregion "Attr_11369_5"]="" to OTSQL

Using [qlregion "Attr_11369_5"]=" " (with a blank char) I have an unaxpected result (it retrives document having several date also)

2. In admin interface I can see a category attribute only if exists at least a document that use this category. It's normal? How can I take thecode (Attr_...) to build LQL expression if it doesn't appear?

Are there clear and comprehensive documents or a links or pages about LQL? I'm looking for example here

https://knowledge.opentext.com/knowledge/piroot/llescor/v100009/llescor-h-ugd/en/html/jsframe.htm?lleswbb-h-ugd-sr-lql

but it report sonly very banal examples.

Tks

Find more posts tagged with

Comments

Mahesh Pinnamaneni

You can use "Attr_11369_5":!=* to search for that attribute that has no value.

assistenza

Quoted Mahesh Pinnamaneni on 2013-10-24 16:23:

You can use "Attr_11369_5":!=* to search for that attribute that has no value.

Uhm... it doesn't work... it don't find any document. That command is specific to a certain version? I use the 10

Kyle_Swidrovich

The OTDCategory region contains the ID of the category that’s applied to the object.

This can let you find objects that have the category applied.

If no indexed document in the system has a particular attribute of that category defined, then it won’t be searchable by the attribute's region name.

What you can do is look for items with “OTDCategory”:12345 AND-NOT “Attr_11369_5”:*, where 12345 is the ID of your category.

assistenza

Quoted Kyle Swidrovich on 2013-10-24 18:50:

What you can do is look for items with “OTDCategory”:12345 AND-NOT “Attr_11369_5”:*, where 12345 is the ID of your category.

You're answering to my 2nd question?

Using your expression, it retrieves the category node, and not the documents having that category

Kyle_Swidrovich

CS 10 has the OTDCategory capability.

I may be mistaken in that OTDCategory may actually store the name of the category as opposed to the category’s ID.

So if your category is called “My Category”, try searching for “OTDCategory”:”My Category” and see if you get hits.

Mahesh Pinnamaneni

hmm..I have CS10 too and that's what I have used in one of my projects to find all the objects that has a Category Attribute value is blank. what I see from Livelink 971 to CS10 is you got to have double quotes for key & value like “Attr_11369_5”:!*.

Where did you use this query. Can you try in the Advanced Search window?

assistenza

Quoted Kyle Swidrovich on 2013-10-25 08:46:

So if your category is called “My Category”, try searching for “OTDCategory”:”My Category” and see if you get hits.

My category is called CatProva and its ID is 11369. Using in advanced search one of two following expressions:

“OTDCategory”:”11369”

“OTDCategory”:”CatProva”

I have not results.

It's strange because as you say there is the "OTDCategory" key:

Maybe I have to select the "Search By default" checkbox"

Otherwise thanky ou for your interest

Mahesh Pinnamaneni

OTDCategory takes the CategoryID. Can you try with Advanced Search manually selecting the Category from the left pane and enter the data and hit submit to see if you can get any results back. Are you sure your indexing processes has no errors?

Kyle_Swidrovich

Search By Default is only used when you do not explicitly include the region being searched in your query.

For troubleshooting, I would recommend making OTDCategory “Displayable” on the Search Manager’s Regions page, then choose to display that region (called “Category”) in your search results.

Once that is in place, write a query that will return an item that has one of these categories applied (e.g., “OTDataID”:12345).

You should see the value of OTDCategory on the results page for your result.

Then try searching by OTDCategory using that value to see if you can return the item in the results.

To see the raw value stored in the index for that region, enable search client logging ([options] wantSearchLogs=TRUE) and examine the <OTHOME>/logs/search_#.log file after executing a query. It will show your search query and the result set that is returned, including the values of some core regions + any you have made displayable in for your query.

assistenza

Quoted Mahesh Pinnamaneni on 2013-10-25 17:40:

How can I try to enter the data if I want only documents with blank value?

Using !=*

Retrieve documents with several values also!

I' don't undestand

Mahesh Pinnamaneni

Sorry I meant to use Advanced Search just to make sure if you get ANY results back from the Search Engine so that we know if there is any problem with the indexing. If you see results that means your search and/or index is fine and you need to look into the query. If you dont see any results for the category that you are using, that indicates that either the data is not indexed or problem with your Search / Indexer.

HTP

Mahesh