here on 1.6.2.4 – LQL - Method 4 https://knowledge.opentext.com/knowledge/piroot/lleswebr/v100500-1403/lleswebr-ugd/en/html/jsframe.htm?wr-cats-n-atts
it's mentioned that LQL query like Attr_338223_2:"JRS62-99" will return all documents that have the Category 338223 (Test Category) applied with Attribute 2 (Trial Name) equal to "JRS62-99".
what is the complete query form for this? i mean if i want to get all docs (IDs) of docs that has category 338223 with attr 2 which equal to "JRS62-99".
In advanced search, Full Text section, change "All Words" to "Complex Query", then fill in your search term. I used Attr_269442_2:SearchText and it worked for me.
Cheers...
how to search through LLATTRBLOBDATA with 1.6.2.4 – LQL - Method 4 Posted byAkbarov, RufatOn 07/05/2016 07:45 AM here on 1.6.2.4 – LQL - Method 4 https://knowledge.opentext.com/knowledge/piroot/lleswebr/v100500-1403/lleswebr-ugd/en/html/jsframe.htm?wr-cats-n-attsit's mentioned that LQL query like Attr_338223_2:"JRS62-99" will return all documents that have the Category 338223 (Test Category) applied with Attribute 2 (Trial Name) equal to "JRS62-99". what is the complete query form for this? i mean if i want to get all docs (IDs) of docs that has category 338223 with attr 2 which equal to "JRS62-99". [To post a comment, use the normal reply function]Forum:Content Server Development ForumContent Server:Knowledge Center
If you want to make a SQL query then you should go via the LLAttrData table.
Hans
From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]Sent: Dienstag, 5. Juli 2016 13:49To: eLink RecipientSubject: how to search through LLATTRBLOBDATA with 1.6.2.4 – LQL - Method 4
how to search through LLATTRBLOBDATA with 1.6.2.4 – LQL - Method 4
Posted by Akbarov, Rufat On 07/05/2016 07:45 AM
[To post a comment, use the normal reply function]
Forum:
Content Server Development Forum
Content Server:
Knowledge Center
Thank you very much everybody for your responses. I didn't make my post clear, sorry. Actually I meant about SQL queries.
In our system we have custom user dashboard (with different user roles) which heavily makes use of LLATTRDATA table. (each doc have several categories. and depending on user role doc ids that are brought based on values of attributes of several categories )
Now, I want to see if llattrblob table can be used instead ... which may be faster than llattrdata to select from when selecting based on values of several categories.
e.g the query for llattrdata
SELECT llcn.id,llcn.vernum,llst.valstr as docstatus,lldl.valdate as deadlinedate, llpd.valdate as prologationdate /*FLD_END*/ FROM llattrdata llst, llattrdata llcn, llattrdata lldl, llattrdata llpdWHERE /*exec catg*/ llcn.defid = 301756 AND llcn.attrid = 86 AND llcn.valint IN ( 1059201 ) /*general catg*/ AND llst.defid = 301642 AND llst.attrid = 5 AND llst.valstr IN ( 'Assistant Accepted', 'In examination', 'In execution' ) /*exec catg deadline*/ AND lldl.defid = 301756 AND lldl.attrid = 90 /*exec catg prolongation*/ AND llpd.defid = 301756 AND llpd.attrid = 91 /*all conditions here*/ AND llst.id=llcn.id and llst.vernum=llcn.vernum AND lldl.id=llcn.id and lldl.vernum=llcn.vernum AND llpd.id=llcn.id and llpd.vernum=llcn.vernum
In this case it may be easier to use webreports, if you have them.
Then with SQL you just retrieve the items and in the webReport you can immediately access the blobdata via the webReport tags.
From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]Sent: Freitag, 8. Juli 2016 13:55To: eLink RecipientSubject: how to search through LLATTRBLOBDATA with 1.6.2.4 – LQL - Method 4 2
how to search through LLATTRBLOBDATA with 1.6.2.4 – LQL - Method 4 2
Posted by Akbarov, Rufat On 07/08/2016 07:50 AM
Topic:
if i give only one condition , for example: Attr_301642_4:"001 - audit" in Full Text part of Advanced Search, then it works and shows me true result, it is fine. but in case of two complex query condition nothing appear in the result.
Just curious, have you verified that if you search using only the 2nd part of the query (where you look for "Sent out") that it works?
…. And thatthere is something item that appears in both result lists.
What you do seems correct, therefore we try to rule out other errors before thinking this is a bug.
Did you try to combine both queries in a single LQL entry if you are doing LQL, why split them?
From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]Sent: Mittwoch, 3. August 2016 17:49To: eLink RecipientSubject: how to search through LLATTRBLOBDATA with 1.6.2.4 – LQL - Method 4
Posted by Simon, John On 08/03/2016 11:34 AM
in case of search only this query Attr_301642_5:"Sent out" works and all documents appear in the result.
I want to combine these two (Attr_301642_4:"001 - audit" and Attr_301642_5:"Sent out") single queries because i want to find documents which document type matches "001 - audit" and status matches "Sent out".
When you get a result back can you verify if the two attributes are filled and have that value?I think that is what John Simon & Hans Stoop is asking.If I am searching for something that has the color='green' and its type='animal' then an "AND" means find both that will be true.That is what the search is attempting to do.If it does not then it would .If only one of the values is on a object then it is a "OR".
A screencap of your attribute or a search result hit with those two attributes the way you want will help the forum.If it is not happening then the OT support team may have to look with logs your version etc.
Hopefully that is what you are doing but sometimes posting a picture of the result set will help establish what you are doing to the fortum readers.
