Discussion Categories

Hi Team, I am using the below code snippet for the links column and separating multiple links using semicolons.  a!gridColumn( label: "Links", sortField: 'recordType!LA Record Link.fields.links', value: a!richTextDisplayField( label: "Real Links", value: a!forEach( items: split(fv!row['recordType!LA Record Link.fields.links'], ";"), expression: a!richTextItem( text: fv!item & char(10), link: a!safeLink( uri: fv!item, openLinkIn: "NEW_TAB" ), linkStyle: "STANDALONE" ) ) ) ) But when the user is inserting a link with the below texttool link- https://www.google.com/  it is giving an error tool link - https://www.google.com/ is not a permitted URI under the configured security rules and cannot be cast to safeUri. (APNX-1-4198-000). Even the tool record type interface is not working until I delete the record from the database.  We tested multiple cases and found if we write

Hi everyone,  I need to pass a list of INT into a parameter of a stored procedure which should look like this: UPDATE table01 SET updatedDate = now() WHERE ID in (list of ids that I will pass in); However the parameter type only accept INT, not list of INT, so not sure how can I achieve that.  Any suggestion will be much appreciated :)

What should I type in the expression editor in order to set initial value to a record as shown in the pic? I have tried typing the first couple letters but it seems that the Applian does not recognize them as affiliated functions of a record.

I'm currently trying to implement RPA to get the title, URL, etc. of each news from the news list on the news site.My RPA was able to get the information I wanted and store it in an array.However, the information cannot be saved in Appian's DB in table format. I would like to store the contents of the array that holds the acquired information in the pre-created CTD. Since the Appian document states that it is not possible to directly store data from RPA to the DB, I will implement RPA which creates a list of data saved by CDT etc. and returned this list to the process model. If you have better idea, could you tell me about it?

As the subject line says, I've noticed recently that default in Data Input fields in different smart service nodes, the "Save Into" fields are now disabled, and this is not how the behavior worked in the past. I'm creating this thread here today because I finally noticed a place in our system where this is a bit of a blocker.  There are nodes where this was configured in the past and is now not even changeable. As you may be able to tell from the above screenshot, the "new process variable" control is NOT disabled here (but the output-selector dropdown arrow is, even though you can't tell visually).  Clicking on New PV allows you to save that input's value into that new PV, but then that output target is stuck and not changeable again (unless perhaps by adding a redundant new PV again). This really seems like a bug - if this was an intentional change then I certainly don't remember seeing any announcement for it, or mention in any of t

Hi all, I'm dabbling with some "serious" QueryRecordType interface use for the first time in a bit, and for the first time I'm attempting to use the built-in Aggregation. My use case: a simple one, basically showing a grid sorted by frequency of use of a potentially repeating column.  I'm using Aggregation Fields and grouping by that column, while doing a "count" in a measure.  When I run this a!queryRecordType() in an expression rule it works beautifully.  I notice: it returns an a!map() data result rather than a DataSubset. Then I try to plug it into a Read-Only Grid and things start going a bit haywire. If I try to use it as you normally would use a RecordType source, the grid errors with a complaint about returning List Data.  If I try to run the query in a Local Variable first, it doesn't quite work right, because with the local variable not resolving as a DataSubset, the grid doesn't quite recognize what info I'm try

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.