General

I am planning to give a certification exam and have to use my company account, but I'm leaving the company in a few days. Would it be possible to move my certification later, to the account with my personal email?

Hi , I am not able to login to community site from 4 days getting error message as below. Appreciate your help! Regards Nishtha Bhatnagar

 hi all, We have a view for bar cart field which recently bracked in prod due heavy volume of data approx (1,048,576) records in my sql db .  so we plan to query data going with sp with (executestoredprocedure) function. my question is can we query data in a barcart field with SP ? while executing SP  with mandatory  parameters getting error as "Use the Execute Stored Procedure Smart Service to modify data. This function must only be used to query data, not modify." if i pass optional parameters also getting error as "The conversion from UNKNOWN to UNKNOWN is unsupported". Below is the code for SP,  a!localVariables( local!sp: fn!executestoredprocedure( cons!DATA_SCOURCE_NAME, cons!TASK_GRAPHIC_SUMMARY, { { name:"assignedTo", value:ri!currentUserEmail }, { name:"categoryName", value:ri!categoryName }, { name:"lob", value:ri!lob }, { name:"assignedcategory", value:ri!assignedcategory },

My Appian Timezone is set to Pacific time Below functions are returning correct time now()  -   2/20/2023 5:40 AM PST datetime(year(now()),month(now()),day(now()),hour(now()),minute(now()))   -  2/20/2023 5:40 AM PST However, when I try to create datetime where I want to change the date and time acc to my preference, the timezone offset gets added.  datetime(year(now()),month(now()),day(now()),0,0) – 2/19/2023 4:00 PM PST   I want the output as - 2/20/2023 12:00 AM PST       Requirement for which I want to create datetime in specific timezone. Now I want to create a datetime so that I can use it to filter the datetime column stored in DB I need to fetch all rows from DB where the createdDate is say 2/20/2023 so for that I thought of creating a query filter as Date between (2/20/2023 12:0AM PST and 2/20/2023 11:59 PM PST). However I am unable to create datetime in particular time zone  

Hi all. I'd like to know if Appian can be integrated with a versioning software like CVS. The goal is to store each Appian component version with the ability of identify who modified a component, what changes are made and recover old version. Thanks in advance.

Dear community, within our project we have the requirement of full traceability from a work-item in azure devops to the actual code changes. Are there best practices to do that within the Appian environment or possibilies which would allow us for example to force the user to enter a description before he can save an object, automatically export the objects from Appian via a Rest-Api and then commit them in git ?  Thanks, Patrick

Hello, I am trying to randomly sample x amount of rows from a CDT by generating x random numbers in the range 1:length(myCdt). The issue I am getting is that some of these random numbers are repeated.  Is there a way to generate random numbers  in a given interval and have them be unique?  Here is what I have so far: local!randomNumbers:if( length(local!query)>15, 1+ tointeger(rand(15) * length(local!query)), local!query, ),

created web api with below code but getting below error local!entities: a!queryEntity( entity: cons!TI_FINALEXCELTODATABASESTORE, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 50 ) ), fetchTotalCount: true ).data, An error occurred while retrieving the data. Details: Unexpected error executing query (type: [TIFinalExcelToDatabaseDT7969], query: [queryentity expression], order by: [[Sort[null asc]]], filters:[null])

Hi Team, By mistake few tasks are cancelled and i want to generate a report on tasks cancelled per user. Can you please help me on how to generate this report Thanks in Advance

Hi there, One question here I have a URL need to be insert into email body. This URL will be different between DEV site and PROD site. I am trying to define a constant for this URL. but dont know how to insert it into email body, as "insert web link" does not accept constant. tried use using safelink in "Insert an expression". not good. Could anyone let me know how to do it? regards, Lin 

Hi Team, Is there anyway I can get rid of the DEBUG statements, it takes lot of digging to find the actual issue. Any help of this will be appreciated. 15:06:22.699 [AsyncHttpClient-1-6] DEBUG org.asynchttpclient.netty.channel.ChannelManager - Closing Channel [id: 0x352261bf, L:/127.0.0.1:65045 - R:localhost/127.0.0.1:55909]15:06:22.699 [AsyncHttpClient-1-6] DEBUG org.asynchttpclient.netty.handler.HttpHandler - Channel Closed: [id: 0x352261bf, L:/127.0.0.1:65045 ! R:localhost/127.0.0.1:55909] with attribute DISCARD15:06:22.704 [AsyncHttpClient-1-7] DEBUG org.asynchttpclient.netty.channel.NettyConnectListener - Using new Channel '[id: 0xb5d60450, L:/127.0.0.1:65046 - R:localhost/127.0.0.1:55909]' for 'POST' to '/session/38b062eefaf139bb0d755dcb873de4f4/element'15:06:23.097 [AsyncHttpClient-1-7] DEBUG org.asynchttpclient.netty.handler.HttpHandler - Thanks, Chandrakant Raju C

My rule input is of type document of CDT to upload excel file into the database.

I want to create an editable grid for each raw of read only grid and save. is there any way we can do that simply?

Hey Guys, I am using the a!recordactionfield in a separate interface to add the data. It contains card layout for each of the data we added. Is there anyway to refresh the page while submitting the data using dialog box option. All process model nodes are chained and when I used the "open in same tab" option it refreshes the data but from the dialog box it does not refresh. I also used the a!refreshvariable in the local variable in interface but it doesnot work.

Getting above error how to resolve .. as value is null ..

How can the email/name attached certificate that I earned when I pass the Appian exam?At some point in time I'll be changing my employer and I'll want to take my certificate with me by transferring the certificate/achievement to my personal email address/account. Does it change things if my employer has an Appian partner agreement?

Hi,  I am Getting Error on User Creation Node in Process Model - "The user creating this account doesn't have enough privileges to perform this action"

Hi, Could someone please help me understand the reason for the error I am getting in Process Model? JAXB failure trying to convert value ProcessInfo to Appian type ProcessInfo Thanks Faisal

a!localvariables(local!leadData: rule!TRO_qrtLead(leadId: 244).data, local!credentiallingTypes: if( a!isNullOrEmpty( local!leadData['recordType!TRO Lead.fields.credentialingTypeLookupRefId] ), {}, local!leadData['recordType!TRO Lead.fields.credentialingTypeLookupRefId] ), a!dropdownField( label: "Type", choiceLabels: local!TRO Lookup.fields.label, choiceValues: local!TRO Lookup.fields.lookupRefId, placeholder: "---Select Credentialling Types---", value: local!credentiallingTypes, saveInto: local!credentiallingTypes )) how to handle null over here ?

local!readData: rule!PRO_qrtdata(lid: 244).data, local!selectedCounty: if( isnull(local!readData), {}, local!leadData['recordType!PRO Read.fields.countyuniqueid ), it is giving the error of    "Invalid index type: Record field uuid: 6225c036-92c6-4200-a11f-fb68f362b1a2 Record type uuid: 9c9d5cd6-8a4b-435b-88c3-6aa310c89afc Relationship path: null". 

Hello,  I'm working on project and using the same form steps as "https://docs.appian.com/suite/help/21.2/form-steps-pattern.html", I'd like to change the color for the stamp field to be red if there's an error in the step. I added "validate: true() " to the next button.Is that possible to moving forward to the next step and just change the color if the step contains an error. Thank you for your help!

the latest version v22.4 seems to have a bug;  The object identification fails for drop-down. On New version 22.4 the element definition for dropdown is as below; <span id="9d114c989f45ddbdab069168cd461dae_value_span">Value</span> .Whereas for older version of appian the definition was as below; <span id="4c85c14d61e4e58a2a354fc2a6e88f8d_selectedChoice" class="DropdownWidget---accessibilityhidden">Corporate</span> the newest version (v22.4) of cucumber tries to find the object with the following Xpath; //span[contains(@class, 'DropdownWidget---accessibilityhidden')]"  This works on older version on newer version it fails

Hello Guys,I am trying to move the story and its individual components from on phase to another. So in the diagram story is Go to School by tomorrow and its sub task are GTC task2 and GTC task 1. The problem is when I tried to move the story all its subtask are also moving and when I moved the subtask its not moving only the phase change is written in the database. I need to show the sub task below the story.So I used below code to achieve also I think the problem is here. Can you please help me to solve this issue.--rule!APM_bcklogItemCard calls the single story card.--and I am again calling the APM_backlogItemandSubtask interface to get all the items on APM_backlog interface. { rule!APM_backlogItemCard( onlyStory: ri!onlyStory, backlogItem: ri!backlogItem, showEditView: ri!showEditView, document: ri!document, selectedBacklogItem: ri!selectedBacklogItem, refresh: ri!refresh ), if( ri!onlyStory, null, a!localVariables( local!data:a!refre

Can I import CSV files with Appian without using any sort of plugin?I know that there are plugins that allow for this, but I'm in an Appian cloud environment and plugins are not always capable/available. What I need to do is allow the end user to import any one of six different CSV files all with different headers and data.Based on the data in the files I need to do different calculations.I have no problems running queries against the data after it's been imported.  If this is possible without a plugin, can you point me in the direction of documentation/tutorials to help me out with this? Thanks,pete

Hi all, need some help with the user's configuration. Is it possible enable by defaultthe user's accessibility option? I mean before to create it. Thanks for reading