{"id":32108,"date":"2026-04-29T06:33:16","date_gmt":"2026-04-29T06:33:16","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=32108"},"modified":"2026-04-29T10:44:24","modified_gmt":"2026-04-29T10:44:24","slug":"how-to-filter-the-dashboard-on-the-home-page-based-on-the-logged-in-user-in-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2026\/04\/29\/how-to-filter-the-dashboard-on-the-home-page-based-on-the-logged-in-user-in-sage-x3\/","title":{"rendered":"How to Filter the Dashboard on the Home Page Based on the Logged-in User in Sage X3"},"content":{"rendered":"\n

Sage X3<\/a> is an enterprise resource planning (ERP) solution that helps organizations manage their business operations and data within a single integrated system. It includes various modules such as Sales, Purchasing, Inventory, Finance, and more, enabling efficient and centralized business management.<\/p>\n\n\n\n

In many business scenarios, there is a requirement to restrict or filter dashboard data based on the logged-in user. This ensures that users can only view relevant and authorized information, improving both data security and usability.<\/p>\n\n\n\n

To address this requirement, we utilized a global variable and created a formula to dynamically filter data based on the logged-in user.<\/p>\n\n\n\n

Approach and Implementation:<\/strong><\/p>\n\n\n\n

    \n
  1. First, we created a database view containing the required data for the dashboard.<\/li>\n\n\n\n
  2. This view was then imported into the Graphical Query Tool in Sage X3.<\/li>\n\n\n\n
  3. The necessary fields were selected and added to the dashboard layout.<\/li>\n\n\n\n
  4. We used the user field [ZDEMO]CREUSR_0, which stores the creator or user information.<\/li>\n<\/ol>\n\n\n\n

    New Stuff:<\/strong> How to Resolve \u201cIndex Incorrect FLD(80)\u201d Error in Stock Transaction Inquiry Screen in Sage X3<\/a><\/p>\n\n\n\n

    \"Fig<\/a><\/center> \n
    Fig 1- Graphical query tool<\/center><\/font>\n\n\n\n

    In the Selection Criteria section of the Graphical Query Tool, we applied a formula using the global variable to filter records based on the logged-in user.<\/p>\n\n\n\n

    \"Fig<\/a><\/center> \n
    Fig 2- Selection tab in graphical query tool<\/center><\/font>\n\n\n\n

    This configuration ensures that only the data relevant to the current user is displayed.<\/p>\n\n\n\n

    Output:<\/strong><\/p>\n\n\n\n

    The final output can be seen on the home dashboard, where the data is filtered dynamically based on the logged-in user. This improves user experience, enhances data visibility, and maintains data security.<\/p>\n\n\n\n

    \"Fig<\/a><\/center> \n
    <\/font>\n\n\n\n

    Benefits:<\/strong><\/p>\n\n\n\n

    Ensures user-specific data visibility<\/p>\n\n\n\n

    Improves dashboard relevance and usability<\/p>\n\n\n\n

    Enhances data security and access control<\/p>\n\n\n\n

    Reduces data clutter for end users<\/p>\n\n\n\n

    Conclusion:<\/strong><\/p>\n\n\n\n

    Filtering dashboard data based on the logged-in user is a practical and effective approach in Sage X3. By leveraging global variables and the Graphical Query Tool, organizations can create personalized dashboards that provide meaningful insights to users while maintaining proper data governance.<\/p>\n\n\n\n

    <\/p>\n","protected":false},"excerpt":{"rendered":"

    Sage X3 is an enterprise resource planning (ERP) solution that helps organizations manage their business operations and data within a single integrated system. It includes various modules such as Sales, Purchasing, Inventory, Finance, and more, enabling efficient and centralized business management. In many business scenarios, there is a requirement to restrict or filter dashboard data\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,13],"tags":[496,732,3487,3066,1822,2330],"class_list":["post-32108","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","category-integration","tag-dashboard","tag-error","tag-home-page","tag-query-tool","tag-sage-x3","tag-user"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/32108","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=32108"}],"version-history":[{"count":10,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/32108\/revisions"}],"predecessor-version":[{"id":32118,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/32108\/revisions\/32118"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=32108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=32108"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=32108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}