Discussion Categories

As I'm going through the Appian Developer course I have noticed that some information is missing when trying to pass the quizzes. I am completely stuck on Expressions. Is there something else I should be doing besides the Developer course? 

Hi All, I have numbers between 100-200 and I want to display the 5 multiples and 5 included numbers. Sample output: 105,110,115,120,125,130,135,140,145,150,151,153,154,155,156,157,158,159,160,165,170,175,180,185,190,195,200

By clicking on relation action button present on summary page, user should redirect to summary dashboard of newly created record . Is there any possibility like this? Can anyone pls suggest me a solution for this?

please tell me how to validate email address without regex means with the help of like function .  I am writing this expression : like(ri!email,"*@gmail.com")  but i want to validate every field like first character should not be digit and all .help me to sort out this 

Hi, everyone I would like to integrate Appain'DB to MS Access'DB.In order to do it, I am tyring to create RPA Robot that excutes JDBC to read or write to Access'DB by costum Java code. If you have better idea or know how to create RPA Robot that excutes JDBC to read or write to Access'DB, could you tell me about it? Thank you.

Inside Summary View of Record when clicked on Related Action to edit the record, dialog box is not displayed inspite of that task is getting assigned in tempo inside task tab.

Good day, I'd like to implement a search function in an interface, but I'm struggling to make it work. Once the user types in a search term and presses the search button, the appropriate results should return. The code :  a!localVariables( local!search: false, local!searchTerm, local!searchTitles: { "Amadori", "Telpark", "Microsystem", "Kone" }, local!searchData: a!dataSubset( data: rule!JT_CONS_CASE_STUDIES(), batchSize: - 1, startIndex: 2, sort: a!sortInfo(field: "title", ascending: true) ), local!searchField: index( local!searchTerm, wherecontains(local!searchTitles, local!searchData) ), { a!sectionLayout( label: "", contents: { rule!JT_uiCaseStudyDashboard(numberOfColumns: 3) }, showWhen: local!search, isCollapsible: true ), a!sideBySideLayout( items: { a!sideBySideItem( item: a!textField( labelPosition: "COLLAPSED", placeholder: "Search Use Cases", value: local!searchTerm, saveInto:

Hi, I have a requirement to send certain email based on few business rules. Also based on some logic ,we need to send email by passing priority High or Low dynamically. But with the send email smart service which we have , its a dropdown and we can't pass this value via expression editor. Any way to achieve ?

On file upload I want to change [Document:1234] to fileName.png.Here is what I have currently I've tried various expression inBut whatever I do, I don't get the filename saved in a variable.Things tried include (but I may have done them wrong): using a a!map using the document(documentId,"name") however [Document:1234] is not a number using a!replace(pv!file,"Document:",""), and that did not work I simply need to get the Document Id value so that I can use the document() function.I feel that I'm running out of things to try.Here is my input

Code snippet below shows a filter for field test whose value is reviewing. a!queryFilter( field: recordType! a.fields.test operator: "=", value: "Reviewing" ) How can I filter field test whose values are "reviewing" or null?  I should be able to get rows 1 and 2 test 1 reviewing 2 3 resolved

In DB I have some records with only Date and some records with date& time Example: 2/1/2023 1:22:31 PM 10/17/2023 11/15/2023 7/07/2022 6/17/2022  2:22:32 AM 11/17/2022 9/28/2022 9/28/2022 i need to filter it out with only date but where ever time records available those records unable to filter it out a!queryFilter(field: "date",operator: "=",value: ri!date) can someone help me with this

How to index values from Record Type. For Example: how to index location from this 

Any idea on how to cast cdt to record type

I have a simple stored proc as following. DELIMITER $$CREATE DEFINER=`dbadmin`@`%` PROCEDURE `Test_TruncateTable`(IN `spTableName` TEXT) MODIFIES SQL DATA COMMENT 'Truncates staging table.'BEGIN TRUNCATE TABLE spTableName; END$$DELIMITER ; The procedure won't get executed, it throw's following error. #1. #2. I tried changing the IN parameter to VARCHAR etc. but no luck. In past I have wrote more complicated procedures having multiple parameters however never run into the above mentioned error. 

Hi, Can someone guide me on the requirement. I would like to know what type controls I can use to achieve this. 1. Display the data in a grid format with a link under Sno column data. 2. "ADD" button on top right. When the user clicks on that I need to show a separate screen with F. Name, L.Name, Address text fields and allow to click on "SAVE". Once user clicks on "SAVE", data should save to the database and come back to the below screen. 3. If user clicks on the data link under the Sno, then I need to open show a page with F.Name, L.Name, Address with text fields and need to load respective data, once if they modify and click on "SAVE", I need to save the updated data and come back and load the below page. ADD Page EDIT Page

Hi All, I have an external report where i will be pulling data into Appian. When am storing fields into Appian i could see space is replaced with "non breaking space". for ex: IN Appian DB: In External report: Can anyone suggest why this is happening ?

Hi, what we need to do if process model is consuming a lot of memory and due to  this appian environment getting very slow.I have already set archive (3) day from data management tab. Is Manually delete processes that have already been completed or cancelled is a another good option?

Hi All, We encountered a challenge with the Radio Button Component. Under certain condition it is loosing or 'forgetting' the selected radio button. We are using it to display the status in a workflow. Based on the users role and the status the entity is in, only certain options can be selected, so we are adjusting the choices. Below is a code example what we are doing. As you might see, if you select option 3, it stays only a split second on the UI and then the selection disappears. And yes - we alreadyhave submitted a support ticket to Appian, but it looks like the component will not be changed.  Any suggestions how to overcome this? We have our own ideas, but would like to see first what the community will contribute.(We will publish our version tomorrow). Thanks a!localVariables( local!selection:1, local!choices:a!refreshVariable( refreshAlways: true, value: if( local!selection = 3, {1,3}, {1,2,3} ) ), { a!radioButtonField(

Hi, Is it possible to pass the entity name dynamically or using the table in query entity? May be have some rule which will take the table name and return the data store entity. Regards, Mukesh

Hi all, I want to replace each "trackerID" from local!test - local!test4 variables with a correct trackerId from local!Ids. Current values in dummyCDT are indexes of their corresponding IDs in local!Ids array.local!Ids values are {24912; 24913; 24914}  a!localVariables( local!test: 'type!{urn:com:appian:types:DBS}DBS_Tracker'(trackerID: 1), local!test2: 'type!{urn:com:appian:types:DBS}DBS_Tracker'(trackerID: 2), local!test3: 'type!{urn:com:appian:types:DBS}DBS_Tracker'(trackerID: 2), local!test4: 'type!{urn:com:appian:types:DBS}DBS_Tracker'(trackerID: 3), local!dummyCDT: union(union(local!test, local!test2), union(local!test3 ,local!test4)), local!Ids: index(ri!tracker, "trackerID", null), a!update( data: local!dummyCDT, index: "trackerID", value: index( local!Ids, local!dummyCDT.trackerID, null ) ), ) Is it possible to achievable this way?

Hi , My process was getting errored out at Parse XLSX file node saying  Error: An error occurred while evaluating expression: Output:rule!s_CRDoc(pv!changeRequestFile_doc) (Expression evaluation error in rule 'c_doc' at function 'readexcelsheetpaging' [line 8]: com.github.pjfanning.xlsx.exceptions.OpenException: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Invalid byte 1 of 1-byte UTF-8 sequence.) (Data Outputs)

So I have an interface that is saving two array of CDTs the idea I was having is that it would store each iteration of the array into its own respective row for the array example: {[uuid:1, fkuuid: ab32, date: today], [uuid:2, fkuuid: cd43, date: tomorrow]}. In the database there would be a row for UUID 1 and a row for UUID 2 but when I execute the write to data store entry I only get uuid 1. To push this even further I am doing this two times for separate tables and its only putting 1 entry into 1 table.  If there is any more information that is needed let me know! Any Ideas on how to get it to save all the information in the array of cdt to each of its separate rows?

When should we re-deploy an application vs. using a patch?

I am trying to connect the target vehicle.vehiclelastmodifiedby but its not listed as an option. Where do I go to fix this issue?

Hi, Is there a function available to retrieve only direct members from a group. The a!groupMembers function returns both direct and rule based members when "direct=true" is passed, but I am looking for a way to specifically obtain just direct members. Thank you