Discussion Categories

Hi, We need to get the users access and refresh tokens using the SAML assertion. We tried to do this creating a connected system with the authentication method OAuth 2.0: SAML Bearer Assertion Flow. The problem we have with this solution is that the assertion along with the client id, client secret and scope are added as a header when calling the integration. We are required to send the assertion separately in the request body, so we are trying to find a way to get the assertion after the users login with SAML to add it to the body of the integration to retrieve the tokens. Has anyone done something like this before or knows how we can access the SAML assertions stored in Appian? Thanks in advance. 

Hi there, I'm on the last part of the instructions where we have to create a record action: 1. In the left menu, go to the Actions page.2. Click GENERATE RECORD ACTIONS.3. In the Choose Your Action dialog, deselect Update and Delete. For this exercise, you will focus on the Create record action. Click CUSTOMIZE.4. Configure the following properties:● Display Name: Enter Add Vehicle.● Description: Enter Action to add a new vehicle to the fleet.● Click NEXT: REVIEW OBJECTS.5. Review the objects that Appian generates for this action, including a process model and interface for adding a new vehicle.6. Click GENERATE. After clicking GENERATE in step 6, I am put back at the Actions page with the following error displayed (Your record actions and supporting objects could not be created. Try generating them again or configuring manually.): Interestingly, when I look at the object listing for the site, I see that the Process Model was generated, but not the Interface: Any suggestions

Good morning, I need to add an editable column in a gridField because I don't want to lose functionality. Is it possible to do this?

Can I assume Stored procedure in DB side and Expression rules in Appian side having same functionality/usage?

Hello everyone, I am having issues with querying process report which has multiple (different) values in one column. The column is filled with data from a list of CDTs, for example: I've tried setting it as a list of integers and strings, but either way, when trying to query all rows which have a value "12345" in that column (by using a!queryProcessAnalytics), I get no results. a!queryFilter( field: "c4", operator: "includes", value: tostring("12345") ) I also tried all different combinatios (in, includes, strings, integers....). Thanks in advance!

Hi team i am unable to fetching the data using the query entity,due to some restrictions i have to use the CDT only so i am using query entity for fetching  the data,(I want this data for displaying into the read-only grid)i have 2 tables in DB1st table having the 42 columns and 26191 rows of data so i am using the below code for fetching the hole data  a!queryEntity(entity: cons!1stentity,query: a!query(pagingInfo: a!defaultValue(value: ri!pagingInfo(Type:pagingInfo),default: a!pagingInfo(startIndex: 1, batchSize: 10)), ),fetchTotalCount: true(),), but using this code i can able to fetch 21568 rows of data only not able to fetch the whole data,2nd table having the 8 columns and 389434 rows of data so i am using the below code for fetching the whole data. a!queryEntity( entity: cons!2ndentity, query: a!query( pagingInfo: a!defaultValue( value: ri!pagingInfo, default: a!pagingInfo(startIndex: 1, batchSize: 10) ), ), fetchTotalCount: true(), ),From this tab

Doing Appian Developer course in which under Engage Logged IN Users excercise it is trying to add a second page as Action where we have to select Process Model which doesn't exist when trying to add an empty Process model it keep throwing this error - help me with steps how to getrid of it or point me to excercise which I missed and can follow to get rid of this error

hi team, how to add the multiple documents at the same time to record  could you please suggest me. thanks

Hi All, I am having a requirement to generate a PDF Invoice. I am using PDF doc from template smart service. I have to display data in table where number of rows are dynamic. Question: How to create dynamic tags in PDF template that will accept dynamic data. 

Getting below error while starting tomcat {"error":{"root_cause":[{"type":"security_exception","reason":"unable to authenticate user [appian] for REST request [/user-activity-8-0/_settings?master_timeout=30s&timeout=30s]","header":{"WWW-Authenticate":["Basic realm=\"security\", charset=\"UTF-8\"","ApiKey"]}}],"type":"security_exception","reason":"unable to authenticate user [appian] for REST request [/user-activity-8-0/_settings?master_timeout=30s&timeout=30s]","header":{"WWW-Authenticate":["Basic realm=\"security\", charset=\"UTF-8\"","ApiKey"]}},"status":401}  

I currently am doing an aggregate query that groups by two fields and sums a third field.  The result is the following: [period:1,week:1,total_hours:2]; [period:5,week:1,total_hours:3]; [period:2,week:2,total_hours:5]; [period:6,week:2,total_hours:8]; [period:12,week:3,total_hours:4]; [period:3,week:4,total_hours:2] I am trying to pass this data into a grid but with one row per "week" value with an array of period / hour values as below: [week:1,periods:[[period:1,total_hours:2],[period:5,total_hours:3]]]; [week:2,periods:[[period:2,total_hours:5],[period:6,total_hours:8]]]; [week:3,periods:[[period:12,total_hours:4]]]; [week:4,periods:[[period:3,total_hours:2]]] - Can this be done in the queryRecordType itself? - Which array methods would be best suited to handle this? - Should I be using foreach to do this?

