Reports

Hello Community, I try to get a task identifier specifc to a process instance. when I use this, I get 6 identifiers, they match the 6 instances in the record list: a!queryProcessAnalytics( report: cons!MY_REPORT, contextProcessModels: cons!IPAY_TEST_FOR_RECORD_PM, query: a!query( pagingInfo: a!pagingInfo(startIndex: 1, batchSize: -1) )).identifiers, I would like to pass the fv!identifier in the record or pp!id to get the specific identifier of the process instance in the list of 6, then use that in a link to the open task in the record list. 1067516(Number (Integer)) 1067535(Number (Integer)) 1067554(Number (Integer)) 1067612(Number (Integer)) 1067574(Number (Integer)) 1067600(Number (Integer)) when I use contextProcessIds: pp!id, it wont work. How to query or is there another solution. KInd Regards, Erik

We have a use case, where a user wants to see both the older as well as new updates made to any field of a record, when pulled out in an excel from Appian Application/Interface.   For example, a record with Car's mileage, Initial Value = 10000, and then Updated Value (after 1 month) = 12000, Updated Value (after 3 month) = 52000   The user wants to see all these entries in the "Records", i.e 10000, 12000, 15000, etc., along with a time stamp (Created or updated date), and updated by.   Below is a sample table/report that the user wants as an output for the above use case.   Car Mileage Created On Updated by Comments ABC 10000 11/2/2021 Emp1 This is the initial value ABC 12000 12/2/2021 Emp2 First Update ABC 15000 13/2/2021 Emp3 Second Update I have received responses where folks in the community has suggested the following: via a Historic CDT Plugin CDT Diff Utilities So, wanted to check if there are any best practices or a 

Good morning, I need to make a report to obtain the information of all the existing nodes within the process. A perfect example would be the process node tab that appears from the monitoring inside a process instance.I don't know if it is possible to create a report with this information. Thanks

Hello everyone, I'm kind of stuck in some part of a function I want to create for a certain report. This has to be with exporting the data within the report from data export entity to excel using the a!exportDataStoreEntityToExcel() function. The issue is basically how to export more than 500 rows using this method (or another) to excel since the database only retrieve data in patch of 500 rows. I know I could export to excel patch by patch but I would like to see some approaches for this problem or relevant information that can help me to solve this exporting all the data in just one time. Thanks for your attention and I hope some of you can give me some help with this.

I want to develop a process report that will show me all the active process report started from my application. I'm using version 20.1 Requirements: 1. show all process reports that are active are are from particular application 2. I don't want to filter process models by name , or provide list of process models manually 3. I want to achieve something similar to monitoring view that is available from backend for developers. When you select application and then switch to monitoring you can see processes related to that application only. Monitoring View - Appian 21.3

Hi Team, I have created process report with context type as Tasks by process model and given the filter as active and completed. We have active process instance in monitoring tab. But still am not able to see the any entries  in report. Could you please help me on this?

I have a task report. My process has 2 tasks and in parallel has a subtask that has 3 task.. When the process starts all 5 tasks started at the same time. Parent pp!id: 1010 Child pp!id: 1011 How do I query the task report for both child and parent at the same time? I have tried making a cdt that includes parentID and passing it to child, but can not query on it as in the report cdt.parrentId is returning a list of text within list of variant when queried. And I can't use a query filter on a list of text within a list of variant. as includes, and = operators are not suitable from what i have seen.

Hi I am working on version 21.2.  I have a scenario, wherein I want my task report to display the "Task Accepted Time". I am using the function:                             gettaskacceptedtimestamp(tp!id) When I am calling this function in an expression rule, the rule is running fine and giving the date and time as per the task id passed. However, when I call this rule in the task report and pass tp!id, the value of the column remains blank. Also if I directly call this function in the task report, the value of column remains blank. Can any one please help me with this issue. Thanks in advance!!

Hello I have a requirement that I need to create an interface to show some filtered  process history. An example would be to show all email, and user input tasks that have been run for a particular process. Any ideas on a solution to grabbing this info?  I see process reports don't seem to access this data. Thanks!

Hi everyone. I'm with a problem with a property returned from a a!queryProcessAnalytics from a Report. The Report returns this data:   And I have a problem with a dp0 field that is mentioned on the column configs as the task details: I get that field in this way: And I put all that data in a grid on an interface, but sometimes I get this error: And I show it like this on the interface: Thanks for everyone who can help me with this problem!

Hello Community,  We have a requirement to monitor the maximum number of user sessions on a day in the entire environment. is there any ready made plugin available for this? Im aware that we can use login audit csv file. But this file can give only the number of user logins on a day rather this file did not furnish the details about log out for the same user.  TIA

