Passing Parameters name as ID

[sinsand]

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

[abc.hegde]

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

[abc.hegde]

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

[zh3ntil]

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.