latest posts

Hi,

https://community.webcon.com/feed/knowledge-base returns: “Page doesn’t exist.”

Kind Regards
Sébastien Anselment

Hi,

we wanted to use the MS Teams Workflow to push new RSS feed entries to our internal WEBCON Teams channel. Unfortunately the Power Automate flow throws this error using https://community.webcon.com/feed/user-voice:
{
  "status": 400,
  "message": "Failed to read requested Feed information. Details: '\b', hexadecimal value 0x08, is an invalid character. Line 13573, position 9.\r\nclientRequestId: dc221308-f5c5-445b-86a2-0b750c2ce180",
  "error": {
    "message": "Failed to read requested Feed information. Details: '\b', hexadecimal value 0x08, is an invalid character. Line 13573, position 9."
  },
  "source": "rss-ne.azconn-ne-003.p.azurewebsites.net"
}

Opening it in a browser returns:
This page contains the following errors:

error on line 13560 at column 39: Input is not proper UTF-8, indicate encoding !
Bytes: 0x08 0x2E 0x1C 0x2E
Below is a rendering of the page up to the first error.

Validation of the user voice RSS feed fails:
https://www.rssboard.org/rss-validator/check.cgi?url=https%3A%2F%2Fcommunity.webcon.com%2Ffeed%2Fuser-voice

Would it be please possible to fix this?

Kind Regards
Sébastien Anselment

Hi,

you could check out this blog post:
https://daniels-notes.de/posts/2023/has-field-value-changed

I've no idea whether it's still working with the latest version.

Best regards,
Daniel

Hi, I'm having a dilemma about comparing two date objects. My thinking is when I do sql queries to retrieve data from objects it will give you already stored db results, but with webcon functions you actually get value before it is actually stored. It does not work this way, so i'm looking for a way to do it. In conclusion, it should compare date before change and after change (this is triggered on menu action SAVE).

Hi,

the HTML field is not a value which is stored per workflow instance in the WFElements table. It's a field configuration.
Even if the value of the HTML field would be stored, it would depend on the HTML tags. The report only supports a limited number of HTML elements.

Therefore you would need to test Bartosz idea with the calculated column.

Best regards,
Daniel

It depends on what you want achieve? IMO the best way is create a calculated field an there you can add what you want

Hi,

I am wondering if i can use an HTML field to be displayed in Reports (interface). My html field contains some info that is visible in some Steps based on a business rule. And now i might need this info to be visible in reports (for filtering) and export to excel.
Or do i have to create another field (single line of text)?

thanks

Thanks Daniel,
this gives me all users (as expected).

I am using now a different group and its working. I will check the details (group differences) with my AD admin.

Thanks & Best regards
Ernst

Hi Ernst,

maybe you can check which users have been resolved for this group in the database.

This could work, but I haven't tested it.

SELECT users.COS_BpsID
FROM [dbo].[CacheOrganizationStructure] as users
join [dbo].CacheOrganizationStructureGroupRelations as groupMembers
on users.COS_ID = groupMebers.COSGR_UserID
join [dbo].[CacheOrganizationStructure] as [group]
on groupMembers.COSGR_GroupID = [group].COS_ID
where [group].COS_DisplayName like '%All_internal_users%'

Best regards,
Daniel

Hi Ernst,

The account used to connect WEBCON BPS to SQL Server depends on the choice of "Databases owner" made during the installation. Look up chapter "2.5.2. Database creation parameters" of Standalone installation instructions.
WEBCON BPS installer will grant db_owner permission for your account of choice to all BPS databases. The choice impacts the connection string.

If new/existing SQL login was chosen, then its credentials are used in connection string and no domain account needs db_owner privileges.
If "Use application pool account" was chosen, then connection string will have "Integrated authentication=True;" parameter in connection string, meaning that both application pool and service accounts will be granted db_owner permissions and will be used in connections to SQL Server.

As far as I am concerned, this was not changed between versions.

Kind regards