%searchConditions = { 'table1.variable' => {'<', '(integer value) - table2.variable'} }; #### ... table1.variable - table2.variable < (integer value 1) AND table1.variable - table3.variable < (integer value 2)... #### %searchConditions = { 'table1.variable' => {'<', '(integer value 1) - table2.variable'}, 'table1.variable' => {'<', '(integer value 2) - table3.variable'} }; #### %searchConditions = { 'table1.variable' => {'-and' => [{'<', '(integer value 1) - table2.variable'}, {'<', '(integer value 2) - table3.variable'}]} };