Re: Category Filter logic [message #1124 is a reply to message #1123] |
Wed, 18 November 2020 21:55 ![Go to previous message Go to previous message](/forum/theme/myThemeWithHFCSS/images/up.png) ![Go to next message Go to previous message](/forum/theme/myThemeWithHFCSS/images/down.png) |
nbehrnd
Messages: 215 Registered: June 2019
|
Senior Member |
|
|
Hello Greg,
once the properties are stored in DW's main table, both Boolean .or. and .and. may be used for further analysis. In the example below, I extended the initial query for molecular weights greater than 110 (yielding mesitylene) to one that would accept molecules with a molecular weight of either less than 80 .or. greater than 110 by the instruction
if((TotalMolweight<80) || (TotalMolweight>110), "True", "False")
in an additional column (Data -> Add Calculated Values). As expected, the second query yields both benzene and mesitylene now.
![index.php?t=getfile&id=290&private=0](index.php?t=getfile&id=290&private=0)
It is possible to use multiple properties of different columns, too. DW's mathematics, including logic expressions, which may be used are presented on
http://www.openmolecules.org/help/jep.html
Norwid
[Updated on: Wed, 18 November 2020 21:58] Report message to a moderator
|
|
|