How do I make queries accessible in workflow context?

[weirdyang]

I would like to make a module and have the queries accessible in workflows, sort of how we can use SiteSettings.NameOfSetting, is this possible?

[douwinga]

You shouldn't need a custom module for this as workflows already can support this. You can use the "Set Property Task" with the javascript function executeQuery for instance.
https://docs.orchardcore.net/en/latest/docs/reference/modules/Workflows/#javascript-functions

You can also use liquid to do the query
https://docs.orchardcore.net/en/latest/docs/reference/modules/Queries/#query_1

[weirdyang]

thanks, apologies as my question wasn't clear, I was wondering how did the query module implement these features. I would like to implement a custom queries module so I can query other databases besides the orchardcore one.

[weirdyang]

Ok so I found my answer by going into the code and the docs:

Configure template options to add the necessary services and define the name to access it by, the docs was useful in explaining this piece of code

            services.Configure<TemplateOptions>(o =>
            {
                o.Scope.SetValue("Queries", new ObjectValue(new LiquidQueriesAccessor()));
                o.MemberAccessStrategy.Register<LiquidQueriesAccessor, FluidValue>(async (obj, name, context) =>
                {
                    var liquidTemplateContext = (LiquidTemplateContext)context;
                    var queryManager = liquidTemplateContext.Services.GetRequiredService<IQueryManager>();

                    return FluidValue.Create(await queryManager.GetQueryAsync(name), context.Options);
                });
            })
            .AddLiquidFilter<QueryFilter>("query");