{"id":29103,"date":"2024-05-22T12:14:28","date_gmt":"2024-05-22T12:14:28","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=29103"},"modified":"2024-05-22T12:16:24","modified_gmt":"2024-05-22T12:16:24","slug":"how-to-make-use-of-sage-x3s-dashboard-to-display-data-from-other-tables","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2024\/05\/22\/how-to-make-use-of-sage-x3s-dashboard-to-display-data-from-other-tables\/","title":{"rendered":"How to make use of Sage X3 dashboard to display data from other tables"},"content":{"rendered":"\n

Retrieving data from a single table for the Sage X3 dashboard is straightforward. However, if you require data from multiple tables or linked tables, attempting to add a field from those tables triggers an error message: “Standard Query ‘QUERY_CODE’: Links not possible.” In our recent blog post, we’ve provided a clear solution to address this issue.<\/p>\n\n\n\n

Step 1:<\/u> <\/strong>The error that appears when you add a field from a different table is as follows.<\/gwmw><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Fig 1: Error 1_Linked not possible<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Fig 2 Error 2_Record de-activated<\/strong><\/gwmw><\/gwmw><\/p>\n\n\n\n

This issue will appear when you add a field from another table without linking it to an existing table. To resolve it, save the flow and select “YES” when prompted. Your query tool will then be immediately deactivated. refer below image.<\/gwmw><\/gwmw><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Fig 3_Query tool<\/strong><\/p>\n\n\n\n

To activate and make tables usable, correctly link them using the “Link” section in the Advanced tab.<\/p>\n\n\n\n

Begin by incorporating the required fields from another table into the fields tab grid, as indicated in the following additions. This step simplifies the linking process and extends the functionality of the tables.<\/gwmw><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Fig 4_Fields<\/strong><\/gwmw><\/p>\n\n\n\n

We’ve included the ‘TEXTE’ field from the ATEXTRA table to showcase additional descriptions on the dashboard. This enhancement simplifies the process while expanding the information available for display.<\/p>\n\n\n\n

Step 2 :<\/u><\/strong><\/p>\n\n\n\n

Once you’ve added the necessary fields from other tables, proceed to link them with the tables whose data or fields will be displayed on the dashboard. This step streamlines the process and broadens the scope of information available for display.<\/p>\n\n\n\n

To establish the connection between tables, you’ll require the index key of another table. Follow the process outlined below to effectively link the tables. This method simplifies the task and ensures seamless data integration.<\/gwmw><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/gwmw><\/gwmw><\/p>\n\n\n\n

To link tables, navigate to the “Links” section found in the Advanced tab.<\/p>\n\n\n\n

Input the index key of the other table to establish a link between tables. For example, as shown in the image above, we’ve linked the PREQUIS table with the ATEXTRA table. This process streamlines data connectivity and facilitates seamless interaction between tables.<\/p>\n\n\n\n

The data used for linking tables.<\/u><\/strong><\/p>\n\n\n\n

Index key of ATEXTRA table :<\/strong><\/p>\n\n\n\n