8 – How to enable sort by click for displaying the views table according to the index of the search API?

I'm trying to create a view with a table view based on the index of the search API (search in the database), with sorting by column (set of columns defined as Sortable in the display settings). However, this option is not available for my fields of view, that they are based on string or fulltext API search fields. Is there anything I can do to activate this?

I'm using the latest Drupal 8.7.x API nad Search 1.12


It seems that the availability of sort by click is determined in Drupalsearch_apiPluginviewsfieldSearchApiFieldTrait::clickSortable method. The inside check that fails because the field definition table does not contain search_api field key. So, is there anything I can do to add it?

BTW. Support for sorting by click has been added in https://www.drupal.org/project/search_api/issues/2816979. Some problems related to SOLR have been mentioned, but are related to my use case.

finite automata – construction of a transition table from dfa-minimization equivalence

I'm trying to minimize a DFA.

From the state transition diagram, I formed the table:


And the equivalence 0 is: {q0, q1, q3, q4, q5, q6, q7}, {q2}

And the equivalence 2 corresponds to {q0, q4}, {q6}, {q1, q7}, {q3, q5}, {q2} and to 3 equivalences.

If I write q0q4 together, what would I write as a value in the table?

Now, what is the minimized DFA transition table?

database design – Can I show a relation – "In this table or in this one" in the ER diagram?

I create a database for processing leave requests at a university institute. Since there is a hierarchy in such institutes and I have to keep track of the people who occupied these positions, for example, "Dean", I set up an "archived_cross_cutting_faculty" table in addition of "current_cross_cutting_faculty", where cross_cutting_faculty means "the type". is dean or something else besides being a faculty.
To have a list of retired professors, I have table_drawn_faculty in addition to the table of professors.

Now, the faculty listed in archived_cross_cutting may be a retired faculty, so perhaps in the retired_faculty table. Or maybe he's present at the professors table, ie he's currently a teacher but he's not a dean for the moment .

Can this relation be shown in the ER diagram? Which one in archived_cross_cutting_faculty is in either the faculty table or the retired_faculty table? How? 'Or' What?

python – How to inherit users and store them in a new table?

Odoo10 Python 2.7

I want to inherit Odoo's default users since Odoo creates the users and I'm not going to reinvent the wheel. Thus, I appear in a detachable drop-down field of all users, as in this video. After showing that they can be stored in my table person in a field with the attribute '#'Store=True& # 39 ;. The latter, I can not check because it gives me an error.


class gestión_personas(models.Model):
    _name = 'gestión_personas.persona'
    _inherits = {'res.partner': 'partner_id',}
    name = fields.Char(string="DNI", required=True, help="Introduce un DNI")
    partner_id = fields.Many2one('res.partner', ondelete='cascade', required=False, Store=True)



Odoo server error

    Traceback (most recent call last):
  File "/home/javier/proyectos/odoo10/odoo/http.py", line 642, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/home/javier/proyectos/odoo10/odoo/http.py", line 684, in dispatch
    result = self._call_function(**self.params)
  File "/home/javier/proyectos/odoo10/odoo/http.py", line 334, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/home/javier/proyectos/odoo10/odoo/service/model.py", line 101, in wrapper
    return f(dbname, *args, **kwargs)
  File "/home/javier/proyectos/odoo10/odoo/http.py", line 327, in checked_call
    result = self.endpoint(*a, **kw)
  File "/home/javier/proyectos/odoo10/odoo/http.py", line 942, in __call__
    return self.method(*args, **kw)
  File "/home/javier/proyectos/odoo10/odoo/http.py", line 507, in response_wrap
    response = f(*args, **kw)
  File "/home/javier/proyectos/odoo10/addons/web/controllers/main.py", line 899, in call_button
    action = self._call_kw(model, method, args, {})
  File "/home/javier/proyectos/odoo10/addons/web/controllers/main.py", line 887, in _call_kw
    return call_kw(request.env(model), method, args, kwargs)
  File "/home/javier/proyectos/odoo10/odoo/api.py", line 689, in call_kw
    return call_kw_multi(method, model, args, kwargs)
  File "/home/javier/proyectos/odoo10/odoo/api.py", line 680, in call_kw_multi
    result = method(recs, *args, **kwargs)
  File "/home/javier/proyectos/odoo10/odoo/addons/base/module/module.py", line 412, in button_immediate_install
    return self._button_immediate_function(type(self).button_install)
  File "/home/javier/proyectos/odoo10/odoo/addons/base/module/module.py", line 486, in _button_immediate_function
    modules.registry.Registry.new(self._cr.dbname, update_module=True)
  File "/home/javier/proyectos/odoo10/odoo/modules/registry.py", line 83, in new
    odoo.modules.load_modules(registry._db, force_demo, status, update_module)
  File "/home/javier/proyectos/odoo10/odoo/modules/loading.py", line 377, in load_modules
    loaded_modules, update_module, models_to_check)
  File "/home/javier/proyectos/odoo10/odoo/modules/loading.py", line 270, in load_marked_modules
    perform_checks=perform_checks, models_to_check=models_to_check
  File "/home/javier/proyectos/odoo10/odoo/modules/loading.py", line 182, in load_module_graph
    _load_data(cr, module_name, idref, mode, kind='data')
  File "/home/javier/proyectos/odoo10/odoo/modules/loading.py", line 96, in _load_data
    tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
  File "/home/javier/proyectos/odoo10/odoo/tools/convert.py", line 845, in convert_file
    convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
  File "/home/javier/proyectos/odoo10/odoo/tools/convert.py", line 915, in convert_xml_import
    obj.parse(doc.getroot(), mode=mode)
  File "/home/javier/proyectos/odoo10/odoo/tools/convert.py", line 796, in parse
    self.parse(rec, mode)
  File "/home/javier/proyectos/odoo10/odoo/tools/convert.py", line 799, in parse
    self._tags(rec.tag)(rec, de, mode=mode)
  File "/home/javier/proyectos/odoo10/odoo/tools/convert.py", line 707, in _tag_record
    id = self.env(context=rec_context)('ir.model.data')._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
  File "/home/javier/proyectos/odoo10/odoo/addons/base/ir/ir_model.py", line 1238, in _update
    record = record.create(values)
  File "/home/javier/proyectos/odoo10/odoo/models.py", line 3851, in create
    record = self.browse(self._create(old_vals))
  File "/home/javier/proyectos/odoo10/odoo/models.py", line 3912, in _create
    parent_id = self.env(parent_model).create(parent_vals).id
  File "/home/javier/proyectos/odoo10/odoo/addons/base/res/res_partner.py", line 534, in create
    partner = super(Partner, self).create(vals)
  File "/home/javier/proyectos/odoo10/odoo/models.py", line 3851, in create
    record = self.browse(self._create(old_vals))
  File "/home/javier/proyectos/odoo10/odoo/models.py", line 3946, in _create
    cr.execute(query, tuple(u(2) for u in updates if len(u) > 2))
  File "/home/javier/proyectos/odoo10/odoo/sql_db.py", line 154, in wrapper
    return f(self, *args, **kwargs)
  File "/home/javier/proyectos/odoo10/odoo/sql_db.py", line 231, in execute
    res = self._obj.execute(query, params)
