Discussion Categories

I created generated some sample data through ai but I have a problem with one of the fields. The createdBy field shows full names but when I add data through a record action it shows a user. I wanted to show only users. Is there a way to delete that data or change so it displays consistent information? I tried to edit those rows but the system does not let me.I can only edit the rows I did through record actions. Here is the column to show the issue: thank you

Hi All, I am calling the data from db through expression rules and gave batch size as 100. I need to use this data in interface inside grid, is this only 100 records will be displayed in interface or I can display whole data from table.

Hi, I need to have a document upload form like this package import form, and have a validate button like inspect button, but I need to disable the import button before the document is validated successfully. I need to validate the document's content and format, so it's not just a validation for the size and type How can I do?

Trying to walk through the tutorial for the Acme Auto (SA) Application. When I click any vehicle I get the error below. When I add a vehicle, it does not get added. Obviously I'm new to Appian. Any help appreciated. Error Evaluating UI Expression Expression evaluation error [evaluation ID = I0L6P] in rule 'w1847aa_cmpt_vehiclerecordevents' (called by rule 'w1847aa_dash_vehiclesummaryview') at function a!eventHistoryListField [line 3]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!queryRecordTypeFunction [line 58]: An error occurred while retrieving the data for "W1847AA Vehicle Event History". Details: Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator. (APNX-1-4198-000)

am getting this warning

Hello, I have added new columns in the views and updated CDT and published data store. However, when trying to update the record type I'm getting below error. Note: The updated fields are reflecting in edit list after resetting the list but getting error in preview.  Expression evaluation error at function a!gridField [line 51]: An error occurred because the record types source is currently unavailable, or the query reached a timeout or memory limit.

I am looking to gather details on all objects that been modified or updated in our Appian environment over last 6 months. Specifically,1. How can I obtain a list of all modified /updated objects during this period? I know, we can manually check each objects versions for the changes made, or last modified but was wondering if there is consolidated a report at object level2. Is there a way to track which users made these modifications and when?If anyone has experience with this or can point me to relevant resources or methods, I would greatly appreciate your insights!Thank you in advance for your help!

Hola, Sr Administrador, . Cuando estoy tratando de probar el flujo del proceso: W0747SA Solicitar mantenimiento. Me sale el mensaje que copio más abajo y no puedo seguir. Me podría decir que debo hacer ? El sistema ha encontrado un problema ¡Lo sentimos! Se ha producido un problema al procesar la última solicitud. Póngase en contacto con el administrador del sistema para obtener más información.  

We would like to use Smart Service to delete records from the DSE (Data Store Entity) and create records according to the input received from the screen.In this case, will the Delete and Write transactions be separated?For example, if Write after Delete fails for some reason, I would like the Delete transaction to rollback. Please let me know if there is a way to execute Delete and Write in the same transaction on Smart Service.

Hi, sometimes I have to go back to the basic rules of Appian. I have an editable grid with REQUIRED fields to show in a page of a Site. To make this validation work, I have to put the interface in a start form of a process and then add this process in a site page as Action, otherwise it won't work. Is that correct? Thank you

Not able to create a new Record Type from scratch in Community Edition I am unable to create a new Record Type with a new database table i.e. not getting "I want to start from scratch" option. Is it a known restriction or a bug? Community Edition: Standard Tier: Please let us know your inputs if any.

Hi, I'm using readexcelsheetpaging() to read an excel, it has a blank row so I want to set stopReadingAtFirstBlankRow: false But I got following error: Expression evaluation error at function 'readexcelsheetpaging' [line 26]: The passed parameter(s) are of the wrong type. Received the type com.appiancorp.common.xml.JaxbConversionException: JAXB was not able to produce a value for typed value TypedValue[it=26,v=0] as java class java.lang.Integer. But when I removed stopReadingAtFirstBlankRow it works fine.

Everytime that I try to open links for learning paths and courses in Appian I need to login (which I already did) and when I put my credentials, I see this error message:

Hello, I have a process for parsing data, and in one of the nodes, I'm checking whether the respective alert exists for a specific event. The script task has one output, which uses a QR rule to retrieve the alert based on the event's alert ID. The retrieved alert is then stored in another variable. The QR rule returns a single alert, which works as expected in all other environments, but in production, the result is null in the process model. This issue has also occurred with other processes using the same rule and having multiple outputs, but when we split the logic into two subtasks, it worked fine. However, for this process, the problem persists. Could you suggest what might be causing this issue?

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() ),