Indirectly looking up a value in an option set to display in a repeating group

[django1]

Hi.
I spent hours and hours trying to find this out, but I am not succeeding. Here is my problem:
I have an option set (quality_info) consisting of a number and a textvalue.
For example

1. Good item
2. Bad item

I have a product database with productinfo, which contains a number, which is a reference to the number in the option set.

I want to list the products in a repeating group, but in stead of the quality number I need to show the corresponding textvalue (good item/bad item).
Can somebody please explain how to do a lookup in the option set, based on the number(qualityvalue) in the producttable, so that i can retrieve the Textvalue?

For example
Database
Desc:Product1, QualityValue: 2
Desc: Product2, QualityValue: 2
Desc: Product3, QualityValue: 1

Which should result in the repeating group list
Product1 Bad item
Product2 Bad item
Product3 Good item

Can anyone help me with this?

[artemzheg]

@django1

I have an option set (quality_info) consisting of a number and a textvalue.

You have number + text in 1 field (display) of your Option Set or you have two different fields to store number and text of an option separately?

[django1]

Thank you for your reply.
I stored the values in 2 different fields in an option set.
The first field is of type number. The second field is the ‘Display’ field of type Text.
I want to do a lookup of the number-field and display the corresponding ‘Display’ field

[rico.trevisan]

I’m not sure this applies to your current database structure but to search through an option set you have to “flip it”.

So it’s get option Quality :filtered this option’s display is YOUR CRITERIA

[django1]

Hey @rico.trevisan ,
It took me some fiddling, but your solution worked. Thanks!
I selected the option set. Then ‘all options’.
Then I :filtered, the right option by selecting the option number field, then ‘is’ and then the parents…'number (the one in the repeating group). And finally I selected the Option sets’Display to show on the screen.
Thanks again! You made me happy