Dashboard Data Not Matching Reports — Need Help
Hi everyone, I’m trying to pull dashboard data, pageViews, visits, uniqueVisitors, etc. but the numbers I’m getting aren’t matching. I’m really new to this and trying to get the data for reporting, and I’ve been stuck for a few months. I tried the Bulk API, but the numbers came out really low. So I decided to download the report from Analytics instead. Dashboard Report Can anyone explain why the dashboard numbers don’t match the report? Is anyone using a different method to get this data? I’m trying to bring everything into Power BI. Can I get this data using Aurora GraphQL API? Thanks!Contraint conversationlastpostime in Api graphql getmessages does not work
Hi everyone, Has anyone here ever tried using the messages API with the conversationLastPostTime constraint? In my case, the constraint is completely ignored — it doesn’t seem to have any effect at all. What I’d like to do is retrieve only the conversations starting from a certain date limit. But no matter what value I pass to conversationLastPostTime.gte, the results I get are not filtered by date. Has anyone else faced this issue, and did you find a workaround or a proper way to make this constraint work? Here’s the GraphQL body I’m using: Thanks a lot for your help
HTML support for GraphQL API
Hi Khoros, I've been roadmapping usage for the GraphQL API that allows for the creation of a Knowledge Base Article: https://developer.khoros.com/khorosauroradevdocs/docs/create-a-knowledge-base-article#create-a-knowledge-base-article When it comes to populating the GraphQL, I noticed some fields that we can use to populate an article, like "subject", "body", "introduction". However, when it comes to creating a Knowledge Base Article, I'm curious if there is support for some things I can do with the GraphQL API that we can already do with the UI version of creating a Knowledge Base Article. For example, in the UI, I can open the Source Code field in the editor of the article (please see attached screenshot). What this allows me to do is to essentially author the article in HTML, rather than in plaintext. So, as seen in the screenshot, I can set the Source Code for the new Knowledge Base Article. My question is this: with the GraphQL API, can I submit the body content as straight HTML just like I can in the UI > SourceCode? If the answer is no, my question we then be, is there a way we can set the HTML of a new Knowledge Base Article using the GraphQL API in any way (Source Code or otherwise)? Thanks, Edson
Handlebars custom component not executing GraphQL query
I have been following along with the directions on this page to try to create a custom Handlebars component that executes a graphQL query and displays the results in simple HTML. My .hbs file references the query like this: {{#gql "privateUserStats" variables=(hash id=user.id)}} ... {{/gql}} I also have a .graphql query defined in queries/privateUserStats.query.graphql: query privateUserStats($id: ID!) { user(id: $id) { id login email firstName lastName email ... } topicsStarted: messages(constraints: {authorId: {eq: $id}, depth: {eq: 0}}) { totalCount }... } and I reference it in my component.json under the "graphql" block: "graphql": { "privateUserStats": "./queries/privateUserStats.query.graphql" } Despite this setup: The Handlebars rendered correctly user.id was available But the GraphQL query never fired — no network activity, no data returned, and no console errors Can someone help? I'm all out of ideas.
Aurora Email Templates
Hi everyone, I am new to GraphQL, so please forgive any silly questions here. I've successfully set myself up in Postman, and can retrieve email templates. I understand the documentation here about the process of updating a template, but I am hung up on viewing the HTML within each template so that I might edit that. My end goal, hopefully, is to be able to glean the variable for a post title within say, the Mentions template, and put that into the Subject of the email. So instead of "{User} mentioned you on {Community Title}" I would ideally have a subject that says "{User} mentioned you in the thread {Post Title}" I would also like to edit other pieces of other emails, but looking to cut my teeth on this one. Has anyone had success making a change like this on Aurora, and might be able to point me in the right direction? Thank you!
Tracking Complete Registrations in Google Analytics (via GTM)
Hi, Is there some sort of click listener or event that can be passed in the front end that can be picked up by Google Tag Manager when a user completes their registration (after successfully submitting their username)? Can we apply an event to the complete registration toast? If so, what is the best way to do this? Is there another way that we can track complete registrations in Google Analytics? Thanks!LiQL to GraphQL example sets?
is there an example set of LiQL -> graphQL query conversions anywhere? For example, I use this LiQL query to pull the latest articles in my tkb: query = f"SELECT subject, view_href, body, labels FROM messages WHERE board.id = '{tkb}' ORDER BY manual_sort, post_time desc limit 4" response = k.query(query)
