FHSQL sorting a list

[former_member677065]

Hi All,

I am using FHSQL (not a universe) in BO and have hard coded a list of values for state. I want to know if i can

1. Type in the first few letters of a state and get the list of only those states that start with the letters

2. Arrange the list in alphabetical order so that it becomes easy to select from the list.

I am using the following @prompt filter -

Table.state IN @prompt ('Select one or more state from the list:', 'C',{'KV','HU','LO','QLD','GUV','IN','28','HBN','CW','PT','TN','KD','CES','59','BS','21','CHI','VV','190','AZ','300','VD','973','PB','HUI','NW','KAR','YW','JK','RIS','NE','MA','PUT','66','BL','49','UR','240','83','TY','SY','K'} , MULTI, CONSTRAINED)

Regards,

Rishi Saka

[former_member199945]

Hi,

Refer this - for 1st question - esepcially @Prompt syntax to create a predefined condition using a match pattern prompt

https://help.sap.com/viewer/512fca6758c4495bb6a50fe3e1e4b892/4.2.5/en-US/4647df0a6e041014910aba7db0e...

Use order by in code for state dim object and try for 2nd ques.

Thanks