latest posts

Yes I did ...
My IT did filtration on AD sync
as:
CN=WEBCON,
OU=Webcon
but previously I have in filter nothing ...

and now it shows the same list of users who had license ...(is added to group which allow to login)
my IT did restriction [license restrictions]
... and now I need to change a lot of item lists ... where I need put person from company not from allowed users ... :/

BTW: your "construction" works .. thank you.
Why do you think is not reliable?

"I'm afraid it gives me only users with license ...
not all users in AD ..."
-----
have you checked this?
this should return ALL users - not just those with licenses.


but if you really want to cut it out from the string (although in my opinion it's not very certain) try this from the screenshot ("test" is your string "CN=John Doe,OU=Users,OU=Employees,OU=CTM,OU=People,DC=xyz,DC=xyz,DC=local" )

I'm afraid it gives me only users with license ...
not all users in AD ...
[---edit---]
this source is giving me only 100 from 300 users only with license ...

I try to split grab part of text .. but I don't know how to grab "XXXX from string "CN=XXXX, where XXXX could by XXXXXXXXXXXXXXX or XX

the webcon text function gives me TRUE where I need string ... [part of string]

https://docs.webcon.com/docs/2024R1/Studio/BusinessRules_General/#funkcje
Text

You can use the following functions that operate on text values:

TO UPPER – converts a text value to capital letters, e.g., contract → CONTRACT,
TO LOWER – converts a text value to lowercase, e.g., CONTRACT → contract,
TEXT LEN – returns an integer value representing the number of characters in the text (string),
SUBSTRING – allows you to extract a text fragment based on the starting character's index and the number of characters to be downloaded. The first character in the text has an index = 1,
STRING REPLACE – allows you to replace a phrase in a given text with another phrase,
INDEX OF – returns the position of the first occurrence of the specified string in the provided text. This function searches the text starting from the indicated position. The first character of the text has the value = 1,
CONCAT – it is used to combine several texts into one text string,
TRIM – removes whitespace at the beginning and at the end of the selected text,
LIKE – enables checking whether the selected text contains a given text pattern. If so, "TRUE" is returned,

tip

Using the CONCAT function within the LIKE function enables creating advanced filter conditions related to Data sources. This solution allows you to narrow down the list of values returned by a data source, for example, when configuring a Choice field.
For more information, see the ARTICLE on our technical blog.
CONTAINS – checks if a given text fragment is present in the selected text; if it is, it returns "TRUE". This function is not case sensitive,
STARTS WITH – checks if the given text begins with the specified fragment; it is not case sensitive,
SPLIT – allows you to divide the text into parts separated by a character of your choice (e.g., a semicolon). You can also use any string of characters as the separator,
REMOVE HTML TAGS – removes all HTML tags from a given text,
TEXT – allows to define text with translations.

I'm afraid it gives me only users with license ...
not all users in AD ...
[---edit---]
this source is giving me only 100 from 300 users only with license ...

I try to split grab part of text .. but I don't know how to grab "XXXX from string "CN=XXXX, where XXXX could by XXXXXXXXXXXXXXX or XX

the webcon text function gives me TRUE where I need string ... [part of string]

https://docs.webcon.com/docs/2024R1/Studio/BusinessRules_General/#funkcje
Text

You can use the following functions that operate on text values:

TO UPPER – converts a text value to capital letters, e.g., contract → CONTRACT,
TO LOWER – converts a text value to lowercase, e.g., CONTRACT → contract,
TEXT LEN – returns an integer value representing the number of characters in the text (string),
SUBSTRING – allows you to extract a text fragment based on the starting character's index and the number of characters to be downloaded. The first character in the text has an index = 1,
STRING REPLACE – allows you to replace a phrase in a given text with another phrase,
INDEX OF – returns the position of the first occurrence of the specified string in the provided text. This function searches the text starting from the indicated position. The first character of the text has the value = 1,
CONCAT – it is used to combine several texts into one text string,
TRIM – removes whitespace at the beginning and at the end of the selected text,
LIKE – enables checking whether the selected text contains a given text pattern. If so, "TRUE" is returned,

tip

Using the CONCAT function within the LIKE function enables creating advanced filter conditions related to Data sources. This solution allows you to narrow down the list of values returned by a data source, for example, when configuring a Choice field.
For more information, see the ARTICLE on our technical blog.
CONTAINS – checks if a given text fragment is present in the selected text; if it is, it returns "TRUE". This function is not case sensitive,
STARTS WITH – checks if the given text begins with the specified fragment; it is not case sensitive,
SPLIT – allows you to divide the text into parts separated by a character of your choice (e.g., a semicolon). You can also use any string of characters as the separator,
REMOVE HTML TAGS – removes all HTML tags from a given text,
TEXT – allows to define text with translations.

maybe this is a workaround ;) but you can always make a SQL data source with users.
e.g.
SELECT COS_BpsID, COS_DisplayName, COS_ManagerDisplayName FROM CacheOrganizationStructure WHERE COS_AccountType = 1

Do we know when we can expect the 2024 R2 version?

Hi Dariusz,

We’ve already fixed this issue.

It’s available starting from the 2023.1.3.202 release and in all subsequent ones.

Best regards,
Łukasz