05-28-2024 07:53 AM
Hi Experts,
I am trying to use a member filter based on the Text property. Here are the sample text property values:
Member1 = PASSTHRU~[False]|IPL~[False]
Member2 = PASSTHRU~[True]|IPL~[False]
I wanted to filter the members that have " PASSTHRU~[True] " in the text property, i tried the filter below but it returned no results:
U4#Top.Base.where(Text8 Contains PASSTHRU~[True])
I do get results if i use U4#Top.Base.where(Text8 Contains PASSTHRU~), but as soon as i add " [ " character, it doesn't pull any members.
Any suggestion would be helpful.
I tried all the below formats, nothing worked:
U4#Top.Base.where(Text8 Contains 'PASSTHRU~[True]')
U4#Top.Base.where(Text8 Contains [PASSTHRU~[True]])
U4#Top.Base.where(Text8 Contains PASSTHRU~[[True]])
05-28-2024 11:53 AM
I tried this, and it worked for me. It appears that ~[ might be associated with a specific system keyword. However, I could not find any documentation around this.
05-29-2024 02:00 AM
@AK There are cases where text values contains 'True' in other places, so it wont work.
Member5 = PASSTHRU~[True]|IPL~[True]
06-03-2024 04:23 AM
The "[]" are used in member filters to surround member names (particularly where there are spaces or special characters are used in the naming). Therefore i suspect the member filter automatically ignores these.
I think the question is do you need the square brackets, or could they simply be removed. Alternatively the "{}" should work for you.