Foundation

Hi, I have two tables with name x and y, X has 20 columns with name of text1,text2,text3.. text20, and additional some columns as id and cif - which is used to store the values in this one row isequal to one line which includes all 20 cols y has 20 columns with name of text1,text2,text3.. text20, and additional some columns as id and cif - which is reference for x table  using both the table i have show the values of x table all 20 cols of one row in one line  how can  i achieve this?  as of now i used only X table to show the values and just concatenated all the cols  is this right way to do?  Thanks Kavya Muttur 

Hi, I'm trying to test a fruitless foreach, and I'm surprised to see that the result is not just null or empty.- can you tell me why this code returns 20 null lines please (please see the attached file) ? I was expecting an empty list- - In this case, how to assert that the result is fruitless ? a!localVariables( /* Get a list of 20 Vehicles */ local!vehicles: a!flatten(rule!CJT2_GetVehiclesWithFilters( id: null ).data), /* The id = 550 does not exist in the Vehicles so we'll not find it */ local!oneVehicle: a!forEach( items: local!vehicles, expression: if(tointeger(fv!item.id)=550, fv!item, {} ) ), local!oneVehicle ) The object of this post, is not to replace foreach by another function (like index or reject) but to understand how works the foreach. Regards

Hi, I called a summary view interface in another interface using record relationship but having problem in the process model.  This is my Phase Title Interface calling another interface 'Summay View' using the rule input "titleinput" which is a record type. The interface works fine but when I try to create a process model, I am not able to call the parameters.  The expression used:  a!formLayout( label: "Selected Project", contents: { a!sectionLayout( contents: { rule!MD_PM_ProjectSummaryView(ri!titleinput['recordType!}MD_PM_PhaseTitle.relationships.}mdPmProjectdetail']) - I used the record relationship here. } Process model: Is it because titleinput is a record? how to resolve this issue? or how can I use summary view interface in Phase title interface without using the title input record type? Please advice.  TIA.

Hello. I'm getting this error in our UAT Environemnt while uploading PNG file. but in our DEV environment the file upload is working properly

I have designed a little HTML template in order to send dynamic emails to the costumer with the send e-mail smart service. But when it comes to outlook emails, the user doesn´t recieve the email. There isn´t any problem on Gmail, I can see the email without any problem. I read that maybe some HTML tags doesn´t work on Outlook, but I do not even get the email. Thanks!

Hi, My customer is going to use Appian solely as process engine, all the UI work is made outside Appian. So, they have people developping each task interface on angular, I do not agree with that, but they already made their decission.  Well, my concern know is find a way to track in appian the fact that a particular user accepts a task. I've tried with reassign smart service but it does not set task owner, it just set assignee task property. Is there any other service or plugin that allows me to make a webApi to set task owner? Regards

Hi, Im facing this issue when i'm retrieving  a list of data from an integration and  casting it to a data subset  when i try to acces a  especific id in a expression rule everything works perfectly  and it returns an  id but  when i do the same thing on a process model  it throws me this error that you see i tried many ways of getting this to work  and nothing. what could it be the problem that  i'm facing ? below how looks like  the expression rule when i  use the   process model to get the  values this doesn't work either

Hi, In which scenarios we can use process backed records. Can anyone explain with an scenario pls?

Hi Everyone, My Requirement is in a HRMS - an Email will be sent to the manager when a Leave is applied by an employee from the process Model, The Email body will have links(buttons). If the manager clicks on a certain link to reply, the particular process(approval / rejection) should be triggered. The first email gets sent from one process model (leave submission). The manager approval process is a different one (manager approval). Tried executing with the available documentation but, succeeded in capturing the mail data if typed and sent by the manager and not able to implement on click of link in the first mail. Kindly let me know the steps if anyone has implemented

Hi,  I need to set appian internationlization based on user locale after login, like if user's native language is hebrew  I need to set appian internalization to hebrew after login using his language preference, some guide and help will be thankfull. Note:  I know i can do this by admin console manually 

In the documentation on parallel evaluation, Performance View - Appian 21.4, it is mentioned that if multiple queries are in place, they may be evaluated in parallel.  I'm noticing that this doesn't seem to be the case for a!queryRecordType(). Would it be a better practice to avoid a!queryRecordType for use of a!queryEntity in interfaces where parallel evaluation would help performance? Can someone please confirm or chime in if they have more detail, here are my findings: I set up an expression rule in the following manner (6 local variables all independent of each other, at any given time 3 of the other type are commented out).  The queryRecord1 and queryEntity1 are equivalent other than the function being used to run the query: Performance details indicate that the query records are not running in parallel, while the query entities are. Query Record details (sum of percentages does not exceed 100% indicating no parallel evaluation): Query Entity details (s

What are the various data types permitted in Appian rule input

is there any way to remove mover hover text displaying on interface of recordActionItem as shown in the below image can't we disable that mouse hover text  Thanks In Advance

Hi, This is my use case: - I have a process launched waiting on a user tasks. The process was launched via webapi, and it gets the security configuration from its process model, as usual.- The security on the process model is setted to give Administration rights to the service account represented by api-key I'm using on my web apis- From another web-api using the same api-key, I execute cancelProcess function, and I get an error talking about inssuficient privileges to do the cancel To my understanding, the process should cancel without errors because the service account used in web-api has administration rights on the process I want to cancel, but this is not what is happenning. Any help will be appreciated

a!

Hello all,  depending on the user choices, they can either be able to change a value or to just read only the values in an Interface. For the text field is easy I just apply the readOnly parameter :  How can I make a dropdown field read only ?. Kind Regards, 

Hi, There is anyway to skip the login page sending the credentials into an url?  We have an application where we send an email to the user with their credentials and the url for appian portal. The problema is that users from mobile, when they click on the url from the email, mail app open in the same window the login page so user needs to go back in order to remember user & password… that is not very usefull and finally users are not using the application. A solution could be if we can include in the email an url with user and pwd encrypted where user clicks and goes to appian portal doing the authentication automatically… its possible? Any other idea? Thanks in advance by the support.

Hi All, I have defined the visibility of site in such a way that if user is part of a given group and his status is approved in DB then only the site page will be visible to him. We are facing challenge with one user who is neither part of the group n nor his status is approved in table is able to view the site page. what could be the possible reason for it..? Thanks, Ankita Singh

Lets say you have a form with a textbox name. The form populates from a DB tableA. What is the recommended way of saving it into DB tableB? I experimented with the following: 1. a!pickerFieldUsers( label: "Name", labelPosition: "ABOVE", value: if(isnull(ri!tableB.firstlastname), ri!tableA.requestaddedby, ri!tableB.firstlastname), saveInto: ri!tableB.firstlastname, readOnly: true, validations: {} ) 2. putting   a!save(ri!record.requestdateadded, now()), in the submit button etc. Another idea was to keep the same rule input and handle it at "Write to DSE" in the process.

Hi Team, We have a requirment in which when the user clicks a button there should be a pop up message dispalyed for 15 secs and then it should get auto refreshed and the user should land to the home screen.As far i know, we dont have any such thing in appian to create a pop up screen but can utilize the a!buttonWidget where we can use confirmMessage property to achieve the pop up. In my case, we dont need the buttons in that message, but it appears by default in button widget.  How can i remove these buttons and also how do i achieve the auto refresh thing? Please suggest. Thanks.

Hello community, I am trying to make UI which has a read only grid which is populated based on data from integration, we passed a cdt as an input to this grid, now I wanted to put filters on that data using drop downs and date filters (start date and end date), I did came up filtering the cdt using wherecontains() function and foreach() loop and got different index for them. but I couldn't make them work like record filters. how do I group them ?some code below for understanding. Thanks. a!localVariables( local!selection, local!responseData: rule!PNK_DataForGrid(), local!actualData: local!responseData, local!customerAddress: union( local!actualData.customerName, local!actualData.customerName ), local!customerNameSelection, local!ftaNames: union( local!actualData.customerAddress, local!actualData.customerAddress ), local!customerAddressselection, local!startDate, local!endDate,

Hi Everyone, I am getting this error for paging A grid component [label="Search results"] has an invalid value for "value" and "totalCount". "startIndex" must not be greater than "totalCount", but "startIndex" was 11 and "totalCount" was 0.   For Paging i am using the below code,  a!pagingInfo( startIndex: 1, batchSize: 5, sort: a!sortInfo(field: "Id", ascending: false()) ) How to Reset Paging I am not getting solution.

Is there any possibility to have vertical scroll bars for read-only grid??

Hello all,  So I have a process, where the stakeholder wants to handle a feature more restrictively.  So before starting a process prompt a new question. ( I already have an interface working fine, but with the new requirements should  I create a new one with the questions ?) What you would like to amend?  ( I already have an interface working fine, but with the new requirements should  I create a new one with the questions ?) Distribution Fee amount only (->only Distribution Fee should be editable)  -> process works the same as before, BUT once approved and processed by Documentation the task does NOT go back to other team in the end anymore KID, Target Market, Cost&Charges only (->only these fields should be editable) -> process works the same as before, BUT once approved and processed by Documentation the task does NOT go back to the other team in the end anymore  Others (might include the above on

Hi all, I have a row of two columns. I have image field in the first column, and read only grid in the other one. The two items are inside columnsLayout. They are not with the same height, so the design doesn't look good at the moment. Is there a way to make these two items fit all the column height ? thanks,