We have a requirement to produce a stacked column chart that displays a count of completed requests split by how many working days they missed the SLA date by (e.g. completed within SLA, competed 1-2 days after SLA, completed 3-5 days after SLA, completed >5 days after SLA). Our table stores both the SLA date and the completed date so we have the data but there doesn't appear to be an easy way to calculate the number of working days between the two (so ignoring weekends and bank holidays). We had initial created a view and used the CASE operator to define a column that categorised each request as Within SLA, 1-2 days after SLA, etc., but this does not take account of non-working days so is not acceptable to the business. A search has discovered several database solutions that rely on creating and populating a calendar table that includes all the days of the year and whether they are a working day or not, but that solution relies on that table being maintained and updated wi

Hello.I am creating a column chart that shows me the companies created in a period of time, this part is done. But now I need to create an average line in the report that shows me the average number of companies created in a year. It is possible to do it in Appian, I am new and I do not know if it can be done. 

Does "Report Builder wizard" which is available as a template at the time of creating new Interface, can also be available at a site for the common users so that they can build custom report and download the same at excel format as per their personal requirement? If yes, I shall be grateful, if anyone can please explain how it can be implemented.

Hi, We are facing the below error while trying to execute the expression rule to fetch data from data base table: An error occurred while evaluating expression: listofIDtodelete:rule!abc(cons!xyz) (Expression evaluation error in rule 'abc' at function a!queryEntity [line 5]: An error occurred while retrieving the data. Details: Memory threshold reached during output conversion (rule: [queryentity expression], type: [DataReportDT7042], threshold: [1,048,576 bytes], objects successfully converted: [131,071])) (Data Outputs) Please provide your help regarding the resolution of this issue.

Hello all, I would like to use queryEntity to add a filter which uses LISTAGG function in the database view. I'm trying to add DECISION filter something like below: select * from DB_VIEW where RECEIVED_DATE > to_date('6/1/2021', 'mm/dd/yyyy') and (DECISION like ('%Disapproved%') or DECISION like ('%Approved%')); Now the issue is, we do not have 'like' value for 'operator' in a!queryFilter. How can I add 'like' operator to get the filtered result on a view in the Appian Report?

Hello, yesterday we lowered our process report timeout limit from 5000 to the standard 2000 ms but now we see a lot of errors in our log. The errore are like the following. 2021-06-01 12:43:00,375 [Appian Work Item - 147135 - execution00 : ExpressionGroupRequest] ERROR com.appiancorp.expr.server.fn.query.QueryProcessAnalytics - La generazione del report è stata annullata dal sistema dopo 2748 ms. Il limite di tempo per generare un report è 2000 ms. (APNX-1-4275-008)com.appiancorp.suiteapi.common.exceptions.AppianException: The report generation was cancelled by the system after 2748 ms. The time limit for generating a report is 2000 ms. (APNX-1-4275-008) Is there a way to identify which is the report which is throwing this error in order to improve its performance? We have a lot of process reports in our environment and they all seem efficient. I think that the issue is caused by some filter in some queryProcessAnalytics rule, but how to identify which? This error d

Hello, we are exporting DB data to excel where we have one column for Appian user id .we are using a!exportDataStoreEntityToExcel to export whioch igives all the columns as it is which are in DB but we want to convert Appian user id to first name and last name before dumping to excel. Is there any way I can do it using a!exportDataStoreEntityToExcel without saving first name and last name in DB. Any pointer will be helpful. Thanks in Advance.

Hi every one, we are trying to implement some reports regarding process behavior, task duration, average etc. but before going into a big definition I was wondering if appian contains "out of the box" this kind of reports, and if so, where can I find them or configure them ??? Ive found a related issue in the forum but fron 6 years ago, so maybe somethings have change? any help with this will be much appreciated ! Hope to hear form you soon! Regards, Diego

Hello, I have to create a report in which iam fetching the datas from Database using a function a!exportDataStoreEntityToExcel(). Is that possible to transpose the data from DB which is like Column to row or row to column using this service ?

Hi,I have  a view created in DB already, the CDT, constant and Datastore were published. I tried to create a column chart using that view in a interface using Report Builder. I cannot see the table created from view in the dropdown of tables.Can someone help!!

We already  have tasks in tempo that displays the pending tasks with basic details then we have task report where we can get the list of tasks and can edit what we need to display. Then what is the concept of custom task report and when should we consider using it?

Hello, I am trying to get the details from the task report. My task report is by Process model and i'm trying to get the assignee of each task. I am facing the issues as below: 1. With filter:  filters:{ a!queryFilter( /*c4 is the owner*/ field: "c4", operator: "in", value: loggedInUser() ), a!queryFilter( /*c6 is the task assignee*/ field: "c6", operator: "in", value: loggedInUser() ) } When my task is assigned to individual user, the assigned task filter above works and shows me all the tasks assigned to the user. But when the task is assigned to a group and the loggedin user is a member of the group, the task is not shown to the user. I have tried the operator "includes" instead of "in". In this case, all the tasks are shown, irrespective of the user being the member of the group or not. 2. the runtimetype() I want to display the assignees name(either group or user) in the grid. When i try the following code whi

Hello! I am trying to query data from a Process report, but I am facing an issue. I can show correctly the data on the process reports, but when I am using at the expression a!queryProcessAnalytics the date is null. Where might be the problem? Is the type of the process report?