topic Re: How to pass Column name into collection having # in Product Forum

How to pass Column name into collection having #

sapna_soni0290 — Wed, 10 May 2023 15:29:46 GMT

Hi ,

I want to pass below value into filter parameter of collection where Column Name is data type having value = BIN # (BIN space #)and Binid is other data type having value = abc. Please suggest how can I pass

"[Column Name]='"&[Binid]&"'"

Getting error - Internal : Could not execute code stage because exception thrown by code stage: Cannot find column [Column Name].

Re: How to pass Column name into collection having #

harish.mogulluri — Wed, 10 May 2023 16:06:39 GMT

Hi Sapna Soni,

Your statement looks correct. What is the column name in master collection you are trying to filter?

"[Column Name]='"&[Binid]&"'"
Do you have Column Name in Master collection some thing like below screenshot?.

if it is dynamic collection it should be under current value

Can you replace the "Column Name" to the actual column Name in master collection

Re: How to pass Column name into collection having #

sapna_soni0290 — Wed, 10 May 2023 16:19:02 GMT

Hi Harish,

My Column name value is BIN #. SO i am having issue to pass this column name. May be because it has two words separated by space or may be coz its having special character #. If i try this filter condition with "BIN='"&[Binid]&"'", it works. But my column name is actually BIN #. How can i pass this value?

Re: How to pass Column name into collection having #

harish.mogulluri — Wed, 10 May 2023 16:43:34 GMT

Hi Sapna Soni,

Try this "[BIN#] = '"&[Binid]&"'"

Re: How to pass Column name into collection having #

harish.mogulluri — Wed, 10 May 2023 16:46:25 GMT

Not sure whether you have space after BIN some thing like BIN #

then your filter statement should be "[BIN #] = '"&[Binid]&"'"

Re: How to pass Column name into collection having #

sapna_soni0290 — Wed, 10 May 2023 18:37:00 GMT

Hi Harish,

Wao this works. "[BIN #] = '"&[Binid]&"'". Can you explain me how this is working , what's the logic behind passing # within [] ?
Thanks for helping.

Re: How to pass Column name into collection having #

harish.mogulluri — Wed, 10 May 2023 20:59:38 GMT

HI Sapna Soni,

Check below articles it will help to handle the special characters while filtering the coll

https://learn.microsoft.com/en-us/dotnet/api/system.data.datacolumn.expression?view=netframework-4.7.2
https://www.csharp-examples.net/dataview-rowfilter/