Discussion Categories

Hi everyone, This is my process model, and I'm trying to find the cause for above issue: So the process starts with receiving the Excel file that user uploaded, then parse the file to get data into CDT type which looks like below: Then I use another script task to index and get all the case Ids. The problem is that when I run it in debug, the Parse File node generate multiple instances, however I check the output variable and the results are not duplicated. I didn't config the MNI either. 

Hi, I have a situation where there is a need to identify the duplicate entries in a database table and delete the duplicate rows. How can I do this?

Hi , when I sort on a record backed read only grid , sort field that is stored is in the format #"urn:appian:record-field:v1:ff132d24-cf88-4234-88ae-9fe224dd3dfd/b05761f7-3e63-4e76-bb2b-10c4886815d8. I need to store this sorting preference for each user level. This is not being stored in record field type. its type is string. Even if i want to cast it to record field I am getting error that cast invalid. Only way i could find to covert this into a record field is by using eval() function. But eval() function is a hidden one. Can some one give me an idea on how to handle this? Thank you

So I was finally able to get some phone number validation working. However, it only works in the interface and not when I'm actually using the record action. Here's the code the error message I'm getting. I think this is happening because the record action relies on user input and perhaps starts off as null. I'm just hoping there's a way to fix it.When I try to create a new contractor through the record action: Error Evaluating UI Expression Expression evaluation error [evaluation ID = 0932b:f622d] in rule 'ds_createcontractor' at function 'search' [line 65]: A null parameter has been passed as parameter 2. a!textField( label: "Phone Number ", labelPosition: "ABOVE", placeholder: "### - ### - ####", saveInto: ri!record['recordType!{d327a5dc-18d4-4ffd-8bdf-6a22b134677f}DS Contractor.fields.{f4c57b1e-a70b-4b5c-abfd-91fbfa77c38f}conPhoneNumber'], ref

Hi there, Our business is having a problem when using a queryEntity in Appian for a certain field. It converts that field to an NVARCHAR(4000) (I'm assuming because it's a text field) even though our Database and Data Type have it listed as VARCHAR(50). In SQL Server, when comparing an NVARCHAR to a VARCHAR, it causes an implicit conversion of all data in the VARCHAR column which is a big performance hit for us. Is there any way to make sure that the parameter uses VARCHAR(50) instead of NVARCHAR(4000)?Thank you

I am trying to aggregate a record type data and display it on UI using a!gridField(). Please help me with it.

if the Locale settings is "English (United Kingdom)" then invalid date format error should display dd/mm/yyyy . Appian is hosted in USA. Calender by default is giving mm/dd/yyyy.

feedback: when you try to create  sub folder and forgot to select the parent folder then there is no options on next screen to go back and select the parent folder. also once the folder gets created and you select that object and go to properties, there also no options to select the parent folder. only options you left with is to delete the folder and create new with parent hierarchy. hope in next release this will be considered as positive feedback and some feature will be provided to select the parent folder.

Hello,this question is connected to this. I have created a related type with a related action that calls a process model; i have a column in the list that start this process model. The record type has this security: <ADMIN user group>: Administrator <ALL USERS>: Viewer The process model has this security: <ADMIN user group>: Administrator <ALL USERS>: Initiator The integration service called by the process model has this security: <ADMIN user group>: Administrator <ALL USERS>: Viewer Please give me some hints.Thanks in advance.Marco

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

I'm looking for function to open interface2 in new tab" not the same tab"  by clicking a button in  interface1  

Hi , We are using 'receive file over SFTP' configured as MNI node for getting files from SFTP location. but we are getting connection timeout error intermittently . Restarting process node resolves issues but can anyone help to resolve this issue?com.jcraft.jsch.JSchException: java.net.ConnectException: Connection timed out (Connection timed out) at com.jcraft.jsch.Util.createSocket(Util.java:349) at com.jcraft.jsch.Session.connect(Session.java:215) at com.jcraft.jsch.Session.connect(Session.java:183) at com.appian.ps.plugins.sftpsmartservices.SFTPConfig.connect(SFTPConfig.java:179) at com.appian.ps.plugins.sftpsmartservices.GetRemoteDirectoryContentsOverSFTP.run(GetRemoteDirectoryContentsOverSFTP.java:66) at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.lambda$call$0(DefaultActivityExecutor.java:136) at com.appiancorp.plugins.PluginUsageLogger.runWithPluginInformation(PluginUsageLogger.java:52) at com.appiancorp.process.runtime.framework.DefaultAc

Hi All, I am working on a use case, where I have configured record with integartion(service backed recordrd type) using a dynamic link in a grid to redirect to summary page, I am getting "The record data does not exist, has been deleted, or you do not have sufficient privileges to access it. (APNX-1-4205-006)" this error while clicking the link to see summary . Can any one please help me what configuration needs to be established to see summary page. .a!localVariables( /* 1. First, configure the integration object to return successfully */ local!integrationResponse: rule!GI_INT_GetClaim(adjustername: "ABC"), todatasubset( a!forEach( local!integrationResponse.result.body.claimsList, cast( typeof( 'type!{urn:com:appian:types:GI}GI_RESP_GetClaimSummaryClaimList'() ), fv!item ) ) ) ) I am getting this output. Am able to see the data in the grid but not able to view summary. Help me to resolve the issue.Tha

The audio of the video is fragmented..... what can I do about it?

I want to generate a report showing where list of users who are not logged in 30 days or 60 days or 90 days. How to do that?

When I use formatjson function, it automatically change "&" to "\u0026" , and "<>" to "\u003c\u003e", how to aviod that? Can anybody help? Thanks

How can I create the nested bulleted list in Appian 

Hi All, I have the requirement to close the task after clicking over the button in interface? Can anyone please help me out?

I have a application , where customers can see their invoices . For ever customer we provide a user id . we store all the invoices across the customers in a recordtype  INVOICES. Now when a specific customer logs in this is the start page. I want to show only the records (invoices) speciifc to customer I am using SITE and Invoices as Records/List

Hi everyone,  I want to set a start timer for my process model, in which start date time will be provided in advance, and if the given start date time is within work hour (9-6pm Monday to Friday), the process model will send an error message stating it can not proceed during business hours, and the process model will not be run.  I haven't had much experience working with process model, so really appreciated if anyone can give me some guidance :)  Thanks a lot!

What will be the number of users the getallusers function retreive? Can this retrieve 20000 users?

I have a requirement with one text field ,adjacent to the label of text field i need to have a check box of boolean type how can i acheive this? Thanks..

Hello,How I can transfer my Certifications from Previous Organization to current organization.

Hi Alll, I have a fileupload control allows multiple files to upload. I should write a validation should not allow duplicate file names uploaded and should not be there in database too. Does anyone had this situation. Your thoughts will highly help me.

Hi Team, After creating a CDT properly, I am unable to verify  Entity mappings in the data store. It is giving me the below error. Note:- Record type is generated and synced with the table already available in the DB. I want to keep my table name in uppercase [NT_NH_Handover_History] but during entity mapping i downloaded DDL, it is asking me to create a table with the name in lowercase ntnhhandoverhistory. I have to keep the table name in upper case. Could you please suggest?