Home > Forum > Forms > Distinct values

Distinct values

0

AndreeLl B

27.04.2023

18:41

AndreeLl B

Hello,

I am a webcon beginner. Can someone help me?

I created a Dictionary with the following fields: Company and Project.

Company A can have Project 1, and Company B can have Project 1 too.
When i run a process: i have to select Company and Project. But when i select a project, in the company field i want to see only distinct values of companies from my Dictionary entries for that selected project only.

I have tried with function DISTINCT, but it didnt work.. thanks!

28.04.2023

08:52

Hi Andree

here's an example to filter a data source. I don't know whether your company is a business entity or a normal field.

In your case you would have a field or a business entity in which you selected the Company.
In the project field, you can use the value to filter the available ones.
In my case I used the Business Entity and another field to limit the available values to those which are defined for the Business Entity.

Best regards,
Daniel

Solution (1)

Helpful (0)

Wrong answer (0)