latest posts

Hi Andreia,

which version are you using?

Depending on the answer the SDK will either not work and may be obsolete anyway.
With 2023 R1 or R2 an option was provided in the update item list action to remove rows.

https://webcon.com/docs/2024R1/Studio/Action/Form/Action_UpdateItemListValues

Remove rows that do not exist in the data source – removes the rows that are not found in the Data source from the Item list. The rows are identified on the basis of unique values specified in the Unique value mapping field.

Best regards,
Daniel

Hi,
what kind of error do you have?
and do you have a SDK license?

Regards

HI Everyone,

I see that you're using a SDK action to delete rows in an item list.
I'm following Daniel's post to add the pluggin in Webcon but I'm having some errors while importing the zip file.

What SDK pluggin you're using?
Thank you all

https://github.com/Daniel-Krueger/webcon_cclsactions/releases

ok. In this case, I think there are two options:
1. List of items BUT rows would have to be updated by child flows OR you can use SQL row columns which always show current data
2. SQL grid - always shows current data.

I think the second option is a better solution.
I don't know how many columns you show/hide, but you can make 2-3 SQL grids with different number of columns and always show only one of them depending on the conditions.

But the data we were showing on the Item list were representing child flows so there were statuses changing etc. When you are in preview mode you don't see those changes although they are already in the database.
Another udercut is that you cannot dynamicaly hide a column based on the atribute field value.
In Data tables you must show all columns wherase in item lists you could hide some columns.
Is there any other solution to this ?
Problem is that when you look on that item list which should be always "up to date" it is not when only in preview mode. So you must always get into edit mode to see the real (initialized) data.

Thank you a lot! I would it seaching on test env

for example.

SELECT *
FROM [BPS_Content].[dbo].[WFBusinessRuleDefinitions]
WHERE BRD_Value like '%10814%'

Hi,
you can try using SQL:

select cast(N'xxxx' as varchar(max)) collate SQL_Latin1_General_Cp1251_CS_AS

Hi,
I have three fields:

Name - text
lastname - text
domain - choice field
And one technical field to which an action is assigned:

concat[name][.][lastname][@][domain]

The action works correctly but takes Polish characters into account.
Is it possible, and how, to remove Polish characters in the technical field, i.e., replace "ą" with "a," and so on?

Hi,
yes, using Data Table (SQLGrid) can be a workaround
but in my opinion this behavior is correct - because the user (especially if he doesn't have edit rights) shouldn't see data that isn't actually saved on the form (those rows aren't in the database)

Hi,

there's no need to look for any information. This feature is removed/will be removed in later versions.
Unfortunately, I don't find the document where I read it.

Edit:
In 2024.1.1.48 it is already removed.

Best regards,
Daniel