About darryllee

darryllee · ‎11-06-2021

Sweet! This worked great. In fact, I didn't even need the third query. Just used this: SELECT view_href FROM messages WHERE participants.id = '554991' AND author.id != '554991' AND depth=0 AND conversation.solved = false LIMIT 1000 (The user was really just looking for a list of links to questions they had answered that were still not accepted.) I guess the only other enhancement might be a way to also filter out messages where the user only commented on another answer (which would be anything where the depth != 1.) But depth can only be zero. Hrm... Thank you so much for your response though. This is great!

darryllee · ‎11-01-2021

Hi, reading the docs for LiQL, there are examples of filtering on conversation.solved. And indeed, this is referenced by @VikasB in this answer: https://community.khoros.com/t5/Khoros-Communities-Product/How-can-I-track-the-number-of-unanswered-posts-over-time/td-p/553368 What I'm really trying to do is find answers that a user has provided for questions that are still considered unsolved. I can filter by author.id fine, but when I try to combine that with conversation.solved, things break down because apparently conversation.solved will only work with a depth specified, and that depth MUST BE ZERO: "message": "The depth parameter, or the value passed in for the depth parameter, is not valid.", "data": { "type": "error_data", "code": 605, "developer_message": "only depth of 0 is supported.", Weird. I mean, why shouldn't I be able to filter on conversation.solved independent of depth? Why are the two linked?

darryllee · ‎03-03-2021

Hey thanks @StanGromer - you've already helped immensely. Yes, I understand the 1000 result limit and OFFSET. Somebody at Atlassian figured out that the problem I'm getting so few requests is that my posts don't actually have the tags I'm looking for (because I'm mainly replying to questions). It's the parent messages that have those tags. So I can get all the parent.ids with this query: SELECT parent.id FROM messages WHERE author.id='1365322' LIMIT 1000 And then I can get the tags for a particular message thusly: SELECT * FROM tags WHERE messages.id='1628420' I think what I'm really looking for is something like a Nested Query in SQL: SELECT * FROM tags WHERE messages.id IN (SELECT parent.id FROM messages WHERE author.id='1365322' LIMIT 1000) But heh, unsurprisingly, LiQL doesn't appear to support that. (Edit: Also, reading the docs, it's clear I want topic.id, not parent.id.)

darryllee · ‎03-03-2021

@StanGromer thank you so much for pointing me to that article. I wrote instructions to allow other Atlassian Community members to start pulling down all of their messages, so hopefully everyone gets to bang their head against parsing JSON files soon. (jq is my drug of choice.) I was wondering about one thing though: I was hoping I could combine an author.id query with the tags that Tyler details in his article to get something like: SELECT * FROM messages WHERE tags.text = 'cloud' AND author.id='1365322' LIMIT 1000 But weirdly that only brought up my most recent post about 'cloud'. I have a feeling the 1000 message limit kicks in *before* the author.id filter can be applied. I'm fully up for more digging into LiQL, but figured I'd ask the experts here. :-}

darryllee · ‎03-02-2021

WHOA! How did I not find that post? (So, I've gotta make a small complaint that sometimes Khoros's search engine leaves me wanting.) That looks right up my alley. And aha, there's the one thing I was going to ask about - can I query by user ID? Looks like the answer is yes! Excellent.

Online Status	Offline
Date Last Visited	‎11-11-2021 11:53 PM

Re: Can't query by conversation.solved without depth=0 being required?

Can't query by conversation.solved without depth=0 being required?

Re: Can you add metadata to "My community content"?

Re: Can you add metadata to "My community content"?

Re: Can you add metadata to "My community content"?