ParseError: "new row for relation "res_partner" violates check constraint "res_partner_check_name"
DETAIL:  Failing row contains (13, null, 1, null, null, null, 2019-11-17 14:35:03.690234, 0, t, null, null, null, null, null, null, null, null, null, f, null, null, f, null, es_ES, null, null, null, f, 2019-11-17 14:35:03.690234, null, null, 1, t, 1, null, null, null, contact, f, null, null, null).
" while parsing /home/javier/proyectos/odoo10/addons/gestion_curricular/data/data.xml:19, near


Please, pass the knowledge of the master to a citizen like me in codeigniter "No single table / alias:" detail "

get_santri_certificate function ($ detail_id)

$ q = $ this-> db-> query ("select detail. *, student.name from detail
detail of the inner join on detail.detail_student_id = student.name

where detail.detail_student_id = ". $ student_id);
returns $ q-> row ();


drupalgap – How to get the value of the selected row in the table selection

Please help with tableselect element
I want to get data from one of the verified lines.
Here is the source:

$options = array();
$nodes = db_query("SELECT order_id, order_number, created, status FROM {commerce_order}");
foreach ($nodes as $nid=>$node){
  $options($nid)() = $node->order_number;
  $options($nid)() = format_date($node->created, 'short');
  $options($nid)() = $node->status;
  //$options($nid) = array('order_number' = $node->order_number,
  //'order_date' = format_date($node->created, 'short'),
  //'status' = $node->status);

 $header = array(
 $form('table_select') = array(
    '#type' => 'tableselect',
    '#header' => $header,
    '#options' => $options,
    '#empty' => t('No content available.'),

$onumber = array_filter($form_state('values')('table_select'));

foreach ($onumber as $numb) {


$numb is a table of references that I need to get data.

javascript – Why can not I save several .values ​​in the table?

//Variaveis Globais
var d = document;
var Nomes = ();

function processar(idTabela) //Inserir Linhas e Verificar se ja foi escrito o nome
	var newRow = d.createElement('tr');
	newRow.insertCell(0).innerHTML = d.getElementsByName('Nome')(0).value;
    newRow.insertCell(1).innerHTML = d.getElementsByName('Idade')(0).value;
    Nomes.push = d.getElementsByName('Nome')(0).value;

    return false;


First name: Age:

magento2 – Table or base view not found: 1146 The table & # 39; magent7.catalog_url_rewrite_product_category & # 39; does not exist

I migrate from Magento open source 1.9 to 2.3.3
the initial migration has gone well, however, I'm trying to do a delta migration using the Magento migration tool.

Execution of the delta command for the migration tool gives me the error

Base table or view not found: 1146 Table
'magent7.catalog_url_rewrite_product_category' does not exist

Although the table exists, but I think the tool does not add the prefix of the database before forming the query.
Any help is appreciated.

Thank you

list manipulation – How to make table headers

In the code below, how can I add (from left to right) the column headers "n", "pp", "aa"? There is also an offset in the alignment on the generated lines.

Clear(a, pp, aa, n)
a = 15;
P(n_) := (1/2)^n
Payoff(n_) := 10 Exp(-n)
pp = N(Table({n, P(n)*Payoff(n)}, {n, 1, a}));
aa = N(Accumulate(Table(P(n)*Payoff(n), {n, 1, a})));
TableForm(Table({pp, aa}, 1))

Inductively proving the number of lines of a truth table with n atomic propositions is 2 ^ n

Thanks for contributing an answer to Computer Science Stack Exchange!

  • Please make sure to respond to the question. Provide details and share your research!

But to avoid

  • Ask for help, clarification, or answer other answers.
  • Make statements based on the opinion; save them with references or personal experience.

Use MathJax to format equations. MathJax reference.

To learn more, read our tips for writing good answers.