Class RelatedPersonQueryService

Readonly access to an organization's related persons.

Hierarchy (View Summary)

RelatedPersonQueryService
- RelatedPersonService

Index

Constructors

constructor

Properties

Methods

get search

Constructors

constructor

new RelatedPersonQueryService(
args: { db: B2bDatabase },
): RelatedPersonQueryService
Parameters
- args: { db: B2bDatabase }
Returns RelatedPersonQueryService
- Defined in packages/entity-services/src/related-person/RelatedPersonQueryService.ts:27

Properties

`Protected` `Readonly`db

db: B2bDatabase

Methods

get

get(
    __namedParameters: {
        customerId: string;
        id: string;
        organizationId?: string;
    },
): Promise<
    {
        ok: true;
        value: | {
            address?: {
                city: string;
                countryCode: string;
                line1: string;
                line2?: string;
                postalCode?: string;
                regionCode?: string;
            };
            countryOfResidence: string;
            createdAt: Date;
            dateOfBirth?: string;
            deletedAt?: Date;
            email: string
            | null;
            id: string;
            name: { firstName: string; lastName: string; middleName?: string } | null;
            ownershipPercent?: number;
            phone: string | null;
            routeFusionDocumentsUploadedAt?: string;
            sharesAllocated?: number;
            status: "ACTIVE" | "DELETED";
            taxId?: string;
            title?: string;
            type: "BENEFICIAL_OWNER" | "CONTROL";
            updatedAt: Date;
        }
        | null;
    },
>
Parameters
- __namedParameters: { customerId: string; id: string; organizationId?: string }
  - customerId: string
  - id: string
  - OptionalorganizationId?: string
    
    When provided, scopes to a specific organization (the API path case). When omitted, scopes by customer only — used by the document flow, which knows the related person id but not its organization.
Returns Promise<
    {
        ok: true;
        value: | {
            address?: {
                city: string;
                countryCode: string;
                line1: string;
                line2?: string;
                postalCode?: string;
                regionCode?: string;
            };
            countryOfResidence: string;
            createdAt: Date;
            dateOfBirth?: string;
            deletedAt?: Date;
            email: string
            | null;
            id: string;
            name: { firstName: string; lastName: string; middleName?: string } | null;
            ownershipPercent?: number;
            phone: string | null;
            routeFusionDocumentsUploadedAt?: string;
            sharesAllocated?: number;
            status: "ACTIVE" | "DELETED";
            taxId?: string;
            title?: string;
            type: "BENEFICIAL_OWNER" | "CONTROL";
            updatedAt: Date;
        }
        | null;
    },
>
- Defined in packages/entity-services/src/related-person/RelatedPersonQueryService.ts:31

search

