Reports

Hello, I have create a Process Task Report having as Report Context multiple processes. I used the a!queryProcessAnalytics to retrieve the data, the only problem is if in column "Assigned to" (tp!assignees) if I have multiple assignments (Group1 and Group2 or Group1 and User1) I won't be able to retrieve the tasks based on the loggedinuser and the groups that is member of (having only one assignee it works.) logicalexpressions: a!queryLogicalExpression( operator: "OR", filters: a!localVariables( local!groups: getgroupsformemberuser(user: ri!user), { a!forEach( items: local!groups, expression: a!queryFilter( field: "c1", operator: "in", value: fv!item, applywhen: not(rule!APN_isBlank(ri!user)) ) ), a!queryFilter(

I have created a "CRD column" in process report which is required to take the data from "CRD column" in User database table. I tried querying the data and indexed it but it's not populating the column with data in the process report. The column is populating null. Please suggest me alternate solution so that I can achieve this data populating. index(rule!CP_QRY_User( username:pv!username, returnCdt:true, pagingInfo:a!pagingInfo( startIndex:1, batchSize:1 ) ),"crd",null) i was using this expression to get data for respective column in CRD defintion in the process report.

Hello, Can anyone help me in this: How to hide these categories text(Qt1, Qt2, Qt3, Qt4) from column chart? Also, numbers/range(0-100) from y axis column? Note: For this column chart configuration, I am using records. Thanks

Hi everyone,  I'm having a grid field that shows data from a process model based report by using a!queryProcessAnalytics() query. I set up a manual refresh button that updates a reference local variable's value (local!refreshCounter), so that whenever user clicks the refresh button, the report value will be updated if there is any new active process task.  However, the process was not refresh unless I refresh the whole page (F5). I'm I doing it wrong? a!localVariables( local!refreshCounter: 1, local!datasubset: a!refreshVariable(value: a!queryProcessAnalytics( report: , contextProcessModels: , query: a!query( pagingInfo: a!defaultValue(ri!pagingInfo,a!pagingInfo(1,-1)), logicalExpression: a!queryLogicalExpression( operator: "AND", logicalexpressions: { a!queryLogicalExpression( operator: "AND", ignorefilterswithemptyvalues: true, filters: /*Status */

Hello everyone, I have a main process model that contains an input form. I would like to allow users in allowed group to access this input form from my task list interface. I have configured a Task report based on my main process and use the task Id for the process task link in the task list. However when I click on the task from My task list, it is showing "The task may have been deleted or completed by another assignee". What will be the possible solution for this error?' By far I have checked these areas:  - Input form's assignment tab is assigning to a group that contains my account.  - Process is chained probably. - The task ID that I clicked to open is still active (is at the input form node). Could anyone help? Thank you!

We have built a reporting framework that allows customers to customize columns and filters to generate a custom report. The customer is asking for more flexible filtering, including defining operators between filters and grouping filters, basically a UI for building logical expressions. Furthermore, the customer has more complex reporting requirements such as generating reports with dynamic columns, based on selected filters. We have a potential solution for the flexible filtering requirement, but we have performance concerns as our current filter framework uses nested CDTs Are there any existing solutions or examples of report builders / query builders in Appian? Also, what is Appian's recommendation for handling complex reporting / data analysis?  Thank You

HiWe have a process model having a user input task having a pv of record type variable. Now when we give that process model in a process report and try to map the pv values inside the report, the record type fields are not getting displayed. But another pv of integer type is giving value inside the report. Both the integer value and record type value are present in the pv level. Please let me know if there is anything I am missing.TIA

Hi I have created a functionality in Appian to show complaint details in a grid where i have Complaint logged date. Additionally, I've set up a report tab where the same information can be exported. However, I encountered an issue with date discrepancies after changing Appian locale time zone Central America to New Zealand. The complaint logged dates in the grid and report are different now. How can I resolve this?.

Hi,  I was extracting the list of all process models using send email node in PROD using system logs. hc-process-nodes and hc-process-models files displays the process models and nodes but the list is not comprehensive. hc-process-models excel file does not contain all the process models. 1. How can I get list of all process models in PROD environment. 2. How can I get list of all process models using "send email" node in process models. 3. How can I get list of all process models using "receive message event".

Hi Folks, Is there any other approach we can use for displaying active tasks on UI except the active task report and storing in DB and fetching it.

How do I edit these labels when getting data from a Record Type?I see in docs, that you can edit the labels when using a!chartSeries, but in my case I'm not using that. My code for barChartField looks like this:

Hi All, For Generating this excel sheet I have used one template that has logo as image in one cell. But the generated one removed the logo image. I am using Export DSE to Excel and using Update document where I have given the template document. The required update to the template will be given custom cell positions and the respective values. But the formats and background color are getting removed Plus the image of logo is also removed. The cells in 2 nd and 4 th column gets data from SS and the bg color gets removed while generating this. Please suggest any plugin or solution for this. Regards, Kavya

Hi All,  One of our process report is not showing correct data, it was working fine few days back but suddenly it is removing few data.  In process report performance details have got this error: Comparison (Evaluation of Status) (EVAL:@reason=rank)  What does this error means and how to resolve this. Thanks.

