Select to view content in your preferred language

How to use distinct values in a table?

153
0
08-20-2024 06:40 AM
Ulises
by
Frequent Contributor

We use Workflow Manager for Server and our workflow has several extended properties, including a 1-M relation.  This generates redundant records depending on that 1-M relationship (ex. 1 job with 3 values in the extended properties table = 3 records in the jobs view table).  We haven't figure out how to make sure that jobs records are distinct values because that option is not always available for configuration.

  • Why the distinct setting is not available when configuring your table in dashboard?
  • If I create a data expression...can you make sure just distinct jobs records are used (need several fields of my view table so I haven't been able to use groupby)?

Any help or suggestions are appreciated.  

Ulises Feliciano Troche
Tags (2)
0 Kudos
0 Replies