IMPORTANT ANNOUNCEMENT

These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

Topic Options
#56729 - 02/05/19 03:12 PM DataSelection line conditions
Darrin Lingle Offline
OL Newbie

Registered: 01/29/19
Posts: 4
is it possible to have more than one condition for a DataSelection column?
I don't want the column line to display if that line has either the word Tax or Freight. I'm able to go into DataSelection properties, under Lines, and set it to display line if one of them (like Tax) is absent.

Top
#56736 - 02/06/19 09:09 AM Re: DataSelection line conditions [Re: Darrin Lingle]
Raphael Lalonde Lefebvre Offline
OL Expert

Registered: 10/14/05
Posts: 4956
Loc: Objectif Lune Montreal
Hi Darrin,

You can use an advanced condition in your data selection, and write an expression that look for both Tax or Freight on the line.

Here's an example:

Code:
=(pos('Tax', @(&current.line, 1, 200)) > 0) or (pos('Freight', @(&current.line, 1, 200)) > 0)



This advanced condition will be true if either Tax or Freight is found on the line. Note that it reads characters from 1 to up to 200 on the line, but if your lines can have more than 200 characters, feel free to increase the 200. (or reduce it if your lines can't be more than a certain number of characters)

Hope that helps!

Regards,
Raphaël Lalonde-Lefebvre

Top