3 +--------------------------------------------------------------------+
4 | Copyright CiviCRM LLC. All rights reserved. |
6 | This work is published under the GNU AGPLv3 license with some |
7 | permitted exceptions and without any warranty. For full license |
8 | and copyright information, see https://civicrm.org/licensing |
9 +--------------------------------------------------------------------+
12 namespace Civi\Api4\Query
;
17 class SqlFunctionIF
extends SqlFunction
{
19 protected static $category = self
::CATEGORY_COMPARISON
;
21 protected static $dataType = 'String';
23 protected static function params(): array {
27 'must_be' => ['SqlEquation', 'SqlField'],
32 'must_be' => ['SqlField', 'SqlString', 'SqlNumber', 'SqlNull'],
33 'label' => ts('Then'),
37 'must_be' => ['SqlField', 'SqlString', 'SqlNumber', 'SqlNull'],
38 'label' => ts('Else'),
46 public static function getTitle(): string {
53 public static function getDescription(): string {
54 return ts('If the field is empty, the first value, otherwise the second.');