search(
    __namedParameters: {
        createdAt?: DbTimestampCriteria;
        customerId: string;
        ids?: string[];
        includeDeleted?: boolean;
        orderBy?: DbOrderByCriterion<
            Omit<
                PgTableWithColumns<
                    {
                        columns: {
                            countryOfResidence: PgBuildColumn<
                                "related_person",
                                SetNotNull<PgTextBuilder<(...)>>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "related_person";
                                },
                            >;
                            createdAt: PgBuildColumn<
                                "related_person",
                                SetHasDefault<SetNotNull<(...)>>,
                                {
                                    data: Date;
                                    dataType: "object date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "related_person";
                                },
                            >;
                            customerId: PgBuildColumn<
                                "related_person",
                                SetNotNull<PgIntegerBuilder>,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...) | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "related_person";
                                },
                            >;
                            data: PgBuildColumn<
                                "related_person",
                                Set$Type<
                                    SetNotNull<(...)>,
                                    {
                                        address?: ...;
                                        dateOfBirth?: ...;
                                        ownershipPercent?: ...;
                                        personReferenceId?: ...;
                                        routeFusionDocumentsUploadedAt?: ...;
                                        routeFusionRepresentativeId?: ...;
                                        sharesAllocated?: ...;
                                        taxId?: ...;
                                        title?: ...;
                                        verificationProfileId?: ...;
                                    },
                                >,
                                {
                                    data: {
                                        address?: ...;
                                        dateOfBirth?: ...;
                                        ownershipPercent?: ...;
                                        personReferenceId?: ...;
                                        routeFusionDocumentsUploadedAt?: ...;
                                        routeFusionRepresentativeId?: ...;
                                        sharesAllocated?: ...;
                                        taxId?: ...;
                                        title?: ...;
                                        verificationProfileId?: ...;
                                    };
                                    dataType: "object json";
                                    driverParam: unknown;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "related_person";
                                },
                            >;
                            deletedAt: PgBuildColumn<
                                "related_person",
                                PgTimestampBuilder,
                                {
                                    data: Date;
                                    dataType: "object date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "related_person";
                                },
                            >;
                            email: PgBuildColumn<
                                "related_person",
                                PgTextBuilder<[(...), ...(...)[]]>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "related_person";
                                },
                            >;
                            externalId: PgBuildColumn<
                                "related_person",
                                SetHasRuntimeDefault<SetNotNull<(...)>>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "related_person";
                                },
                            >;
                            id: PgBuildColumn<
                                "related_person",
                                HasIdentity<SetIsPrimaryKey<(...)>, "byDefault">,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...) | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: "byDefault";
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "related_person";
                                },
                            >;
                            name: PgBuildColumn<
                                "related_person",
                                Set$Type<
                                    PgJsonbBuilder,
                                    { firstName: ...; lastName: ...; middleName?: ... },
                                >,
                                {
                                    data: { firstName: ...; lastName: ...; middleName?: ... };
                                    dataType: "object json";
                                    driverParam: unknown;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "related_person";
                                },
                            >;
                            organizationId: PgBuildColumn<
                                "related_person",
                                SetNotNull<PgIntegerBuilder>,
                                {
                                    data: number;
                                    dataType: "number int32";
                                    driverParam: (...) | (...);
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "related_person";
                                },
                            >;
                            phone: PgBuildColumn<
                                "related_person",
                                PgTextBuilder<[(...), ...(...)[]]>,
                                {
                                    data: string;
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: false;
                                    tableName: "related_person";
                                },
                            >;
                            status: PgBuildColumn<
                                "related_person",
                                Set$Type<SetNotNull<(...)>, (...) | (...)>,
                                {
                                    data: (...) | (...);
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "related_person";
                                },
                            >;
                            type: PgBuildColumn<
                                "related_person",
                                Set$Type<SetNotNull<(...)>, (...) | (...)>,
                                {
                                    data: (...) | (...);
                                    dataType: "string";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: false;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "related_person";
                                },
                            >;
                            updatedAt: PgBuildColumn<
                                "related_person",
                                SetHasDefault<SetHasDefault<(...)>>,
                                {
                                    data: Date;
                                    dataType: "object date";
                                    driverParam: string;
                                    enumValues: undefined;
                                    generated: undefined;
                                    hasDefault: true;
                                    hasRuntimeDefault: false;
                                    identity: undefined;
                                    isAutoincrement: false;
                                    isPrimaryKey: false;
                                    name: string;
                                    notNull: true;
                                    tableName: "related_person";
                                },
                            >;
                        };
                        dialect: "pg";
                        name: "related_person";
                        schema: "b2b";
                    },
                >,
                "enableRLS",
            >,
            "createdAt"
            | "updatedAt",
        >[];
        organizationId: string;
        page?: number;
        pageSize?: number;
        statuses?: ("ACTIVE" | "DELETED")[];
        types?: ("BENEFICIAL_OWNER" | "CONTROL")[];
        updatedAt?: DbTimestampCriteria;
    },
): Promise<
    {
        ok: true;
        value: {
            hasNext: boolean;
            items: {
                address?: {
                    city: string;
                    countryCode: string;
                    line1: string;
                    line2?: string;
                    postalCode?: string;
                    regionCode?: string;
                };
                countryOfResidence: string;
                createdAt: Date;
                dateOfBirth?: string;
                deletedAt?: Date;
                email: string
                | null;
                id: string;
                name:
                    | { firstName: string; lastName: string; middleName?: string }
                    | null;
                ownershipPercent?: number;
                phone: string | null;
                routeFusionDocumentsUploadedAt?: string;
                sharesAllocated?: number;
                status: "ACTIVE" | "DELETED";
                taxId?: string;
                title?: string;
                type: "BENEFICIAL_OWNER" | "CONTROL";
                updatedAt: Date;
            }[];
            total: number;
        };
    },
