Skip to main content

Please improve this code,

 

FILTER MATCH_ACTIVITIES ( "finalResult_0_005"."ACTIVITY" , NODE '<%=display_code_1%>'] ) = 1;

 

so that when nothing is assigned to the display_code_1 value, it displays all the data.

 

I tried

 

FILTER CASE WHEN '<%=displayCode_1%>' IS NULL THEN 1 ELSE MATCH_ACTIVITIES("Correlation_0_0075_remove_1st"."ACTIVITY", NODEN'<%=displayCode_1%>']) END = 1 

 

this code but it did not worked.

It returns MATCH_ACTIVITIES: Could not find activity i]. this message. 

 

Thank you

 

Hello @keonhyuk.song , please let us know if you still need assistance with this question?


Hello @keonhyuk.song , please let us know if you still need assistance with this question?

Hello @robert.mcgin , I would like to know if there is a solution to this matter please, since I'm facing the same problem. Thank you in advance!


Reply