-
Recently active
Hi, Any idea how to find the third largest value using a!queryentity?
how can i sort an Array?
Hi Team, I am trying to convert html code in my email template to dynamic so i can loop some values using expression rule but i facing some issue in syntax , Looking for the help below is the html code <!DOCTYPE html><html><body><head> <link rel="stylesheet" href="styles.css"></head> <h2>###bodytext###</h2> <br><br><h2>Please click on any below link to submit you response</h2> <a href="mailto:processmodeluuid0002e98e-199e-8000-273d-7f0000014e7a@cscswdev.appiancloud.com?subject=###resultId###&body=Please don't edit subject and To-email Address, Please add your comments below">Complete</a><br></br><a href="mailto:processmodeluuid0002e98e-199e-8000-273d-7f0000014e7a@cscswdev.appiancloud.com?subject=###resultId###&body=Please don't edit subject and To-email Address, Please add your comments below">Cancel</a> <br><br&g
Hi All, I have this cast function cast( 'type!{urn:com:appian:types:TLT}TLT_VEHICLEDETAIL?list', ri!data ) and I'd like to change TLT_VEHICLEDETAIL with a dynamic input using ri!inType. I thought to fix this problem with concat function ex. but it doesn't work. and my result was this one who can help me?
Background: Using integrations I have called several endpoints and pulled the data into a map with nested maps. I now need to move values from the nested map to the parent, as they are all 1:1 relations. a!localVariables( local!CDT: a!map(id: 1, name: "Walt Disney", demographics: a!map(age: 73, gender: "M")), local!CDT) This returns: Map id1(Number (Integer)) name"Walt Disney"(Text) demographicsMap age73(Number (Integer)) gender"M"(Text) what I am in the need of is: a!map(id: 1, name: "Walt Disney", Age: 73, gender: "M")
Hello good evening, I need help, well, it turns out that I have a problem, for example, when I want to omit certain special characters, I use substitute, all fine for example if I only want to omit the symbol "&", but when I put another symbol, for example "%", instead of replacing it, I get a blank space, I have already used substitute, stripwith, a regex, and I can not find a solution, I attach my code. a!localVariables( local!subs:substitute(ri!name," & "," "), local!formatB: cleanwith( local!subs, cons!GT_CONS_Clean /*1234567890qwertyuiopñáéÃ%ADóúÃ%81ÉÃ%8DÓÚQWERTYUIOPasdfghjklASDFGHJKLzxcvbnm-ZXCVBNMÑ_ */ ), if( length( local!formatB ) = 0, "attach", local!formatB ) ) I have already tried these functions and I can't get that. regexreplaceall("\s\W", local!sub, "_") stripwith(ri!name," &#$%&/|¡? ") For example, when I try to test this string, instead
Hi Experts, I have a requirement where we have to get the input from user for the time fields, User want the time to be entered in HH:MM:SS in 24hrs format where SS is optional. Below are the input with expected stored output Input1: 23:55:55 Output: 23:55:55 Input2: 10:32 Output: 10:32:00 Input3: 23 Output 23:00:00 Input4: 231000 Output: 23:10:00 Input5: 2359 Output: 23:59:00 Input6: 23 Output: 23:00:00 Kindly suggest for the feasibility of such expression as how can we achieve this.
Hi there, could anyone let me know what's the problem here, in the following expression rule, if the condition is meeting, it will return the records which meet the condition, if there are no records meet the condition, I just want to return 0 item, but here it returns 2 "0 items". replacing "{}" with null does not work either. what I should do? regards Lin
Hi All, I have a table with studentid|subjectid 1 | 10 1 | 11 2 | 12 Students who belong to 10 and 11 should get 1|Science, 2|Maths. How can I get the output like this.
Hi all, {1,2,3,8,9,9,9,9,9,80,90,70}, {56,76,54,32}, {20,23,45,54,32,54}, {1,2,3,4,5,6,7}, {11,12,13,14,15,16,17,18} Please suggest how do this using foreach function get output like this, length of array 1 is 12length of array 2 is 4length of array 3 is 6length of array 4 is 7length of array 5 is 8 Thank You In Advance
My teammate found a bug when using proper() to display a label; a word preceded by a non-alphabetic character will not be converted to proper case. If the 11th floor is home to the HR department. Floor.id = 11 Floor.department.name = "human resources" We would expect: Floor 11 (Human Resources) but instead get: Floor 11 (human Resources) To reproduce the issue, I used this expression to check capitalization: proper( "I am reporting that ""proper() coNverts each [alphabetic] cHaRacter into ProPeR caSe " & "(unless a non-alphabetic character precedes it)""" ), Where I would expect: I Am Reporting That "Proper() Converts Each [Alphabetic] Character Into Proper Case (Unless A Non-alphabetic Character Precedes It) It's returning: I Am Reporting That "proper() Converts Each [alphabetic] Character Into Proper Case (unless A Non-alphabetic Character Precedes It) Is proper() working as designed? Side note: 22.4 documentation reads, "Converts each character i
for example my input is 0323 and i need output march-2023 (or) 03-2023
Hi Everyone, I have the requirement where the excel file is to be read by IDP. But I am not sure if IDP can extract data from excel file. Can anyone please help me out if it is possible through IDP or any other alternatives? Thanks, Shubham
The guides don't say anywhere how to open IDP.Perhaps it's not installed on our instance and it would be obvious from the main menu.Where does IDP normally appear? In the top right main menu?Are there permissions associated with it?Our system administrator is on vacation and I'm not sure if I just can't find it because I'm learning how to use Appian, or if it's not installed. Thank you.
Hi All, I am Trying to Fetch Last login Details of some users by using getuserlastlogin() but it is returning Null values for users who logged in 1 week before. Does This function work only for last 24 Hrs? Thanks in Advance!!
Hi everyone, I have a CDT CDT type process variable called pv!caseIds, which contains a column showing case IDs as below: [caseIDs=1, deleteDate=11/12/2001 17:30 GMT+11:00],[caseIDs=2, deleteDate=11/12/2001 17:30 GMT+11:00],[caseIDs=3, deleteDate=11/12/2001 17:30 GMT+11:00],[caseIDs=-1, deleteDate=11/12/2001 17:30 GMT+11:00],[caseIDs=-2, deleteDate=11/12/2001 17:30 GMT+11:00],[caseIDs=10, deleteDate=11/12/2001 17:30 GMT+11:00],[caseIDs=3030064, deleteDate=11/12/2001 17:30 GMT+11:00] I also have a text list of case IDs, saved in another process variable called pv!caseIdText = {1,2,-2} Now I want to find all the case IDs in pv!caseIds.caseIds column that ARE NOT in pv!caseIdText (which are {3,-1,-2,10,3030064}) I tried using difference() as below: difference((pv!caseIds.caseIds, pv!caseIdText) and got this error message: Expression evaluation error at function 'difference' parameter 1 [line 2]: Invalid index: Cannot index property 'caseIds' of type Text int
When I use formatjson function, it automatically change "&" to "\u0026" , and "<>" to "\u003c\u003e", how to aviod that? Can anybody help? Thanks
Hi All, I have to check whether the current time(irrespective of any user time zone) is between 7pm EST to 9am EST. So we tried to convert the current time to EST first and then to compare it with "7:00 PM" & "9:00 AM" EST (by creating text constant). We just tested with below code to check whether comparison works fine by changing the constant value, but it fails totime( gmt( local(now(), "EST" ) ) ) > totime(cons!xyz) where cons!xyz = "7:00 PM" (a text constant) So please help me how to make this work. Thanks in advance.
How much data we can retrieve from database in expression rule?
hi, my query is if i want to read xsl document details in expression rule is any function for this
My requirement is to fetch the correct option for the respective question which is there in the database. So what condition i need to apply in choiceLabels() as am getting questions in the correct order only but only the option from the first row is getting repeated for all the questions. so i want first 4 data to go for 1st checkboxField() , next 4 to second checkboxField() & so on. local!data:rule!MWJ_qe_forQuestions(), local!option:split(rule!MWJ_qe_fetchQuizOptions(),";"), local!choose:{1,2,3,4}, contents: { a!forEach( items:split(local!data,";"), expression: a!checkboxField( label:fv!item, labelPosition: "ABOVE", choiceLabels:{ a!forEach( items:index(split(local!option,","),{local!choose},0), expression:fv!item,)}, choiceValues: { a!forEach( items:index(split(local!option,","),{local!choose},0), expression:fv!item, )},
Hi Guys, is there any way to increase the expression rule timeout which is pulling data from a view . As now its getting timeout because of the complex logic in view so i just need to increase the timeout of a expression rule to check it Thanks in advance
hyperlinks can be included in the body of the notification display Understand if the below edit text options can be included so we can underline text/change colour etc need to be shown an option how it shows in word document to underline and make it color to text for the text which we are showin in notifications in this way need to be shown on the screen to make text to color or underline
Bubble sort starts with very first two elements, comparing them to check which one is greater. ( 5 1 4 2 8 ) –> ( 1 5 4 2 8 ), Here, algorithm compares the first two elements, and swaps since 5 > 1. ( 1 5 4 2 8 ) –> ( 1 4 5 2 8 ), Swap since 5 > 4 ( 1 4 5 2 8 ) –> ( 1 4 2 5 8 ), Swap since 5 > 2 ( 1 4 2 5 8 ) –> ( 1 4 2 5 8 ), Now, since these elements are already in order (8 > 5), algorithm does not swap them.
I have created a single interface that is being called by two separate interface but the text in richtext display should be different only. Everything else will be as it is. How to do that?
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
