I have a task report and in order to build a range of filters for the data, I need to add new columns for the report. The task names are formatted to combine data about the task.
TaskName for CustomerName - CaseNumber - SellingBranch (eg FF Validate Case File for Jones - FF1234 - Glasgow)
I can use rules which split bits out of the task name to include in columns. For example, I can have a Selling Branch Column which is built from a rule which splits the task name by separator '-' and returns the final element from the array of split values.
But I need another column which takes the SellingBranch and looks up in a MySQL table to get the corresponding region - so any of Glasgow, Perth, Dundee return the region 'Scotland' and any of Brighton, Canterbury or Hastings return the region 'South'
I have an expression rule which takes in the SellingBranch name and returns a Region Name, which it gets by first using a query rule to look up the table SELLING_BRANCH to get regionId and then using a second query rule to look up table REGION to get the regionName.
When I try to use this rule in the column definition of my Task Report, it gives a blank column. I can't find any documentation to say whether this ought to work or is a restriction (Appian 17.1)
Discussion posts and replies are publicly visible