latest posts

Check the event log of the server on which WEBCON is installed to see what kind of startup error you have

Hello,

Did anyone else encounter the issue where WebCon Workflow Service doesn't start automatically after a system restart? If yes, how did you fix that?

TIA,
Martin

Here is an example SQL which I'm using in few reports:

(
SELECT
DTYPE_Name /*Change this to any column you'll need*/
FROM
WFElements JOIN
WFSteps ON WFD_STPID = STP_ID JOIN
WorkFlows ON WF_ID = STP_WFID JOIN
WFDocTypes ON DTYPE_ID = WFD_DTYPEID
WHERE
WF_GUID = 'af556142-7203-44e1-9aa2-550c2cd321cf' AND /* GUID of the workflow - I'm working with GUID as it's shared between environments, using regular ID will break between DEV/TEST/PROD, in theory not necessary, but I'm chipping it in, if database will grow, maybe SQL optimizer will use additional Indexes*/
WFD_ID = wfelems.WFD_AttChoose3_ID /* Column which stores connection to the dictionary */
)

When using a subquery - this parenthesis is necessary.

Hi all!

I am trying out the new user defined API in 2025 R2.

I have a client application with application context and added the scope App.UserDefAPI.ReadWrite.All (according to documentation this is necessary to get access to endpoint with automation).

In addition the REST API client is application admin, can start new workflows and so on...

What I am trying to do is a POST to an automation endpoint, which starts another workflow in its automation (very simple).

But all I am getting is, regardless of what I do:

{
"description": "Invalid scopes",
"guid": "48078ebb-424f-4a0f-9a27-7e67e408e148"
}

The guid cannot be found in designer studio, there is also no automation log.

Remark: The endpoint with a datasource works fine.

Did I miss something or this is a bug?

Thanks a lot in advance, Nik

starting to get it after thoroughly reading the docs. i can use only variables from the report i'm creating the calculated column in, but i need field age or name from the other report that should be based on my previous experience on wfd_guid which i'm matching from the first report field. not sure how to do formula because it's giving me unrecognized errors so far.

case
when dbo.clearwfelemid(WFD_AttChoose2) = (select wfd_guid from other_dictionary) then name(updated name variable from the other dictionary)
else 'not found'
end

There's also an alternative for the global constants if you are using one of the later versions.

A function was added to return the Portal URL. I'm not sure that this is available everywhere.

Best regards,
Daniel

Great! Thank you very much!
Ernst

Hi Ernst,
solution, which i'm currently using:
1. Create a Global Constant let's call it Hostname, and make it specific per environment, like https://companydev, https://companytest, https://companyprod
2. Using that constant create a Global Business rule like the one attached - using concat create whole url, in my case its using 3 parameters, but you could hardcode database id and app id if it won't be global for example.

Is there a simple way to get the URL of the current instance?

Use Case:
In a specific step a user can create a ticket (via menu action) in a 3rd party app (REST POST). In the request body of the rest call I create the json and want to submit also the url for this instance.

Thanks!
Ernst

Dzięki za linki - niestety - te miejsca już przeszukałem i nie widzę tam żadnej listy którą mógłbym wybrać...