Need to show list of keys for a table object/variable in AL code
While working in AL code, it is important the intellisense lists all the keys for the table object or variable (similar to the list of table fields). This will improve accuracy and speed of working with AL code. It is suggested to list the keys in the following methods when a " symbol is entere...
Missing SQL Query Hint for the Extension table
It seems like in the SQL issued by the system, the extension table is missing query hint such as WITH(READUNCOMMITTED). These query hints are vital for better performance, especially to avoid blocking and deadlocks. The captured SQL command is attached to this request. Also while referring the ex...
SQL Command issued by the system needs to be refined not to refer to the extension table for better performance
SQL Command issued by BC needs to be refined so that when the AL code does not access fields from the extended table, it should only refer to base table. For example the following code should not refer to any sales line extensions as all the fields in the following codes are from the base applic...