E9: Syntax For EpiCombo EpiFilterAppend

I’m sorry, that was actually a terrible example…

  • Left side would be the dataset column from EpiBOName “CustCnt”, so CustNum
  • Right side would be the column from your QuoteHed dataview, which is CustNum

There are two syntax types you can use. Here is the first:

  • CustNum = ‘?[CustNum,0]’ (The “,0” is used to default if the CustNum is not found)

The second way is to define a parameter and assign it in the EpiFiltersParams section. This method has to do with reusable combos:

  • CustNum = ‘?{MyParameter,0}’ (squiggly brackets)

In the EpiFiltersParams section you can then define the column to use:

  • MyParameter = ‘?[CustNum]’

Similar to below:

1 Like