latest posts

Hi,
Clicking the Refresh button synchronises the columns in the item list with the underlying data source/SQL query. This means that any columns returned by the query will be added automatically.

One practical challenge is that a single data source can be reused in multiple places and often contains more columns than are required for a specific item list. In such cases, it is not always feasible to reduce the number of columns in the shared data source or SQL query directly.

My recommendation in this scenario is as follows:
- If possible, adjust the SQL query (or view) for this specific use case so that it only returns the columns that are required for the item list.
- Use the Refresh button once to import all columns, then manually remove the unnecessary ones and avoid further refreshes unless the data source structure changes.

Best regards
Maryna

Hi,
You can implement this restriction on your mail server that you have configured in webcon to send notifications- this seems to be the simplest solution because if you want to do it in actions, you would have to keep an eye on every action.
All sent messages are available in the wfmails table.

Hello, is there a way to restrict the domains to which e-mail notifications can be sent? For example, I would like to establish a rule so that e-mails are sent only to addresses within my domain (@my_company.com). So, even if I enter an external email address in the configuration, it won't be sent to that user.

Moreover, do you know whether data from test emails is stored in the database? (I am referring to the 'Send test email' function within the 'send a custom email' configuration.)?

Best regards,
Lukasz

We already cleared the problem, however should is this behaviour intended ? Secondly if i press the button it would also add the columns that i do not want to fill with sql and then i would have to manually remove them.

Hi,

we have just run into the same error.

System.Net.Http.WinHttpException: Error 12029 calling WINHTTP_CALLBACK_STATUS_REQUEST_ERROR, 'A connection with the server could not be established'.
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()


We are using an REST action in a for each loop. This worked a few times, but failed in another. My guess is, that we ran into the maximum allowed execution time and the request has been cancelled by WEBCON.

Best regards,
Daniel

Hi,
You can try refreshing the column list using the button (screen 1)
or check if it's remembered here (screen 2)

Hi Klaus,
if it should mimic 'current' access to document as is in Webcon, then it's as "simple" as joining with WFSecurities, CacheOrganizationStructureGroupRelations, and CacheOrganizationStructure, then just filter by current user using USERPRINCIPALNAME() or USERNAME() DAX functions.

An example query how to join with WFSecurities can be found here: https://github.com/lumenn/webcon-privileges-lookup/blob/main/PrivilegesLookupQuery.sql

It might be on the heavy side of queries, especially if there are some aggregates, but that's how you could technically achieve it.

It's not a db level row security though, and if user would connect to the db directly, then nothing stops them from querying anything else (but this goes for whole platform).

There is a column (Co_Id) in an item list that states that it is used in an replace item list action.
However the Action is not using this column.
See the pictures in the attachments.

For more information, as far as i know the replace item list used an action template in the template settings.
The Template was changed so that it does not include the "Co_Id" column anymore. The actions that used the form template also reflect the change when opening the configuration, yet the column still states that is being used there.
Interestingly the Column is not directly used by the Action Template only in the action that used it as template.

The "ID" which is sent via header is currently a Test-ID (Domino Document Unique ID - which is needed for the rest-api)

It works fine, if I run it via Menu, but via Timer or Path-Action I always get the error.

Ernst

Hi Krystian,

Thanks for your reply. Yes, there are approximately 800,000 rows in the database that match the criteria. I don’t see how this could be an issue. The text fields contain any number of digits (e.g., work order numbers, bank account numbers, etc.). However, I’m curious to know the solution to this error.

Thanks,
Martin