IF Condition Syntax correction in WEBAPI

[Former Member]

Hi,

How can I insert If condition into WEBAPI I created.

Basically my requirement is to Filter on Product Hierarchy nodes.

For that purpose I followed the below steps.

Step1: In the Variable Form

I created a Combo Box with Global List of Hierarchy Nodes

Hierarchy Node ---Text

Step2: I created a WEBAPI using below code

'FILTER_NODE_IOBJNM=0HIER_NODE; FILTER_VALUE=' & @Product & '; FILTER_COLLAPSE=; FILTER_IOBJNM=ZPRODUCT;'

And it is working correctly when the user selects the corresponding node and the relevant node results are displayed.

In BW as it is a custom Hierarchy there is no node for ALL which includes all the nodes.

My requirement is when the user selects ALL from the dropdown list of product it should display all the Hierarchy nodes available in Global List.

So for that I reason I am planning to inset a IF...Condition in my WEBAPI...,I tried in different syntax is not working.

I created any Entry with blank key in Global List for all

Please update me with the required syntax

IF (Product=u2019 u2018,N1:N2:N3:N4, 'FILTER_NODE_IOBJNM=0HIER_NODE; FILTER_VALUE=' & @Product & '; FILTER_COLLAPSE=; FILTER_IOBJNM=ZPRODUCT;')

(If product is null then it should display results for all nodes else apply the filter condition)

I am using VC 7.1

Thanks in advance

[Former Member]

Please update