WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > User Voice > Latest posts

User Voice

MVP

Hello,
since the new UI we've got much more users on the dark theme of webcon, it brought however a few new challenges with custom colors on controls / lists.

At this moment we are able to set custom css styles - background/text using attribute configuration:
https://docs.webcon.com/docs/2025R2/Studio/Process/Attribute/General/Attribute_StyleAndBehavior

It however lacks the possibility to make the color dependant on the theme, which causes in many cases unreadable text - see attached examples.
In most cases we're just switching colors to have contrast somewhere in the middle to both Webcon themes, so it looks equally ugly on both of them :)

Maybe a possibility to define a custom global css properties through system configuration, and use those properties in those configs would be something possible to implement?
Or from another angle - add possibility to define custom css properties on Theme configuration page?
https://docs.webcon.com/docs/2025R2/Portal/Administration/ColorThemes#edit-themes

MVP

Hi,

while we can create business rules which act similar to table valued / scalar functions, we can't pass the columns/data to them. The inner business rules are executed before the outer SQL command is executed. This comes in really handy in a lot of cases but also has it's limitation and will require creating repetitive code.

I would suggest the following:

Create a new "type" "SQL function"

Properties would be similar to a business rule:
Name : GetFirstTextPart
Description: Will split the text by the line break character and return the first part of the text. If no line break character is present, the input will be returned.
SQL Command
CASE
WHEN CHARINDEX(CHAR(10), {Parameter:1}) > 0 THEN LEFT({Parameter:1}, CHARINDEX(CHAR(10), {Parameter:1}) - 1)
ELSE {Parameter:1}
Number of rows to return: First row (scalar function), all rows (table valued)
Parameters:
Name: Input
Description: The complete text with the line break character.

When this is saved a function scalar/table valued is created and the bps_user gains execution permissions.

CREATE FUNCTION dbo.GetTextPartEN(@input NVARCHAR(MAX))
RETURNS NVARCHAR(MAX)
AS
BEGIN
RETURN
CASE
WHEN CHARINDEX(CHAR(10), @input) > 0 THEN LEFT(@input, CHARINDEX(CHAR(10), @input) - 1)
ELSE @input
END
END


You could then use the variable of this new type like the other business rules
select *, {SQLFunction:1700:<xps><ps><p id="#SQLFunctionParameter:71#" v="Description" /></ps></xps>} as DescriptionEN
, {SQLFunction:1700:<xps><ps><p id="#SQLFunctionParameter:71#" v="Remark" /></ps></xps>} as RemarkEN

Which would resolve to
select *, dbo.GetTextPartEN(Description) as DescriptionEN,dbo.GetTextPartEN(Remark) as RemarkEN

This came only to my mind now, because I'm creating a lot of "repetitive statements" in a few data tables, but when I think back, it would have helped me in a lot of other cases two.

Best regards,
Daniel

Hi,

it would be nice if one could not only chose "CREATE RULE" in the context menu of a field supporting rules. An option "CREATE GLOBAL RULE" would be helpful if we want to turn a "local" rule to a "global" one. It is clear that not all options in a "local" rule can be turned to a global one but there are cases where there would be no problem.

Kind Regards
Sébastien

Privacy overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognizing you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.


To see a full list of the cookies we use and learn more about their purposes, visit our Privacy Policy.