Dynamic record group in Form Builder
My requirement is I want to implement below query in Value set ,,those value set i want to use in my custom Form.
Query having 2 columns (FR-number, Rating) like below:
SELECT * FROM (select distinct a.ELEMENT_VALUE FR_NUMBER, b.ELEMENT_VALUE RATING
from MTL_DESCR_ELEMENT_VALUES_V a, MTL_DESCR_ELEMENT_VALUES_V b
where a.inventory_item_id = b.inventory_item_id
and a.ELEMENT_NAME = 'FR NUMBER'
and b.ELEMENT_NAME = 'RATING'
AND a.ELEMENT_VALUE NOT IN ('-')
order by A.ELEMENT_VALUE)
Please suggest me Solution ,
Thanks in Advance.