Cannot use a droplist based on an option set to provide a repeating group constraint

andy.speakman · 2024-08-01T07:27:11.053Z

I posted this in the general forum, but a couple of responders suggested this should be reported as a bug

I’m trying and failing to do something which I hoped would be pretty simple. I guess it is but I’m missing something. I have a table of data based on a reconciliationtask data type which I am providing droplist filters for. One of the droplists maps to a Transaction Type Option Set.

The droplist works on the page OK, but I cannot bind it to the constraint underlying the repeating group on the page. The other two droplists, based on text data, are fine.

Here is the droplist configuration:

Screenshot 2024-07-31 at 13.26.30696×690 43.3 KB

…and here is what happens when I try to add to the constraint for the repeating group:

Screenshot 2024-07-31 at 13.27.051422×1150 185 KB

As you can see “Dropdown Type” is not available and has the message “incompatible type”. It feels to me that the types match, as the droplist is collecting “Transaction Types” and the filter is on the field made up of “Transaction Types”. What am I missing?

Thanks in advance for any help you can offer. I can change the underlying data types if necessary, but I assume there’s a way to solve it this way.

sudsy · 2024-08-01T11:19:35.845Z

In order to work as you expect, the type field of the reconciliationtask data type must be defined as type Transaction Type (your option set’s type). Is that the case?

system · 2024-08-15T07:27:54.093Z

This topic was automatically closed after 14 days. New replies are no longer allowed.