Discussion Categories

hi,  I wanted to set a user filter for my record, which will pull the records based on quarter/month and year. I am trying to avoid the custom record field. example - Q4 Oct 2024 The field that has date time stamp in my record is "CREATED ON". Any help is appreciated.

Hi, When I was reading an excel file uploaded by user, how can I identify the max row that has values? Otherwise if I read to the row that has no values I'll get error, I'm using excelreadcellsbynumber()

I created a view in SQL to calculate the age of a person.  MariaDB is formating the age field as a bigint(21).  I am connecting an CDT to this view and I need to know what the columnDefinition would be for a big integer.  I tried INT and BIGINT and that doesn't work. @Column(name="Age", columnDefinition="INT") I even tried to cast the calculated field as an integer in the SQL statement, but that did not work either? CAST(TIMESTAMPDIFF(YEAR, `CM`.`ClergyDOB`, CASE WHEN `CM`.`ClergyDOD` IS NULL THEN CURDATE() ELSE `CM`.`ClergyDOD` END ) AS INT) AS `Age`,

Hello all, I'm going to change configuration of password fortmat with adding more complexity. After that I would like to force all users to update their passwords accordingly. Is there a way to expire the password immediately so user will be prompted to update their password on next login?

Here is the Problem There is a excel which having the data i want to create a store procedure that read the excel data and save this data to temp table. after that it save the data to main table. and after save into the main table, SP now truncate the temp table. can anyone write the code of SP and tell me how to use this SP in process model Thanks

I am creating a practice application that takes in a pet's owner, and the pets that the owner has. Because the owner can have more than one pet, I have created an editable grid that passes the input pets in to a rule input that stores them as a "list of recordType!w0428pv pet". I would like to be able to use the write records smart service to take that list and input it in to the database as individual records but I'm not sure if that is possible or the right way to go about doing this. I believe the process variable is storing the array of pets correctly, as it looks correct in the preview on the design page. Any advice would be greatly appreciated! 

Hi everyone, I hope you can help me with something that is driving me crazy. For some scenarios it works and for others it doesn't, but basically I have an interface where the only thing I do is show database information. I went from validating nulls in the following way, {} then to "" and finally null() but the error was always the same "Null? list must be used within a SAIL component" I attach an example of my code, I hope you can help me identify what the problem is. a!localVariables( local!newComment, local!dataVerification: if( a!isNullOrEmpty( ri!recordRequest['recordType!{f3693eb2-ffb2-4407-814e-681b44ba8ef5}TTC Request.relationships.{42fd7ed7-d716-49c6-b449-e1fa839b532a}client.fields.{82090d2d-4f09-4af2-9995-eda5781d1392}id'] ), "", rule!TTC_getVerificationByIdClient( idClient: ri!recordRequest['recordType!{f3693eb2-ffb2-4407-814e-681b44ba8ef5}TTC Request.relationships.{42fd7ed7-d716-49c6-b449-e1fa839b532a}client.fields.

hi  i would like to know if there is anyway to stop the scheduled process model during deployment

Hello, We have been using the PDF Doc From Template Smart Service for around 6 months now to generate dynamic documents. We create the templates using Adobe Acrobat Pro. All of the sudden, any file created in Adobe is outputting a <1kb file when using the SS. I have done troubleshooting all the way down to simply creating a blank PDF, saving, then running through the SS and I get the same result every time. I have tried multiple configurations using Save As > Optimized PDF with the same result as well. Can anyone shed some light on what my issue may be or provide some extra troubleshooting I can perform?