Hi team, i have requirement to implement of column chart to show number of cases created with in the year, by highlighting the current month with different color. i couldn't able to complete logic here a!chartseries (color:?), a!localVariables( local!casescountbyyear: { 4, 5, 6, 7, 8,5,7,8,3,2,8,9}, { a!cardLayout( contents: { a!columnChartField( categories: { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" }, series: { a!chartSeries( label: "Cases", data: local!casescountbyyear ) }, showLegend: false, showTooltips: true, allowImageDownload: true, colorScheme: a!colorSchemeCustom(colors: { "#3d85c6", "#9d225f", }) ), },

a!formLayout( label: if( ri!isUpdate, "Update Assessment", "Create Assessment" ), contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!richTextDisplayField(label: local!consequence), a!dateField( label: "Perform Date", labelPosition: "ABOVE", required: true, value: ri!record['recordType!{c09e0e7e-5af6-43ec-b8ba-7fae37884015}PVS Assessment.fields.{d5ec6e7b-3eb6-4ff9-80d8-e8d66785f8a5}performDate'], saveInto: ri!record['recordType!{c09e0e7e-5af6-43ec-b8ba-7fae37884015}PVS Assessment.fields.{d5ec6e7b-3eb6-4ff9-80d8-e8d66785f8a5}performDate'] ), a!radioButtonField( label: "Assessed", choicelabels: "People", choiceValues: { 1 }, value: ri!record['recordType!{c09e0e7e-5af6-43ec-b8ba-7fae37884015}PVS Assessment.

HI All, I am trying to fetch data from the appian report and report has around 50k records. So I am using loop of batchsize 2500 to fetch the data from the Appian report using queryProcessAnalytics(), but when the startIndex becomes 10001 (i.e greater then 10k( it's giving me the following error. What's the possible solution for the same ? And is there a way if I can do it without changing any system configuration.

In the above image i am trying to show the monthly trend of production time in minutes , but i need to show this in percentage , can any one help me with this?

What's the best way to have a process report that filters for all processes that have hit the end node and its blue. Basically, this sub process was kicked off by a parent wrapper process. The parent would kick off this sub process, the user would go to the first interface, we had a timeout mechanic where if the user didnt take action within a set time, it expired and hit the end node. However, going to this end event did not end the parent process and now the process is staying open. We have since fixed this and made this End Event node a terminate node, but in our process dashboard now, theres 10,000+ processes that are stuck in active status because the node was not properly terminated and the parent process is keeping it alive. This is taking up memory in the system, and I want to try to identify all the processes where this happened so I can delete them. Is there also an easy to way mass delete these process models once I have a good report that only includes them? Our

Hi TeamI have an existing report, "All Tasks", which is an ARF file, of course.I am able to configure filters on the report to customise the report.My requirement is to show the report in a UI so a team lead can see what tasks have been, by whom, whether it is complete, and the duration of the task. Downloading the report and converting it to Excel is not an option - the requirement is to view the report on my site.I have an interface with a read-only grid that returns exactly the information required.Is it possible to add filters to a report backed UI?If so, how do I go about it?Thanks and blessings Stephen

Hello!! I have a scenario stating that, in a single column chart I want to display the multiple fields. How can we achieve this? Thanks in advance!!

How to call Power BI from Appian and show the reports in Appian. do not send the links , I have seen there is a  plugin with which we can connect to Power BI, how to render the reports & show it on Appian. basically which functions help us to call the Power BI inside an interface & How to pass the parameters to power BI from Appian?

I am calling an expression rule in task report for the context of tasks assigned to owner by creating a new column with "Edit". This newly added column with the expression rule is not populating the data in the report, but the same is working as expected while passing the data. Below is the code inside expression rule: a!localVariables( local!toDate: todate(ri!startTime), local!days: tointeger((ri!toBeExpireDate) - (local!toDate)), tointeger(todate(ri!startTime  + local!days) - todate(today()) ) startTime = tp!starttime from the report, toBeExpireDate = process variable (using this for calculating the no.of days left) Please let me know if the expression rule can be configured for column within the reports. Also, please suggest if there are any other alternatives. Note: Without calling the rule, I tried with the logic pasted above, but no luck.

Hi, I have an Excel template and I want to add information in a column to the right of the document (custom values etc). The problem is that I put a statement that doesn't return anything because I don't want it to do it automatically (if it puts the values on the right it removes all the values on the left) and then I only add the values using the custom values. what do I want. Is there a way to not put the message (I have it below) "No data available due to empty data source, applied filter/selection criteria, or fields visibility."? Thanks

Hi Everyone, Am having a Approval user input task which will be assigned to multiple persons and everyone needs to take action on it (Run one instance for each assignee). I have designed process report where every individual user can see the approval task in their queue. My query is if anyone user is rejecting the approval , all other active task assigned to multiple users need to be marked as completed in process report.Can anyone please help on this ? Thanks in Advance

I have created a task report. When I apply the 'Active' flter, what is the nature of the tasks which will be filtered out?