Discussion Categories

Hi, I need to pull values from DB which does not starts with "ABC" for example. a!queryEntity(entity: cons!entity,query: a!query(filter: a!queryFilter(field:"office",operator: "not starts with", value:"ABC"),pagingInfo: a!pagingInfo(startIndex: 1, batchSize: -1))) But this is ignoring null values, I want null values also to be returned along with other values. So I just tried fetching only null values to see how it works.  a!queryEntity( entity: cons!entity, query: a!query( filter: a!queryFilter( field:"office", operator: "is null" ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: -1) )) this is giving me 0 results. Nots sure what might be the issue. Can anyone please help? operator "not null" returns correct values, problem is with fetching null only.

Hey Appian Community Team, I am currently trying to map v22.3 relationship properly to an outer join that is SQL based query which is a view itself. Fundamentally im talking about inner and outer join to map for e.g. PID to REF PID. I was thinking of source filter but it will probably face limitations as well. An extract of the code is listed below (SELECT A.REF_PROPOSAL_ID, LISTAGG(CASE WHEN CATG.IS_SUBCATEGORY = 0 THEN CATG.CODE END, ', ') WITHIN GROUP (ORDER BY CATG.CODE) CATEGORY_CODE, LISTAGG(CASE WHEN CATG.IS_SUBCATEGORY = 0 THEN CATG.CATEGORY END, ', ') WITHIN GROUP (ORDER BY CATG.CATEGORY) CATEGORY FROM ABC_PROPOSAL_CATEGORIES A INNER JOIN ABC_PROPOSALS P ON A.PID = A.REF_PROPOSAL_ID INNER JOIN ABC_CATEGORIES CATG ON B.PID = A.REF_CATEGORY_ID GROUP BY A.REF_PROPOSAL_ID ) B,

He everyone! So, I've created a ER to fetch data from database, using a stored procedure. However, it seems being limited by 1000 record by search. Is it possible to change this config. If so, anyone can tell how should I procced ? One option it to dismember the search and do it little by little, until fetch all data requested, but I rather to try something more easy and smart.

Hi All, Can anyone please help me, How to refresh the columnlayout field inside section layout? Thanks in advance!

hii all, we have a requirement of  uploading a excel file and once user click preview the entire data in the excel should visible in grid for user , and once clicked on submit then the data should store in database  for achieve this we are plane to use a staging table(dummy db) for storing uploaded excel data and showing in grid , once user click submit the data in staging table should move to main database table and need to delete the staging table data , why because if the staging table not cleared the next user data also store and entire data in the staging table will appear in grid  please help with this , guide me  to achieve this. thankyou, Ramesh

Hii Experts, I am trying to create a expression rule to find out the difference in CDT (for Audit log) using CDT Comparison plugin. Could anyone help me out how to create ER for that  Thanks

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