"MySQL query" Query the "Multilevel Dropdown" value of the current record, display the number

[yaoying]

"MySQL query" Query the "Multilevel Dropdown" value of the current record, display the number

[Didou12]

It's normal.

It displays the value of the field which is the id parent in the list (top level), and the id.

To get the name of the id value,

use entity_item_value() https://docs.rukovoditel.net/index.php? ... ure_in_3.0

or you can use PHP (with dynamically execution if you don't want to store it in the database)

[yaoying]

How does the field type "MySQL query" get the "Multilevel Dropdown" field value?

"MySQL Formula" uses 'use entity_item_value()' incorrectly?

[shandybt]

i have same issue

any solution

[enishemed]

I think you are using the formula in the wrong way.

It should be something like this.

Let say we have two entities.

Projects (entity id 21), fields:

• 1. Name, input field ,
  2. Status, dropdown field,
  3. Start date, date field,
  4. End date, date field

Customers (entity id 22), fields:

• 10. Customer name, input field,
  11. Address, input field,
  12. Customer type, dropdown field,
  13. Project, entity field, (Project Entity selected)
  14. Project Status, Mysql Formula Field

Here, in mysql formula field, the code should be like this:

Code: Select all

entity_item_value(13,2)

Be careful, the id of the entity is 21, but in entity_item_value() function, I use the 13 (not 21), because
n Customer Entity, I use an entity field (using project entity) and the id of entity field is 13.