>
Parameters
- __namedParameters: {
      createdAt?: DbTimestampCriteria;
      customerId: string;
      ids?: string[];
      includeDeleted?: boolean;
      orderBy?: DbOrderByCriterion<
          Omit<
              PgTableWithColumns<
                  {
                      columns: {
                          countryOfResidence: PgBuildColumn<
                              "related_person",
                              SetNotNull<PgTextBuilder<(...)>>,
                              {
                                  data: string;
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "related_person";
                              },
                          >;
                          createdAt: PgBuildColumn<
                              "related_person",
                              SetHasDefault<SetNotNull<(...)>>,
                              {
                                  data: Date;
                                  dataType: "object date";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "related_person";
                              },
                          >;
                          customerId: PgBuildColumn<
                              "related_person",
                              SetNotNull<PgIntegerBuilder>,
                              {
                                  data: number;
                                  dataType: "number int32";
                                  driverParam: (...) | (...);
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "related_person";
                              },
                          >;
                          data: PgBuildColumn<
                              "related_person",
                              Set$Type<
                                  SetNotNull<(...)>,
                                  {
                                      address?: ...;
                                      dateOfBirth?: ...;
                                      ownershipPercent?: ...;
                                      personReferenceId?: ...;
                                      routeFusionDocumentsUploadedAt?: ...;
                                      routeFusionRepresentativeId?: ...;
                                      sharesAllocated?: ...;
                                      taxId?: ...;
                                      title?: ...;
                                      verificationProfileId?: ...;
                                  },
                              >,
                              {
                                  data: {
                                      address?: ...;
                                      dateOfBirth?: ...;
                                      ownershipPercent?: ...;
                                      personReferenceId?: ...;
                                      routeFusionDocumentsUploadedAt?: ...;
                                      routeFusionRepresentativeId?: ...;
                                      sharesAllocated?: ...;
                                      taxId?: ...;
                                      title?: ...;
                                      verificationProfileId?: ...;
                                  };
                                  dataType: "object json";
                                  driverParam: unknown;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "related_person";
                              },
                          >;
                          deletedAt: PgBuildColumn<
                              "related_person",
                              PgTimestampBuilder,
                              {
                                  data: Date;
                                  dataType: "object date";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "related_person";
                              },
                          >;
                          email: PgBuildColumn<
                              "related_person",
                              PgTextBuilder<[(...), ...(...)[]]>,
                              {
                                  data: string;
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "related_person";
                              },
                          >;
                          externalId: PgBuildColumn<
                              "related_person",
                              SetHasRuntimeDefault<SetNotNull<(...)>>,
                              {
                                  data: string;
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "related_person";
                              },
                          >;
                          id: PgBuildColumn<
                              "related_person",
                              HasIdentity<SetIsPrimaryKey<(...)>, "byDefault">,
                              {
                                  data: number;
                                  dataType: "number int32";
                                  driverParam: (...) | (...);
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: "byDefault";
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "related_person";
                              },
                          >;
                          name: PgBuildColumn<
                              "related_person",
                              Set$Type<
                                  PgJsonbBuilder,
                                  { firstName: ...; lastName: ...; middleName?: ... },
                              >,
                              {
                                  data: { firstName: ...; lastName: ...; middleName?: ... };
                                  dataType: "object json";
                                  driverParam: unknown;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "related_person";
                              },
                          >;
                          organizationId: PgBuildColumn<
                              "related_person",
                              SetNotNull<PgIntegerBuilder>,
                              {
                                  data: number;
                                  dataType: "number int32";
                                  driverParam: (...) | (...);
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "related_person";
                              },
                          >;
                          phone: PgBuildColumn<
                              "related_person",
                              PgTextBuilder<[(...), ...(...)[]]>,
                              {
                                  data: string;
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: false;
                                  tableName: "related_person";
                              },
                          >;
                          status: PgBuildColumn<
                              "related_person",
                              Set$Type<SetNotNull<(...)>, (...) | (...)>,
                              {
                                  data: (...) | (...);
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "related_person";
                              },
                          >;
                          type: PgBuildColumn<
                              "related_person",
                              Set$Type<SetNotNull<(...)>, (...) | (...)>,
                              {
                                  data: (...) | (...);
                                  dataType: "string";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: false;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "related_person";
                              },
                          >;
                          updatedAt: PgBuildColumn<
                              "related_person",
                              SetHasDefault<SetHasDefault<(...)>>,
                              {
                                  data: Date;
                                  dataType: "object date";
                                  driverParam: string;
                                  enumValues: undefined;
                                  generated: undefined;
                                  hasDefault: true;
                                  hasRuntimeDefault: false;
                                  identity: undefined;
                                  isAutoincrement: false;
                                  isPrimaryKey: false;
                                  name: string;
                                  notNull: true;
                                  tableName: "related_person";
                              },
                          >;
                      };
                      dialect: "pg";
                      name: "related_person";
                      schema: "b2b";
                  },
              >,
              "enableRLS",
          >,
          "createdAt"
          | "updatedAt",
      >[];
      organizationId: string;
      page?: number;
      pageSize?: number;
      statuses?: ("ACTIVE" | "DELETED")[];
      types?: ("BENEFICIAL_OWNER" | "CONTROL")[];
      updatedAt?: DbTimestampCriteria;
  }
  - OptionalcreatedAt?: DbTimestampCriteria
  - customerId: string
  - Optionalids?: string[]
  - OptionalincludeDeleted?: boolean
  - OptionalorderBy?: DbOrderByCriterion<
        Omit<
            PgTableWithColumns<
                {
                    columns: {
                        countryOfResidence: PgBuildColumn<
                            "related_person",
                            SetNotNull<PgTextBuilder<(...)>>,
                            {
                                data: string;
                                dataType: "string";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "related_person";
                            },
                        >;
                        createdAt: PgBuildColumn<
                            "related_person",
                            SetHasDefault<SetNotNull<(...)>>,
                            {
                                data: Date;
                                dataType: "object date";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: true;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "related_person";
                            },
                        >;
                        customerId: PgBuildColumn<
                            "related_person",
                            SetNotNull<PgIntegerBuilder>,
                            {
                                data: number;
                                dataType: "number int32";
                                driverParam: (...) | (...);
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "related_person";
                            },
                        >;
                        data: PgBuildColumn<
                            "related_person",
                            Set$Type<
                                SetNotNull<(...)>,
                                {
                                    address?: ...;
                                    dateOfBirth?: ...;
                                    ownershipPercent?: ...;
                                    personReferenceId?: ...;
                                    routeFusionDocumentsUploadedAt?: ...;
                                    routeFusionRepresentativeId?: ...;
                                    sharesAllocated?: ...;
                                    taxId?: ...;
                                    title?: ...;
                                    verificationProfileId?: ...;
                                },
                            >,
                            {
                                data: {
                                    address?: ...;
                                    dateOfBirth?: ...;
                                    ownershipPercent?: ...;
                                    personReferenceId?: ...;
                                    routeFusionDocumentsUploadedAt?: ...;
                                    routeFusionRepresentativeId?: ...;
                                    sharesAllocated?: ...;
                                    taxId?: ...;
                                    title?: ...;
                                    verificationProfileId?: ...;
                                };
                                dataType: "object json";
                                driverParam: unknown;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "related_person";
                            },
                        >;
                        deletedAt: PgBuildColumn<
                            "related_person",
                            PgTimestampBuilder,
                            {
                                data: Date;
                                dataType: "object date";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: false;
                                tableName: "related_person";
                            },
                        >;
                        email: PgBuildColumn<
                            "related_person",
                            PgTextBuilder<[(...), ...(...)[]]>,
                            {
                                data: string;
                                dataType: "string";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: false;
                                tableName: "related_person";
                            },
                        >;
                        externalId: PgBuildColumn<
                            "related_person",
                            SetHasRuntimeDefault<SetNotNull<(...)>>,
                            {
                                data: string;
                                dataType: "string";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: true;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "related_person";
                            },
                        >;
                        id: PgBuildColumn<
                            "related_person",
                            HasIdentity<SetIsPrimaryKey<(...)>, "byDefault">,
                            {
                                data: number;
                                dataType: "number int32";
                                driverParam: (...) | (...);
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: true;
                                hasRuntimeDefault: false;
                                identity: "byDefault";
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "related_person";
                            },
                        >;
                        name: PgBuildColumn<
                            "related_person",
                            Set$Type<
                                PgJsonbBuilder,
                                { firstName: ...; lastName: ...; middleName?: ... },
                            >,
                            {
                                data: { firstName: ...; lastName: ...; middleName?: ... };
                                dataType: "object json";
                                driverParam: unknown;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: false;
                                tableName: "related_person";
                            },
                        >;
                        organizationId: PgBuildColumn<
                            "related_person",
                            SetNotNull<PgIntegerBuilder>,
                            {
                                data: number;
                                dataType: "number int32";
                                driverParam: (...) | (...);
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "related_person";
                            },
                        >;
                        phone: PgBuildColumn<
                            "related_person",
                            PgTextBuilder<[(...), ...(...)[]]>,
                            {
                                data: string;
                                dataType: "string";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: false;
                                tableName: "related_person";
                            },
                        >;
                        status: PgBuildColumn<
                            "related_person",
                            Set$Type<SetNotNull<(...)>, (...) | (...)>,
                            {
                                data: (...) | (...);
                                dataType: "string";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "related_person";
                            },
                        >;
                        type: PgBuildColumn<
                            "related_person",
                            Set$Type<SetNotNull<(...)>, (...) | (...)>,
                            {
                                data: (...) | (...);
                                dataType: "string";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: false;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "related_person";
                            },
                        >;
                        updatedAt: PgBuildColumn<
                            "related_person",
                            SetHasDefault<SetHasDefault<(...)>>,
                            {
                                data: Date;
                                dataType: "object date";
                                driverParam: string;
                                enumValues: undefined;
                                generated: undefined;
                                hasDefault: true;
                                hasRuntimeDefault: false;
                                identity: undefined;
                                isAutoincrement: false;
                                isPrimaryKey: false;
                                name: string;
                                notNull: true;
                                tableName: "related_person";
                            },
                        >;
                    };
                    dialect: "pg";
                    name: "related_person";
                    schema: "b2b";
                },
            >,
            "enableRLS",
        >,
        "createdAt"
        | "updatedAt",
    >[]
  - organizationId: string
  - Optionalpage?: number
    
    Defaults to 1
  - OptionalpageSize?: number
    
    Defaults to 50
  - Optionalstatuses?: ("ACTIVE" | "DELETED")[]
  - Optionaltypes?: ("BENEFICIAL_OWNER" | "CONTROL")[]
  - OptionalupdatedAt?: DbTimestampCriteria
