General

While entering a leave request in a read-only grid I am entering the same date two times with different leave type (which is allowed).  I need to get the leave hours entered for the same date as I need to give a validation message if the sum of leave hours exceed 8 hrs for the same day.  How can I achieve this?   In the sample data given below, I want to extract the requested hours where the leave dates are same: [LAST_UPD_USR:ehelen,LAST_UPD_TS:10/14/2022 5:55 AM GMT,CREATE_USR:ehelen,CREATE_TS:10/14/2022 5:53 AM GMT,IS_ACTIVE:true,APPROVED_HRS:,REQUESTED_HRS:5,LEAVE_TYPE:Sick Leave,LEAVE_DATE:10/26/2022,FK_STAFF_ID:113,FK_EMPLOYEE_LEAVE_REQUEST_ID:19,EMPLOYEE_LEAVE_REQUEST_DETAILS_ID:1]; [LAST_UPD_USR:ehelen,LAST_UPD_TS:10/14/2022 5:55 AM GMT,CREATE_USR:ehelen,CREATE_TS:10/14/2022 5:53 AM GMT,IS_ACTIVE:true,APPROVED_HRS:,REQUESTED_HRS:8,LEAVE_TYPE:Vacation Leave,LEAVE_DATE:10/20/2022,FK_STAFF_ID:113,FK_EMPLOYEE_LEAVE_REQUEST_ID:19,EMPLOYEE_LEAVE_REQUEST_DETAILS_I

I created successfully a web api (image bellow) then i copy the URL in the browser and its works (check image bellow) But when I copy the URL in an incognito browse, shoe this error:  {"resource":"\/suite\/webapi\/CWAOECClients","error":"APNX-1-4187-000","message":"Authentication failed. Please check your credentials and try again.","title":"An Error Has Occurred"}Help please ///////////////////////////////////////////////////

What is the difference between quick apps and application builders to create an application?

I have data stored in db as row wise. that data i have to show in column wise is that possible if so please let me know  data stored in database like below  Contact ID  Contact Limit   AED (000)  Contact Outstanding  (AED’000)  Value of Extension Sought   AED (000)  Capital Amount  AED (000)  Interest Payment Due  (AED’000)  Current Due Date  Days to be Extended  New Maturity Date   From CrP  =Contract Limit  = Value of Full Contract - Outstanding    =Value of Extension Sought  = capital amount  = Interest Payment   =Current Maturity Date of Payment being extended  =Number of days extension sought (B)  =New Extended Maturity Date                    Total    100,000  5,555    1,192&nb

Query API fails with 500 Error because of Memory threshold reached during output conversion "An error occurred while retrieving the data. Details: Memory threshold reached during output conversion (rule: [queryentity expression], type: [YMXXDT4282], threshold: [1,048,576 bytes], objects successfully converted: [2,431])" Is there any pagination option which we can use? Any insight would help a lot. Thanks

I am unable to get a milestone for a particular id . Can anyone help me with it please

Hi Everyone, I have the requirement of impelmenting SSO login for users while they are approving the items present in interface. Can anyone please help me out? Thanks, Shubham

Has anyone done any integration with an Appian program and a PLC?

Hi,Is there a video/tutorial on how it is possible to import a plugin into "FitNesse for Appian"? I would like to test using the plugins indicated on the official fitnesse website, but I'm not getting it. Thank you.

 HiI All, I have created a pricing change request poral and it has 3 users 1. vendors, 2. buyers 3. internal teams ,I want to design a login page for main portal . The login page will be same for all users but based on credentials we need to direct the users ,   for example login page is visible for all the category users whenever , the vender category user trying to login with his credentials it has to redirect the vender to the vendor action page , like wise for the buyers and internal team category , please let me know how to design  in my application vendor has to request , buyer and , internal teams will approve or reject the vendor request . and let me kow how to setup users credentials and passwords Thank you all

Hi, how can we fetch only 24 hour Data in expression without using DB in Appian.

Hello, In a process I'm sending an email with an attachment. The problem comes when the document attached looks like its corrupt or in a strange situation. What could cause this? Here i'm triying to insert pictures of the configuration and the error. Image of the document recived: Image of the configurations on the process in the email sender. Thank you!

Hello Team , I am new in Appian and now planning to give Associate level certification.  Anyone who recently appear for the certification can please help me with the question (If you remember so.) or type of question . I have already gone through Sample paper given in training .  Any help highly appreciated . Thank You,

Hello, can anyone suggest me how to add a new line in appian? Code: user(loggedInUser(),"firstName")& " " &user(loggedInUser(),"lastName")& " " & user(loggedInUser(),"email") The output should be: Beast Hulk green.hulk@avengers.com

Hello, Do we have any templates to gather the business requirements for Appian solution ?

In Process Modelling: Part 1 of Appian Developer learning can't find the process model name as AX New Vehicle. Please suggest. I am sharing the link of the document: academy.appian.com/

Hi all, I just want to ask if I could create a website with appian? or appian just for creating moblie applications?

here i have add A and B and show it in A+B row....[A+B row is read only] these rows am storing in value_txt field  shown in below so i have add the value_txt data where extensionRefId=4 and 12 and show the value in that integer field which refid=14 i had tried to write like index(fv!item.value_txt, wherecontains(4,fv!item.extensionRedId),{}) but this did not work can anyone help me with this 

Having a hard time seeing that the checkbox is marked in the control when it's disabled. Is there a way to increase the visibility on the check mark?

I want to filter out current month dates in a list  "9/9/2022", "9/8/2021", "10/7/2022", "9/29/2021", "10/24/2022", "7/19/2022", "5/16/2022", "8/15/2022", "9/14/2022", "10/14/2021", "1/13/2022" Expected result: {"10/7/2022","10/24/2022"} Can somebody help me with this ?

a!richTextDisplayField( value: { a!richTextItem( text: "Create New Ticket", link: a!startProcessLink( label: "Create New Ticket", processModel: cons!PM_TESTPTS, <-- Able to call process model bannerMessage: "Updated details for " ), style: "STRONG", color: "POSITIVE" ) } ) I think its impossible in appian to call process model ? but still there can be way

I took my appian level 2 exam a few months ago. And it is valid only for 2 years as far as i know. I heard that validity can be extended by following some courses. If anyone know about it please help me with the relevant link of those courses. 

Hi everyone, How to get name and link of environment (Test/Dev/Pro) that using Thank you.

Working with a student who accidentally deleted an images folder. He can put the images back but they all have new ids, so the table which stores the id numbers is now woefully out of date. Is there any way to assign an id to an image, so that the images we recreate will have the same numbers as the table?

Hi All, We are facing the errow : A null parameter has been passed as parameter 1 at function a!fileUploadField. Is anyone aware what can be the possible scenario for this error? Kindly advise. Thanks and Regards,Diksha