"ref_idea" added beside Idea table name while reporting.

[Aman Thakur]

While reporting on "sysapproval_approver" table, when I try to set a filter using "Approval For --> Idea" , I see some text added beside Idea that was not present before. I wanted to know if I can either remove it or change it to idea.
Please refer the screenshot below.

Thanks.

[Kieran Anson · Accepted solution]

You'd need to rename one of the tables. For example rename "Idea" for im_idea_core to "Idea Core"

[Aman Thakur]

Thanks @Kieran Anson , it worked.
But why did it add "ref" to the beginning of the name. Is this how SNOW deals with tables having the same labels?

[Kieran Anson]

Hi Aman,

Usually if a name is duplicated it'll just show the table name.

The inclusion of the "ref_" is a dot-walk feature in SN. The "Approval for" field is based on task, but to access fields on a child table (of task, or any child of a base table) we use "ref_" as a notation.

[Aman Thakur]

Got it. Thanks again @Kieran Anson.