Is is possible to create an interface where there is a carousel list for images, cards, etc. ? Refer to the image above.

 t= a!localVariables( local!data: ri!_Requests, local!errorMessage: "test", local!result, local!emails: ri!_Requests.emailAddresses, local!integration, local!individualMail: if( a!isNullOrEmpty(local!emails), {}, reject( fn!isnull(_), split(local!emails, char(10)) ) ), local!invalidEmails: substitute( tostring( reject( fn!isnull(_), a!forEach( items: local!individualMail, expression: if( regexmatch( pattern: "^s[A-Z0-9\_-]+(\.{0,1}[A-Z0-9\+_-]+)*[@]{1}[A-Z0-9.-]*[A-Z0-9-]+[.]{1}[A-Z]{2,6}$", searchString: fv!item, regexFlags: "si" ), null, fv!index ) ) ) ), ";", "," ), local!validation: if( isnull(local!invalidEmails), {}, "Emails must be in a valid format, and each email must be on a new line. " ), a!formLayout( label: "Request", contents:

below question: Can we capture the user activity in Administration console or designer page even if the user is not changing anything there , user start pages ,etc. and they are not making any changes , Is this activity also captured in the logs and if it is which log should I find it?

Hi Experts,I m using read only grid in my interface, where i used expression as data source . If I search the column data correct results are not showing up. Lets say if have fields with status " NOT started" i can see 3 rows of data in grid, but if i search for "Not Started " and hit enter. only one result is showing up in grid. How to solve this Thanks

Hi Community, I'm working on an Appian interface for updating a parent table(BaseOilOrConcentrate) which includes a related editable grid of child table(WIW_OIL_SPEC_CONTROLES). I use a rule-backed component (rule!WIW_gridLayout_specs_Oil) to display and manage this grid. When I delete a row from the grid (child spec), it gets removed from the database immediately (which is expected). However, after clicking the Submit button to finalize the update, the deleted child records reappear in the database. Has anyone encountered a similar situation? Is there a recommended approach to persist deletion state across the interface and process model without modifying the rule? Thanks in advance for any suggestions!

I'm new to Appian. I have a user main page, and the user is able to click on a icon within the read-only grid, which is a recordactionlink, launching the interface to carry out managing of user information. Now, it would be simple if it was just the user I am handling. Considering that this action is within the "Users" Record Type as a related action, I was planning to also use this same interface to do management of another record type "Access" within the same interface. My issue is with the Access of course. With it being a grid/gridcolumn layout, with 3 columns, Location/Department/Role, the user is only able to populate the Access Record Type, 1 row per Location. Basically, the User Record Type and the Access Record Type has a one-to-many relationship. In an attempt to control the amount of rows the user is allowed to create within this interface, I first used a!for each to loop through the location Record Type, which basically ensures there's only as

In the performance matrix for an interface is: blue is caused by local!A.pink is caused by local!B. But local!B is using results from local!A . Since the logic is already evaluated in local!A, local!B is simply calling the results from local!A, then why it's taking the same amount of time.

I am trying to open record summary for requests but whatever record I open I'm getting record doesn't exist. I attached my code I can understand something is wrong but couldn't get what I was missing.  The ri! Request relation is of type request relation. Anyone can help? a!sectionLayout( contents: a!forEach( items: ri!RequestRelation, expression: a!cardLayout( contents: { a!linkField( links: a!recordLink( label: "link", recordType: a!match( value: index( a!queryRecordByIdentifier( recordType: 'recordType! Request', identifier: tointeger(fv!item[requestRelation.field.AppId]) ), 'recordType! Request.fields.applicationId', {} ), equals: 212, then: 'recordType!ABC', equals: 213, then: 'recordType

Can we perform 2 operations within the same expression of a forEach loop possible? (Ex: zip in python.)

I was hoping for advice regarding a Custom picker field I recently setup. It works similar to a dropdown but with text search, so as you start searching.. the dropdown starts filtering based off what was typed. The issue I am having is a small issue I found where if I type AB. (dot) the first codes listed in the dropdown are "TAB." and "AB." comes after it. Screenshot below: Do you know of a way within a custom picker field like this that I can sort it so that if I type "AB." codes that start with "AB." will be listed first before TAB? Here is some of the underlying code in case that would help you understand if this is possible or not.. This is the custom picker field: a!pickerFieldCustom( label: "Strategy Code", placeholder: "--Please type in--", value: if( a!isNullOrEmpty(ri!strategyCodes), {}, ri!strategyCodes )

Hi, is there a way to disable the use of /suite/?signin=native? We are currently using OpenID as our authentication method(we need to include every new user on the AzureAD Group), but if an Admin user creates one and don't include it on the group, the user could access to Appian using the native version. For security reasons I don't want this to happen. What can we do to disable this option?

Hi, We are getting below error when we hit any site menu(s) and this message is disappearing when we re-fresh the browser. Issue remain same across the browsers. Any quick advise please. "403 Access denied" You don't have permission to view this page

I need to create new .dat file by fetching the data stored in database by running a process model. I looked into the smart services but couldn't find anything helpful. How can we create a .dat file with all the details?

I see this functionality is introduced at 24.4, is it available for on prem system also ? or only for cloud because I am not able to see this view in our on prem environment