Forum

If you create some query and one of the table fields name is the same as the table name you can get an ambiguous field problem generated by query builder.

Example: Imagine that you have InformationRegister.Names table and that table have Names attribute. Query builder will generate query like this:

"SELECT
      |   COUNT(Names.Cedula) AS Cedulas
      |FROM
      |   InformationRegister.Names AS Names";

Hello, Alexey!

Could you please create a sample configuration and provide the version of platform where you experience this problem?

You can just rename table name in your query:

"SELECT
|   COUNT(IR_Names.Cedula) AS Cedulas
|FROM
|   InformationRegister.Names AS IR_Names";

Yes, Valerii, I know that renaming the table solves the problem, I just wanted to notify you so you can enhance platform behavior. For the beginner it could be challenging to figure it out.

Alexey, I tried to reproduce this issue and the name of the table that the query builder created was not Names, but InformationRegisterNames, and there was no that problem.

Could you please create a sample configuration and provide the version of platform where you experience this problem?

8.3.6.2100
Empty configuration is fine to reproduce it. Just create one Information register - Names
and create one attribute (dimension) "Id" and value attribute "Names".

And create query in builder to count Ids

Thank you, I will send this to the developer team.

On 8.3.8 I received following error message:

Yes, this is the message. You are welcome