I have created a AOT query, it uses 6 tables, but one table isn’t shown in the query prompt window (above ranges). Also when I add a field from this table as a range, user can’t fill the criteria field for it because the field not in the list. Even if you try to add a new line, the table isn’t shown in the dropdown.
The strange thing is that I filled the value for this range in the properties and it worked! I checked the generated SQL statement, also double-checked it in SQL management studio and it works correctly. The filter is working, also the join works (join also works even if you don’t specify anything in the range).
But I need to see the range in the prompt window. What could be the reason for this?
By the way, I’m working in AX 2012.