Hi everyone, I hope you can help me with something that is driving me crazy. For some scenarios it works and for others it doesn't, but basically I have an interface where the only thing I do is show database information. I went from validating nulls in the following way, {} then to "" and finally null() but the error was always the same "Null?list must be used within a SAIL component." I attach an example of my code, I hope you can help me identify what the problem is. a!localVariables( local!newComment, local!dataVerification: if( a!isNullOrEmpty( ri!recordRequest['recordType!{f3693eb2-ffb2-4407-814e-681b44ba8ef5}TTC Request.relationships.{42fd7ed7-d716-49c6-b449-e1fa839b532a}client.fields.{82090d2d-4f09-4af2-9995-eda5781d1392}id'] ), "", rule!TTC_getVerificationByIdClient( idClient: ri!recordRequest['recordType!{f3693eb2-ffb2-4407-814e-681b44ba8ef5}TTC Request.relationships.{42fd7ed7-d716-49c6-b449-e1fa839b532a}client.fields.{

local!selectedSystemType: if( a!isNotNullOrEmpty( local!dataFeed['recordType!{fcce7d6a-d964-4fb7-bc9c-610a5333f0ee}EILM Inventory Data Feed.fields.{785adc35-6266-4c30-abbe-eca44c05c93d}systemTypeCode'] ), local!dataFeed['recordType!{fcce7d6a-d964-4fb7-bc9c-610a5333f0ee}EILM Inventory Data Feed.fields.{785adc35-6266-4c30-abbe-eca44c05c93d}systemTypeCode'], null() ), a!buttonWidget( label: cons!SHARED_BUTTON_LABEL_NEXT, icon: cons!SHARED_BUTTON_ICON_NEXT, saveInto: if( a!isNullOrEmpty(local!selectedSystemType), {}, a!save(local!currentDataFeedStep, local!currentDataFeedStep + 1) ), style: "SOLID", color: cons!SHARED_BUTTON_COLOR_NEXT, disabled: a!isNullOrEmpty( local!selectedSystemType ), showWhen: local!currentDataFeedStep < 3, validate: true() ),

Hello, I am working on the Portal Course. I am not listed as administrator on the WPO Wyndhamm Power Outage App so I am not able to create objects. Is there a way to request access to the group? Thanks

Hi, We are configuring SAML SSO in our client environment, we completed the configuration and seems to work successfully but we have some issues when the options Create new users upon sign in is selected.  If we don't select this option everything works fine, the user created in Appian and added to the Authentication Group can access the environment fine using SAML. But when we select this box and map the attributes, the configuration test gives the error message: Authentication was unsuccessful. Reason: Required attributes for user creation not found in assertion. And when trying to access the environment with the SAML user in this case we get an error: Error 401 - Unauthorized. I have also checked the assertion xml provided by the Idp (Identity Provider Metadata) and the attributes and claims defined in the Idp and everything seems to be fine. We have opened a support case with Appian but have not yet found a sol

input: "Banana", output: "B---------------1" , "aaa---------------3", "nn---------------2"  any one try it anthor way .. { a!localVariables(local!data: "Banana",local!len: len(local!data),local!merge: union(a!forEach(items: enumerate(local!len) + 1,expression: local!data[fv!index]),a!forEach(items: enumerate(local!len) + 1,expression: local!data[fv!index])),local!all: a!forEach(items: enumerate(local!len) + 1,expression: local!data[fv!index]),a!forEach(items: local!merge,expression: index(local!data,wherecontains(fv!item, local!all),{}) & "---------------" & count(wherecontains(fv!item, local!all)))) }

How do I get Odd numbers 1-100 ?

Here, the integrationResponse.result.body is an array of dictionaries. However, the length function returns 1 if not using flatten. Not sure why this is happening. Please share comments/reasons if any.

Hi All, Using Document Viewer I am able to view the regular PDF. One of my client requirement is they wanted to view the PDF Portfolio document through Appian. Is this possible in Appian? Can you guide me through this? Thanks in advance!

How to ignore hypens while searching in the grid  In the above image, while searching in the grid after removing hypen also below data needs to be come..

Hi All, I am trying to fetch data details from an XML file which contains XML code of an Process Model.When I try to fetch the name , UUID or Pv's data using the following syntax for PV's : xpathdocument( docId , "processModelHaul/process_model_port/pm/pvs/pv[1]/name" ) for UUID : xpathdocument( docId , "processModelHaul/process_model_port/pm/meta/uuid" ) for Name : xpathdocument( docId , "processModelHaul/process_model_port/pm/meta/name/string-map/pair[1]/value" ) I am getting no response.when i checked in Community : https://docs.appian.com/suite/help/24.3/fnc_scripting_xpathdocument.htmlthere also it was mentioned the similar syntax that i am using.But still i am not getting why the I am getting null as output. Thanks in advance.

Hi Team, We have a requirement to build centralized Notification Management System. The system should support previews for all supported channels, such as email, SMS, push notifications, and in-app alerts. Appreciate your valuable input.  Thanks, Sinushree

Hi Team, The custom sender email functionality was working fine until last day in the environment. Suddenly it had stopped working and the send email node is getting errored, and error message says, "Failed to send email". Have anyone faced a similar issue, we have also observed that all the other mail functionality like process model is working fine. Please help us on this issue. Thanks.

I am trying to move the file into file system by creating a folder on the destination path. I am passing folder parameter using constant. This is moving file in file system but not creating folder. Please guide me what I should configure so that it will create folder and move file in it. ++[mention:9a3c4b933d674b319102bb3e59083770:e9ed411860ed4f2ba0265705b8793d05] 

HI Team, I see sometimes my form is not submitting and moving back to home screen but backend the process is moving furthure?, Is this an environmental issue ? This issue is causing only for few open tasks but not all of them ? Below is the submit button code  a!buttonWidget( label: "Submit", submit: true(), validate: true(), value: true(), saveInto: { a!save(ri!submit,save!value), a!forEach( items: local!data, expression: a!save(ri!II_DT_DocumentClassification, append(ri!II_DT_DocumentClassification,fv!item)) ) }, style: "PRIMARY" )

a!columnsLayout( columns: { a!columnLayout( width: "EXTRA_NARROW", contents: { a!imageField( images: a!documentImage( document: rule!EILM_Datafeed_fetchSystemIcon(systemCode: local!selectedSystemType['recordType!{fcce7d6a-d964-4fb7-bc9c-610a5333f0ee}EILM Inventory Data Feed.fields.{785adc35-6266-4c30-abbe-eca44c05c93d}systemTypeCode']) ), size: "TINY", align: "CENTER" ) } ), a!columnLayout( contents: { a!richTextDisplayField( value: { a!richTextItem( text: { displayvalue( local!selectedSystemType, local!refSystemsData['recordType!{6bfcaf5e-7f37-4e20-a544-b4915d162997}RD Data Feed Systems.fields.{037fb842-a09e-4e3f-836e-85f83c476be1}systemCode'], local!refSystemsData['recordType!{6bfcaf5e-7f37-4e20-a544-b4915d162997}RD Data Feed Systems.fields.{abcb5cb3-86d6-4255-9ce3-f435dc50cb36}systemName'], local!selectedSystemType ) }, color: "STANDARD", size: "LARGE", style: { "STRONG" } ), char(10), a!richTextItem( text: { local!dataFeed

Hi  I have a parent process which is deciding startDateTime and  delayMinutes and then passing this parameter to start process smart node which is delaying the subprocess with this set up: pv!startDateTime + intervalds(0,pv!delayMinutes,0) . However, this should delay the process by calculated time. But it is not delaying it at all.  I want to ask,  How to implement Dynamic delay in timer? Does intervalds does not work with process variables as parameters?