sinsand Posted December 31, 2015 Share Posted December 31, 2015 HI All,I need to show the multiselect parameters as names but while passing them to query, i need to pass the selected names as Id.Can anyone please suggest how this can be achived.Thanks,Sandeep Link to comment Share on other sites More sharing options...
abc.hegde Posted January 1, 2016 Share Posted January 1, 2016 HI,You can pass them as IDs and in the query you can include those columns in the select statement. When you get the result set, you will have the multiselect values as fields in each row of the result and if you put the field outside the detail band it only prints once.Regards,Ashwath Hegde Link to comment Share on other sites More sharing options...
abc.hegde Posted January 1, 2016 Share Posted January 1, 2016 HI, You can pass them as IDs and in the query you can include those columns in the select statement. When you get the result set, you will have the multiselect values as fields in each row of the result and if you put the field outside the detail band it only prints once. Regards, Ashwath Hegde Link to comment Share on other sites More sharing options...
zh3ntil Posted January 2, 2016 Share Posted January 2, 2016 You can set different fields as visible column or value column on input control. For example, 'select id,name from person' is your input control's query. You can set name field as visible column which is prompted for user selection. And you can set id field as value column which is set to the parameter the selected person id by user. Then you can use parameters on query which is hold person's ids. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now