Discussion Categories

I am trying to deploy a patch  to production to fix   few ongoing issues in process model .   In production environment already few of the process are active with error for the same issue . Will it have any effect on the Active process with errors . Thanks In Advance

I ran into this problem when creating an expression rule for pulling the current pastor for a given parish Id (organization Id).  The Id is passed in a Rule Input as parishId. I have three tables that are needed for this query, all are related. Clergy Member, Clergy Assignment, and the reference table for the Position name.  I need to pull the assignments that are current, i.e. where the Position Term Date is greater than today or null (for permanent assignments).  This is a very similar problem to the one I posted here:  [mention:aa603d0cc3424d8185dbd2f2ce5acf40:46448885d0e64133bbfbf0cd7b0fd6f7:label=queryRecordType%20with%20an%20%26quot%3Bor%26quot%3B%20condition]  Now that a!queryLogicalExpression is my new best friend (a big thank you to Stefan Helzle for the intro) is used a very similar logic.  Since I wanted the results to be a Clergy Member record type, I used that as the record in the a!queryRecord function. a!queryRecordType( recordType: '

validations: if( a!forEach( items: ri!grid, expression: count( fv!item['test}iscorrect'] ) > 1 ), "Only one fav can be selected", null ), Hello All, I have an editable grid with multiple rows. I have fav button on each row. I need to validate only one fav is allowed per user. How can I achieve this pls. Here validation is not working. All my grid data is coming from ri and saving back to ri.

I have taken appian associate developer exam yesterday, i got only 28 out of 60,but am confident to get more marks,any suggestions pls

Hi, I have a dropdown configured in which some of the choice values are high in character value because of which it is getting cut-off. Can anyone suggest any workaround. PS: I am maintaining a look value table from where I am indexing these values.  Sharing the SS below.

Hi All, We have small requirement like need to replace/substitute the places holders in string with values. a!localVariables( local!template: "Hello, {name}! Welcome to {place}.", local!placeholders: { "name": "John", "place": "Appian" }, a!forEach( items: a!keys(local!placeholders), expression: a!localVariables( local!placeholder: fv!item, local!value: local!placeholders[local!placeholder], local!template: substitute( local!template, "{" & local!placeholder & "}", local!value ), local!template ) ) ) which returns the following out put like  List of Text String - 2 items "Hello, John! Welcome to {place}."(Text) "Hello, {name}! Welcome to Appian."(Text) Need to replaced all of them in single string with some sequential manner. Your expertise is helpful to solve. Thanks in advance.

Hi Everyone, I need to display multiple radio buttons in a single column of a grid. I am not sure if this is possible. If anyone can suggest would be helpful.

Scenario: I have a record like below: Container Record which has fields like id, caseId, claimsId, providerId and these 3 fields point to primary keys of 3 other records Case, Claim and Provider. Whenever an entry is made in Case an associated entry is made in Container for fields id and caseId Whenever an entry is made in Claim an associated entry is made in Container for fields id and claimId Whenever an entry is made in Provider an associated entry is made in Container for fields id and providerId At any point there would be only 2 column in Container which would have values. On Container we also have added custom fields to fetch other data fields like summary from Case, Claim, Provider and each of these 3 records have summary field We are using realtime custom field using customfieldmatch to decide which related record should be used to get the summary field for the custom field by looking at which identifier is not null. a!customFieldMatch( value: 'recordTyp

Hi Community, Was going through documentation for breaking-a-chain and came across this point The amount of time between attended tasks exceeds the non-configurable limit of 10 minutes. Can anyone explain this pointer with example? What do we mean by when we say attended, unattended task. What is non-configurable limit and where can we see it It would be helpful if anyone provide explanation on breaking-a-chain in detail with example?

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(

Hi, I have several DB tasks shown in a to-do list, where it is possible to reassign these tasks to other users. I need to ensure, just before submitting any task, to check if meanwhile a user has been filling the form, anyone has reassigned that task to another user. In that case, if the user click into the "Complete" button, the task can´t be submitted and a warning must be shown in the form. My approach was create a rule that check the if loggedInUser() match with the user in the column of these record, returning a boolean. When I clicked into the "Complete" button, the rule must be executed and decide if I can submit the task or not.The problem is that that rule is execute just once when the user open the task and I can't find a way to force the execution of therule every time I click into the button. In some tasks there is no option for the user to insert data, only display information and complete the task so refreshing that rule everytime

Currently, we have the database time set as GMT which is four hours away from the Eastern time zone. We are running into issues with Time based search and bots processing of cases for a certain day since the server time is different. 1. Is it possible to update database tiezone to EST? 2. If we updated to EST what will be the impact of Existing application?

So I have a parent process in which 1 subprocess is mapped and in that subprocess there is 1 pv!id of number type and set as a parameter and is required true but I’m not passing it from parent process, in spite not passing it is going ahead without giving any error but it should give error because of required variable not being passed!

Hi all, We are evaluating using the Appian cloud database encryption, but we need to be able to access the requests audit log information. In the system logs documentation says “Cloud database audit logs are only available for Appian Cloud customers. Additionally, these logs are disabled if database encryption feature is enabled on your Appian Cloud site.” But the documentation for Appian cloud database encryption indicates that binary, error, and audit logs are available. Does anyone know what information is stored in any on these logs? Can we retrieve the information about the requests made ([timestamp],[serverhost],[username],[host],[connectionid],[queryid],[operation],[database],[object],[retcode]) from the binary log instead? Thanks in advance

There is a smart service in my interface known as document upload . When i am uploading any document , it should be in pdf or word format , basically I need to check that User can only upload a pdf or word document . If the user uploads document of different type it should throw the error .  how to achieve this please explain or give some code snippet if possible . Thanks in advance !

Hi Team,               In my application i am using one expression rule that fetches the data from database view,and that database view fetch the data from 4 tables and each table have different number of records(646183,2185098 ,159583,166000) , however when i go to database and open the view it's working fine but when comes to expression rule it's not working  Note: Previously we didn't face any issue as we didn't  had much records  and it was working well for load testing we inserting lakh's of records now it's not working. Could you please suggest me a solution. Thanks & Regards, Prasad.

We had a decimal value in text format in local!value variable as below But converting it to decimal is rounding off the value as below But I want the exact value in decimal data type as we need to send this value to an external system that doesnot accept text format. Is ther any way that I can sent exact value in decimal format without rounding it.

This is the result of 1st integration , i want to store client guid (of result body)  in some process variable and then pass this value as input to 2nd integration .How Can I achieve this ,can someone please advise

I need to redirect the user from an existing application(in React) to the appian application using OPEN ID Connect SSO, I have already made the settings by integrating Appian via Open ID Connect(AWS Cognito), and appian provided a callback url https://{my-url-here}.appiancloud.com/suite/oidc/callback I would like to authenticate the user in another application using the same OpenID Connect client and redirect the user to Appian without having to log in again for example: https://{my-url-here}.appiancloud.com/suite/oidc/callback?token={token-generated in another application} is this possible?  

hi i have a query that i am using to fetch the data from post grace sql to appian  but while i am making a manual query  in that query i have empty values  as some contion  in the above condition we have empty values  whic is not considerding by plugin and displaying the below error  please give me any solution on this 

Hi Champs, I want to hide the out of the box Reassign button which shows to user when they open any Appian process based task. Is it really feasible? Regards, Ghanashyam

Hey, I have an interface with multiple interfaces shown up using showwhen conditions.when i click on submit button on the screen then only the process should be started, in the same interface I have file upload component with another submit button , when I click on that submit button the file should be uploaded to the target folder and a process need to be triggered , in the same process i'm using uploaded files ID so i kept submit true. Here I'm facing the issue, when i click on the uploading file submit, the screen is submitting directly and trigerring other process model.Just because submit true is also applied for second submit button. The entire interface is a start form for one process model and there is  another process model triggered using startprocess smart service in uploadfile submit button. Thanks in advance.

Hello, I've been trying to implement this functionality since morning but with no luck. We have a form where the user can input multiple locations if they want to. The functionality is as follows: 1. User fills out the address and additional questions as below The information for these questions is saved in the Input record type which has a one-to-one relationship with Project Location record type.  If the user clicks on add potential location, a new Project Location entry is appended to the existing Project Location array. We need to give the user the option to prepopulate the values of the previous location to the new location if they want.  My approach is as follows: I need to create a local!currentIndex variable that uses wherecontains function to tap into the values and give me the array. I then index into that array and store it to another local variable local!prepopulatedData Problem is, I never used wherecontains before and the logic of this is confusing

it is  posible to  change a sharepoint    folder name using the  update folder metadata integration

Hello, I'm getting this weird whenever I pass in the rv!identifier of a record  Here is my related record action below. I'm only passing in the rv!identified which should be stored in the corresponding rule input ri!projectPlanId When I pass a test (i.e projectPlanId = 82) the interface works like I want it to. But when t is passed through the related record action, and test it through the site, the error persists.  is there a typo I missed or am I missing something more complicated here. Isn't the interface supposed to take in the rv!identifier, which I know is a number. Or am I messing up somewhere else? If anyone likes to see snippets of code, I'd be happy to provide some. Appreciate all the help!