Returns Promise<
    {
        ok: true;
        value: {
            hasNext: boolean;
            items: {
                address?: {
                    city: string;
                    countryCode: string;
                    line1: string;
                    line2?: string;
                    postalCode?: string;
                    regionCode?: string;
                };
                countryOfResidence: string;
                createdAt: Date;
                dateOfBirth?: string;
                deletedAt?: Date;
                email: string
                | null;
                id: string;
                name:
                    | { firstName: string; lastName: string; middleName?: string }
                    | null;
                ownershipPercent?: number;
                phone: string | null;
                routeFusionDocumentsUploadedAt?: string;
                sharesAllocated?: number;
                status: "ACTIVE" | "DELETED";
                taxId?: string;
                title?: string;
                type: "BENEFICIAL_OWNER" | "CONTROL";
                updatedAt: Date;
            }[];
            total: number;
        };
    },
>
- Defined in packages/entity-services/src/related-person/RelatedPersonQueryService.ts:71

Class RelatedPersonQueryService

Hierarchy (View Summary)

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

Returns RelatedPersonQueryService

Properties

`Protected` `Readonly`db

Methods

get

Parameters

customerId: string

id: string

`Optional`organizationId?: string

search

Parameters

`Optional`createdAt?: DbTimestampCriteria

customerId: string

