Using LiQL or SQL on Aurora instead of GraphQL?
We had an LiQL query we were using for years to surface community posts on our help center, and following the move to Aurora we need to update this to GraphQL. However, the developers on that team would prefer SQL/LiQL as their system is not set up for GraphQL. Is it possible to still use LiQL or SQL queries while on Aurora?
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!
Incremental data for attachments in messages and replies
I am trying to get incremental data based on required datetime field for attachments related data in messages and replies. Can someone please help me with this ? Graphql queries for which I need incremental data is as follows: query Attachments { messages { edges { node { id attachments { edges { node { id filename url } } } } } } } ThanksError message when adding a query to handlebars component (Aurora)
I'm trying to follow the documentation on creating a custom handlebars component in Aurora and I'm running into a weird error that I can't figure out. I have added the component via a GraphQL mutation and it works fine with some basic HTML, but once I try to follow this doc: https://developer.khoros.com/khorosauroradevdocs/docs/adding-graphql-queries-and-fragments-to-a-custom-handlebars-component I'm running into some issues: There's no docs (at least not that I've found) that explain how to get the bearer token or where the file should be stored or how that works when using GraphQL to upload a GraphQL file to use in a component (see here: https://developer.khoros.com/khorosauroradevdocs/docs/adding-graphql-queries-and-fragments-to-a-custom-handlebars-component#uploading-a-graphql-file-for-a-component-via-graphql) and I've been unable to figure out how to do this on my own. I've tried a few things with no success. If I try to follow the steps to add it manually, then I run into some strange errors. I'm running the SDK via VS code terminal which is working fine, but as soon as I follow the steps to add a "queries" folder and .graphql file to that folder within my component folder (e.g., components/myComponent/queries/myComponent.query.graphql) then I get an error in the VS Code terminal that says ""message": "The Content-Type header included with the request is not allowed (it should be either application/json or application/xml)."," and in my browser console when I try to load my custom component is: "Unable to fetch component to render for component id custom.widget.releaseTkbSidebar: Exception while fetching data (/component/render) : com.github.jknack.handlebars.HandlebarsException: releaseTkbSidebar:1:18: lithium.coreapi.components.ComponentTemplateApplyException: unable to apply template: releaseTkbSidebar: no query found matching the name 'releaseTkbSidebarQuery'. releaseTkbSidebar:1:18" Anyone know what's going on here? I've follow the dev docs and examples exactly (or as close as I can given that they've proven to be very inaccurate) and I'm out of things to test through trial and error. Here's what I have in my .hbs file for my custom component: <h2>Test!</h2> {{#gql "releaseTkbSidebarQuery"}} {{#with data.messages.edges as |edges|}} {{#each edges}} {{#with node as |message|}} <p>{{message.subject}}</p> {{/with}} {{/each}} {{/with}} {{/gql}} And here's what my .graphql query file looks like query releaseTkbSidebarQuery { messages { edges { node { id customFields subject } } } } My file structure looks like this Any help would be very much appreciated!
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)Error while fetching products data using graphql query
I am trying to fetch products related data but getting below mentioned error. Graphql: query MyQuery { products { edges { node { name description id } } } } Error: { "errors": [ { "message": "The field at path '/products' was declared as a non null type, but the code involved in retrieving data has wrongly returned a null value. The graphql specification requires that the parent field be set to null, or if that is non nullable that it bubble up null to its parent and so on. The non-nullable type is 'ProductConnection' within parent type 'Query'", "path": [ "products" ], "extensions": { "classification": "NullValueInNonNullableField" } } ], "data": null } Can someone please help me out here ? Thanks
