Multi-Select in Relational Lists

Good Day,

I would like to find out if it is possible to use a multi-select drop down ReportVariables in a Relational List. (We use On-prem 2022-09 version)

If possible, will the XML variable be ok to be used or do I need to convert the ReportVariables field to another piped defined variable or with quotes surrounding each element selected?? I tried both options as per below without success.

So my SQL in plain terms looks like this:

SELECT *

FROM [Table_XXX]

WHERE workcenter in ('F00','F01')

My ReportVariable (ReportVariables.lv_WC.Text) looks like this:

<?xml version="1.0" encoding="utf-16"?>
<MultiSelect xmlns:xsd="">www.w3.org/.../XMLSchema" xmlns:xsi="">www.w3.org/.../XMLSchema-instance">
  <Hierarchy>[WO_WORKCENTER]</Hierarchy>
  <AggregationFunction>Sum</AggregationFunction>
  <StructureSelection>
    <Member>
      <MemberUName>[WO_WORKCENTER].[F00].[1]</MemberUName>
    </Member>
    <Member>
      <MemberUName>[WO_WORKCENTER].[F01].[1]</MemberUName>
    </Member>
  </StructureSelection>
</MultiSelect>

So I tried the following but I receive no data.

="SELECT [workCenter]
FROM [XXX].[dbo].[Table_XXX]
WHERE workcenter in ('" & ReportVariables.lv_WC.Text & "') "

Can someone please help??

Thanks so much!

Ansa

Find more posts tagged with

Infor EPM Discussions

Comments

filip-kosnac

Hi,

you can use the formula =MULTISELECTGETMEMBERSSIMPLE(yourVariable.Text;"separator")

=MULTISELECTGETMEMBERSSIMPLE(ReportVariables.lv_WC.Text";"|") to get the Elements separated by a pipe.

https://docs.infor.com/depm/2022.x/en-us/depmolh_cloud/default.html?helpcontent=application_studio_cloud/htf1510174376618.html

Best Regards

John Robson

It would be worth trying a , as a separator in the MULTISE ..given the use is for an IN clause?

Ansa Leonard

Thanks guys. In the end I couldn't use the MULTISELECTGETMEMBERSSIMPLE as it only gave me the Unique Name separated. I had to use the MEMBERCNAME. From here I had to REPLACE the value to get single quotes around every element plus the comma to get in a format SQL could read. A normal SELECT also didn't work, I had to revert to create a store procedure to call from AS to execute the SELECT. Long way around but I eventually got it to work!

Keep well and thanks for responding!!

Ansa

Nathan Hewat

That MEMBERCNAME method is great where the dim element captions match the SQL values being selected. In cases where they don't, I pass the multiselect xml variable to a hyperblock having it's "output cells" set to be an attribute matching the records to be selected in SQL (cell E3 in image). A reference to the hyperblock in an ARRAYTOSTRING function with single quotes and commas then produces the appropriate string for the SQL "IN" statement:

Copyright © 2025 Infor. All rights reserved.