Discussion Categories

The task priority for the User Input Task must go to the correct outflow. But it keeps on going to bottom one ( the High Priority one ), even though I set the priority to Low. How do I configure this so that once the script task has executed, it goes to the correct outflow? Is my output correct? And this is my interface : 

Given a dictionary D , and a list of nodes N, I need to replace all existing nodes in the dictionary which are single value to list of values containing the single one. For example:   D= {foo:"bar",bar:"baz"}, N={"foo"} => {foo:{"bar"} /*converted*/,bar:"baz"/*no change*/}    D={bar:"baz",foo:{"multi","items"},nested:{foo:"bar"}}, N={"foo","bar"} => {bar:{"baz"} /*converted*/,foo:{"multi","items"}/*no change*/ ,nested:{foo:{"bar"} /*converted*/} The use case is to support conversion from XML where certain nodes should be arrays, however when converting from XML to JSON and there is  a single item under those nodes, we need it to be array and not a single object. 

I am using the Write Records smart service in a process model to take the results of a stored procedure (using the Execute Stored Procedure smart service) and update a record and the source table. When I run the process model I get the error "The input "Records" cannot contain multiple records of the same type with the same identifier". In a separate expression rule I have called the same stored procedure, tested the data and verified that there are no duplicate ids created by the expression in the id field. Can anyone tell me why Appian is giving me this error? I have attached the contents of the Records input field in the Write Records smart service.  pv!equipDataModified is a list of map with fields "equipNum", "serviceDays", and "serviceDaysPast" Thanks in advance!

HI, I am working on a daily log kind of project. So i need to 1. Take the start time and end time and calculate the number of minutes between them. eg. 6:15 am  to 8:15 am -> 120 minutes. I tried using the function  minute( todatetime(endTime)-todatetime(startTime) ) but this works only till 60 minutes. i.e. 6:15 am to 7:15 am ->0 min.  Should give 60 mins Also 2. is there any way i can only take the time as input? I have to use a!dateTimeField() Where as i dont want to get concerned with date.  Once the datetime is entered, i can use totime to get only the time. But i want the input itself to be time and not datetime.

Not able to fetch the top 3 most visited parking spots for a respective month. any suggestions

Hi Eperts, I have one senerio that : I have a dropdown list which contains 14 values in List like(BC, AB, ON,NB,CB,JK,HG,FG and so on). I want when I should be able to press the B button on my keyboard and then TAB to the next text field with the system knowing B=BC, or BA  a!dropdownField( label:"provinceLabel", labelPosition: "ABOVE", placeholder: "Select a Province", choiceLabels: cons!SCE_COPA_PROVINCE_LIST, choiceValues: cons!SCE_COPA_PROVINCE_LIST, value: ri!record.province, saveInto: ri!record.province, ) Thanks

up on a click of a button I am generating CSV file , that generated CSV file is being saved in a folder, now up on a click of another button  here I want to download the CSV file that is recently generated which is present in a folder, so How to get the document from a folder, to use in a!documentDownloadLink(), so that I can download the recent generated document

My client's requirement is to have multiple cascading filters for grid field and record doesn't support passing filter values from one user filter to another, so we are using manual filters. Hence, using OOTB record is not possible in my scenario and they want to implement the "Save Filter As" like in record as well. Please guide for efficient possible approaches available.

I'm trying to figure out the differences between Form Layout and Section Layout. Mainly, is there any reason to use a Form Layout over a Section Layout? I've been using Section Layout because I seem to be able to do everything I need with it. I understand the notion of "well, if it works for what you need, then use it". I also understand that we have the ability to nest Section Layouts (which is one main reason why I use them), but not Form Layout. However, I still continue to wonder what the actual purpose of Form Layout is for. If there is a downside to using Section Layout in lieu of Form Layout.

I'm trying to filter my task report according to either the process, name or created by field. But it's not returning any processes with these exact names. Can I filter the fields like this, for example, the process name is JT Create Incident, but can I reference only Create Incident? And with the name it changes everytime from Approve Incident to Attend To Incident. Can I just reference "Approve" or "Attend To" or should it contain the entire name / process name?

Hi, I need to know from which Appian version it's possibile using recordActionField in a gridColumn of a read-only grid with a queryEntity as data source. I need this functionality to start a related action showed in a dialog and remaining in the same interface, same status, after close it. Thanks

Not able to fetch the top 3 parking locations for repsective month. kindly help

Hi guys, I would like to create a graphically beautiful interface for sending emails with recipients, subject and body. I don't know which object I can use for "TO:" having more than one recipient.Can anyone share its interface? I need ideas to make it happen thank you

Hi. I am experimenting with data fabric features and building record views Expression Base record types with Sync On. I have 'Queue' Record type and 'Queue Item' Record type in 1:M relation. In a 'Queue' list, I need to see number of related 'Queue Items'. I have created a column for that, see below. However, the highest number it can count is 10, then it stops counting. I guess that this is caused by logic to related to logic described here: https://docs.appian.com/suite/help/21.3/fnc_system_relatedrecorddata.html (..Number of related records to return. Valid values include 1-10..) My question is, if there is some way around this? Simple count procedure should imo not be difficult enough to cause performance issues, especially in my case when the number of 'Queue' record types is low. Thanks, column definition that only returns 10: a!gridColumn( label: "Number of items in Q", sortField: 'recordType!{3c05c063-58d

I have a requirement to count number of working days in a month where Saturdays & Sundays are always week-off. Also, I need to substract national holidays like Christmas/ New Year etc. Please help me with it.

Hi Can you guys help me with the code I am trying to give validation for the condition so for  Add client  Dropdown there should be only one active status if same occurs it should throw an validation error. The issue is I tried using whercontains but add client and is active ....data type are different so it is not working

Hi, In my application I am sending emails with task/record links. The user can click on the link and the link takes him to the task/record or Appian login page, based on whether the user is logged in. I got a new requirement to count the number of clicks from email to Appian, without using any other technology outside Appian. For this, I came up with two Web API endpoints, first GET with link to itself in the email sent. GET returns HTML website with automatic POST page that utilizes second WebAPI, which runs a counting smart service and returns the original task/record link. This solution works only if user is already logged in into Appian, otherwise an ugly error is returned to the user, see below. My question is, is there some way to force the Appian Log in page in case no valid session is found when trying to use the GET API and then redirect him back to it - with the GET API being linked from an email. Thanks  error:  "error":"APNX-1-4187-000&qu

Our Requirement is , x person will upload a loan form along with his government ID Proof , in our configured idp model. So when we are in reconcile screen we need to validate the name in the application form and id proof ,if matches its fine or else we need to display an error on name field , that name doesn't match with id proof - all this tasks should be done before we click on reconcile button NOTE: We are merging the two pdfs into one (1 is loan application form and the other is his id proof ex-Aadhar) , when we upload after the idp processing , we will be routed to reconcile screen where we will accept the task and we will reconcile - there in that screen we need to validate two documents . (like example- name in the application should match name in the aadhar card) is , there any way to solve this problem .

Hello. I currently have a database table with thousands of news from different dates. I would like to create a query that brings me the news by days and by month, but not by year. For example, the news of July 4 from different years. Thank you for your help.

5 54 543 5432 54321

Hi 1 or more paths can exit an OR gateway. If more than 1 paths exit an OR gateway, how can I make the paths back to one path? Thank you

Not able to fetch the top 3 most visited spots for a repective month with below mentioned code. Kinldy suggest { rule!VPA_CMPT_CardDisplayHeader( title: "Most Visited Parking Spot By Month", icon: "parking" ), a!columnChartField( data: a!recordData( recordType: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey' ), config: a!columnChartConfig( primaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{2a9520d6-8de2-413f-ad99-7e1ed16d8291}dateCreated', alias: "dateCreated_primaryGrouping", interval: "MONTH_SHORT_TEXT" ), secondaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{08a08942-2bd1-4dc1-902d-6d434e17bbef}parkingLocationName', alias: "parkingLocationName_secondaryGrouping" ), measures: { a!measure( function: "DISTINCT_COUNT", field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VP

I am not able to fetch the top 5 most visiting spots for respective month. { rule!VPA_CMPT_CardDisplayHeader( title: "Most Visited Parking Spot By Month", icon: "parking" ), a!columnChartField( data: a!recordData( recordType: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey' ), config: a!columnChartConfig( primaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{2a9520d6-8de2-413f-ad99-7e1ed16d8291}dateCreated', alias: "dateCreated_primaryGrouping", interval: "MONTH_SHORT_TEXT" ), secondaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{08a08942-2bd1-4dc1-902d-6d434e17bbef}parkingLocationName', alias: "parkingLocationName_secondaryGrouping" ), measures: { a!measure( function: "DISTINCT_COUNT", field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{628f5a50-0f39-45ca-

I want to show only top 5 secondary grouping categories for respective month. {rule!VPA_CMPT_CardDisplayHeader(title: "Most Visited Parking Spot By Month",icon: "parking"),a!columnChartField(data: a!recordData(recordType: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey'),config: a!columnChartConfig(primaryGrouping: a!grouping(field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{2a9520d6-8de2-413f-ad99-7e1ed16d8291}dateCreated',alias: "dateCreated_primaryGrouping",interval: "MONTH_SHORT_TEXT"),secondaryGrouping: a!grouping(field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{08a08942-2bd1-4dc1-902d-6d434e17bbef}parkingLocationName',alias: "parkingLocationName_secondaryGrouping"),measures: {a!measure(function: "DISTINCT_COUNT",field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{628f5a50-0f39-45ca-a0e1-25c645fcb9d3

I want to show only top 5 secondary grouping categories for respective month. { rule!VPA_CMPT_CardDisplayHeader( title: "Most Visited Parking Spot By Month", icon: "parking" ), a!columnChartField( data: a!recordData( recordType: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey' ), config: a!columnChartConfig( primaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{2a9520d6-8de2-413f-ad99-7e1ed16d8291}dateCreated', alias: "dateCreated_primaryGrouping", interval: "MONTH_SHORT_TEXT" ), secondaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{08a08942-2bd1-4dc1-902d-6d434e17bbef}parkingLocationName', alias: "parkingLocationName_secondaryGrouping" ), measures: { a!measure( function: "DISTINCT_COUNT", field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{628f5a50-0f39-