Browse By Tags

  • C# SQL Date Query

    Good day all, I am trying to create a dynamic report to produce the time it take between starting an activity and ending an activity. I can get the information I am looking for by using SQL, but it will not limit the returns based on dates. I have tried…
  • The Importance of Data Transparency

    More isn’t more No one would be surprised to hear that more and more data is generated every year. Statistics show that there are about 99,000 Google searches every second. That equates to roughly 8.5 billion searches per day on Google. In 2022, there…
  • SQL Server Reporting Services (SSRS) via HTTPS in Innovator Release 2023. How to fix?

    Hi community, the release notes of Innovator 26 mentions following fixed issue: I-050277 Fixed an error that prevented Aras Innovator from connecting to SQL Server Reporting Services via HTTPS. I did a quick test in Release 2023 and noticed that…
  • Run Aras Report from Method

    Good day all, How do I run an Aras report from a Method? I have several reports that I have created in Aras (not MS Report Services) and I can't figure out how to run one from a method. I'm trying to create a Modal Dialog so the use can pick the report…
  • Define context item for query called via method

    Hi, I am referencing this blog post: https://community.aras.com/b/english/posts/using-query-definitions-method-code I am running a query via method, how can I set the condition as the query seems to return all possible results without a context…
  • Context from method to called email

    I've got an email that I'm calling from a "post" method on the Part lifecycle, but the default context that's passed to that email message isn't the Part, it instead seems to be the alphabetically first Identity in my database? Why is this happening…
  • SQL Report Error - itemtype doesn't have a prefix

    Good day all. This error just started with a couple of our reports. I have not made any updates to the RDL files, so I don't understand why this is occurring. Any help would be greatly appreciated. Thank you.
  • Report Query Question

    Good day all, I am trying to figure out why I can't a couple of reports to run. I know part of the problem is that our database does not use the OOTB Part ItemType. Our Parts List is a document ItemType and it links (weirdly) to our Part. I have this…