Fields from multiple tables

[DaniloRicardoCrabi]

It is possible to do the mapping of fields from multiple tables, incrementing joins or something similar ..

[nardove]

I was about to ask the same, I would like to know if it is possible to create a query from different tables?

@DaniloRicardoCrabi did you manage to achieve this?

[nardove]

Hi @DaniloRicardoCrabi how did you get on with it?

[rajapadm]

@DaniloRicardoCrabi How did you make it? I created a view on database and used view structure to populate the fields.

[DaniloRicardoCrabi]

@rajapadm This is interesting too..
That way you have all the data in the same "table" , rigth ?

[DaniloRicardoCrabi]

I had thought about solving it like this,
for sql query ..
As only query conditions are produced,
I thought of adding the field name with the alias, as follows

https://codesandbox.io/s/charming-scott-x5lt1l

const fields: Fields = {
  programId: {
    label: 'Programa',
    type: 'select',
    fieldName: 'vcb.programId',
    valueSources: ['value'],
    operators: ['select_equals'],
    fieldSettings: {
      listValues: [
        { value: 100, title: 'Programa 1' },
        { value: 110, title: 'Programa 2' },
        { value: 120, title: 'Programa 3' }
      ]
    }
  },

  store: {
    label: 'Store',
    fieldName: 'vcb.storeId',
    type: 'select',
    valueSources: ['value'],
    operators: ['select_any_in', 'select_not_any_in'],
    fieldSettings: {
      listValues: [
        { value: 10, title: 'Loja 1' },
        { value: 20, title: 'Loja 2' },
        { value: 30, title: 'Loja 3' }
      ]
    }
  },

  customers_category: {
    label: 'Categorias',
    fieldName: 'vcb.categoryId',
    type: 'select',
    valueSources: ['value'],
    operators: ['select_any_in', 'select_not_any_in'],
    fieldSettings: {
      listValues: [
        { value: 1, title: 'Todas' },
        { value: 2, title: 'Estudante' },
        { value: 3, title: 'Taxista' }
      ],
      validateValue: (val: number, fieldSettings) => {
        return val !== 8;
      }
    }
  },
};

[DaniloRicardoCrabi]

@rajapadm @nardove Maybe that works too

  customers: {
    type: '!struct', // special keyword for comlex fields
    label: 'Clientes',
    fieldName: 'customers',
    valueSources: ['value'],
    subfields: {
      // subfields of complex field
      createdAt: {
        type: 'date',
        label: 'Cadastro',
        tooltip: 'Cadastro realizado em ',
        fieldName: `"created_at"`,
        valueSources: ['value'],
        operators: [
          'equal',
          'between',
          'less_or_equal',
          'less',
          'greater',
          'greater_or_equal'
        ]
      }
    }
  }