1
To promote users based on their profile fields use the following configuration. Here we are going promote users that filled their `Location` default field which `FID` is `3`.

Code:
{
  "whereClauses": [
    {
      "tableName": "userfields",
      "columnName": "fid3",
      "columnValue": "",
      "columnOperator": "!="
    }
  ],
  "logicalOperator": "AND"
}


If you are using plugin version 1.8.23 or lower :
  • Table: `userfields`
  • Field: `fid3` *
  • Field Value: empty
  • Field Type: `Not equal to`

* Adjust this to fit your profile field.
1