`Optional`ids?: string[]

`Optional`includeDeleted?: boolean

organizationId: string

`Optional`page?: number

`Optional`pageSize?: number

`Optional`statuses?: ("ACTIVE" | "DELETED")[]

`Optional`types?: ("BENEFICIAL_OWNER" | "CONTROL")[]

`Optional`updatedAt?: DbTimestampCriteria

Settings

On This Page

Class RelatedPersonQueryService

Hierarchy (View Summary)

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

Returns RelatedPersonQueryService

Properties

Protected Readonlydb

Methods

get

Parameters

customerId: string

id: string

OptionalorganizationId?: string

search

Parameters

OptionalcreatedAt?: DbTimestampCriteria

customerId: string

Optionalids?: string[]

OptionalincludeDeleted?: boolean

organizationId: string

Optionalpage?: number

OptionalpageSize?: number

Optionalstatuses?: ("ACTIVE" | "DELETED")[]

Optionaltypes?: ("BENEFICIAL_OWNER" | "CONTROL")[]

OptionalupdatedAt?: DbTimestampCriteria

Settings

On This Page

`Protected` `Readonly`db

`Optional`organizationId?: string

`Optional`createdAt?: DbTimestampCriteria

`Optional`ids?: string[]

`Optional`includeDeleted?: boolean

`Optional`page?: number

`Optional`pageSize?: number

`Optional`statuses?: ("ACTIVE" | "DELETED")[]

`Optional`types?: ("BENEFICIAL_OWNER" | "CONTROL")[]

`Optional`updatedAt?: DbTimestampCriteria