AI and Agentic Automation

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?

Hello everyone,  I have a local variable that query data from data table.The data looks like below:  local!cases: { (clientId: 234,group: 55), (clientId: 600, group: 66), (clientId:234, group: 77), (clientId: 600, group: 88), (clientId: 234, group: 99) } I want to get the group name of only client number 600. Below is my code:  index(local!cases.group,wherecontains(600,tointeger(local!cases.clientId)),null), And got this error:  Invalid index: Cannot index property 'group' of type Text into type List of Number (Integer) Any one got an idea what the reason is? Thanks a lot!

Hi, Is there any function or a recipe to get all the basic users. Please help

Hi, Can Someone help in writing a&nbsp;rule which gives me a list of users whose last login date was a year back. I wrote this rule but it is pulling users with the lastlogin date as null.&nbsp;Please correct me a!forEach( expression: if(todatetime(getuserlastlogin(fv!item)) < ri!datetime,fv!item,""), items: getdistinctusers(cons!PDS_USERS_TYPE) ) Thanks in Advance

Hi, I want to have a ri!startDate, I will use the a!isNotNull function to display some warning message if the ri!startDate is null else will retrieve the weekday(ri!startDate) but I keep encountering the error message such as&nbsp;Cannot sub incompatible operands of type Date and type Text. below here is my code for the interface a!localVariables( local!weeknum:if(a!isNotNullOrEmpty(ri!startDate),weeknum(ri!startDate),{}), local!day:if(a!isNotNullOrEmpty(ri!startDate),day(ri!startDate),{}), local!month:if(a!isNotNullOrEmpty(ri!startDate),month(ri!startDate),{}), local!year:if(a!isNotNullOrEmpty(ri!startDate),year(ri!startDate),{}), local!dayofWeek:if(ri!startDate=null(),"Please Select a Date ", weekday(ri!startDate)-1), local!startWeekDay:if(local!dayofWeek1,ri!startDate-local!dayofWeek+1,{}), local!endWeekDay:local!startWeekDay+4, local!monday:local!startWeekDay, local!tuesday:local!startWeekDay+1, local!wednesday:local!startWeekDay+2, local!thursday:local!

Hi, can anyone teach me how to retrieve the week range based on the weeknumber and year. For example, the user selects a date. I use the weeknum(ri!startDate) already retrieve the weeknumber and the year(ri!startDate), so I already have the weeknumber and the year already, how to retrieve the date range from the week number and year ? such as 11/11/2022, week number is 47 and the year is 2022,&nbsp; how to we retrieve the date range like &quot; 7/11/2022 - 11/11/2022 ? anyone can help or assist me [emoticon:c4563cd7d5574777a71c318021cbbcc8]

How can we generate a series of random numbers like 23434 56767 89789 34355 56307 Please suggest me or an example without any table connection

I want to roundup below result to ...upto two places like 3.13....how could i achieve that please help

Hii all, we have 3 teams in my building portal they are 1vendor , 2buyer and 3internal team and the intrnal teams have 3 other sub teams called IT1 and&nbsp; IT2 and IT3,&nbsp; normally when a vendor raised a request&nbsp; for pricing change for a product then it will goes to buyer team , he has the power to reject or accept or send it to internal teams ,&nbsp; now the 1)rule is if the&nbsp; current product price is 10% more than&nbsp;previous price then this&nbsp; should get approval from all the teams from internal teams called&nbsp;IT1 and&nbsp; IT2 and IT3 &nbsp;2) if the the&nbsp;&nbsp;current product price is 10% less than&nbsp;previous price&nbsp;then this&nbsp; should get approval from teams IT1 and IT3 only 3) if retail price is more than cost price then it will get approval from IT2 only note:&nbsp; when buyer forward the request to internal teams above mentioned actions should take place could you please&nbsp; tell me how to achieve this decision mapping and business rules i