New to Appian

Q1.  what is difference between null, empty,blank Q2. can I use for  a!isnullorEmpty() for removing/checking null,empty and blank or apply different functions for checking them.

a!localVariables( local!priceId: http!request.queryParameters.pgenId, local!docId: http!request.queryParameters.docId, local!entities: a!forEach( items: local!pgenId, expression: a!queryEntity( entity: cons!DS_ENTITY1, query: a!query( logicalExpression: { a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "priceid", operator: "=", value: local!priceId ), } ) }, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 50) ), fetchTotalCount: true ).data, a!queryEntity( entity: cons!DS_Entity2, query: a!query( logicalExpression: { a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "docId", operator: "=", value: local!

Hi All, I have a query in export dse to excel. How many characters or word count can be exported in one column of excel? Thanks!

I have a local variable that holds an array. When I pass this local variable to a a!forEach items, it does not loop. When I take the array value and paste it directly into items, it works. Why is it not working when I pass in the array from the local variable? a!localVariables( local!groups: { cons!AX_ALL_USERS, cons!AX_MECHANICS, cons!AX_REGISTRARS, cons!AX_SUPERVISORS, cons!AX_ADMINISTRATORS_POINTER }, { a!sectionLayout( label: "Groups for " & loggedInUser(), contents: { a!gridField( label: "", labelPosition: "ABOVE", data: todatasubset(a!forEach( /* WORKS */ items: { cons!AX_ALL_USERS, cons!AX_MECHANICS, cons!AX_REGISTRARS, cons!AX_SUPERVISORS, cons!AX_ADMINISTRATORS_POINTER }, /* DOES NOT WORK */ /*items: local!groups,*/ expression: { {

Hi Could anyone help me to know how can i access the below "backup" Schema in appian cdt/record , whenever I create cdt/ record type I can only see tables from "Appian" schema, cannot access "Backup" Schema

When applying an edit action to a dropdown field. Due to the lack of an enumeration data type, the dropdown field may inadvertently transform into a text field when an edit action is applied.

a!gridField( data:local!data, columns: { a!gridColumn( label: index(local!labels, "id", null), sortField: "id", value: fv!row.id ), a!gridColumn( label: index(local!labels, "createdBy", null), sortField: "createdBy", value: fv!row.createdBy ), }, pagingSaveInto: local!pagingInfo, selectable: true, selectionValue: ri!idDoc, selectionSaveInto: ri!idDoc )

if(a!isNullOrEmpty(fv!row['recordType!AX Vehicle.fields.image']) ,a!EXAMPLE_DOCUMENT_IMAGE(), fv!row['recordType!AX Vehicle.fields.image']) Hello AppiansI am new to Appian and following the Appian developer learning path I faced an error in "write a maintenance record" of the process model, tried to solve it but in the end, I deleted the project and started a new one and now I am facing this error "Error Evaluating UI Expression Expression evaluation error at function a!gridField [line 51]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Image"] has encountered an error. Expression evaluation error at function a!imageField [line 51]: Invalid Content ID" this error shows up once I add a new Document Image column in the list of the vehicle record type and for some reason, the Acme Auto Solution Application already built has the same error So I guess the problem is not from the expression or the record

Hi All, I am getting this error while adding new column record the table. #1452 - Cannot add or update a child row: a foreign key constraint fails (`Appian`.`ISR_j_Product_TherapeuticArea`, CONSTRAINT `j_taProduct_fk` FOREIGN KEY (`therapeuticAreaId`) REFERENCES `ISR_TherapeuticArea` (`therapeuticAreaId`) ON DELETE NO ACTION ON UPDATE NO ) Could you please let me know how can we resolve this, 

Hi! I´m using an enviroment from a partner to practise. When I want to start with the exercise of chapter "Design appian Records, part 1" ask me to look for "AS_Vehicle" in the application (topic 4). I don´t know why in my environment I don´t have it. Could you tell me how fix this? or can I import this from some place? Thanks!

<html>   <head>     <title>Appian Embedded Interfaces</title>     <script src="">example.appiancloud.com/.../embeddedBootstrap.nocache.js" id="appianEmbedded"></script>   </head>   <body>     <h1>Appian Embedded Interfaces</h1>         <appian-action processModelUuid="example uuid" ></appian-action> In the above code I replaced src and Uuid with my cloud server url and uuid of my process model I have followed the embedded interface document provided by appian to configure this. i have also added cors in admin console as chrome.google.com ERRORS : 1."from origin 'null' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource." 2."Failed to query server. Status Code: 0"

Hii, I have a requirement to generate pdf file based on count, For ex- If i have a local that have 2 item (count) then 2 pdf page should be generate if 3 item then 3 pdf page should be generated how can i do that ?

Hi Expert I want to find members from two groups. can anyone help me how to write expression rule for that? Thanks 

Hi All, I have a query regarding date field validation. In my case i want to put validation on date field when user have existing date value and if user clear that existing date value at that time i want to show a validation like, date field should not be empty. for this i have applied may conditions but it fails because of the limitation  on validation property which says: "Validation errors to display below the field when the value is not null."            so i want that validation, only when user clear the existing value from date field. below is my code can any one help on this? i have one variable in which i am getting existing date.

Hi, Sometime the send Email smart service is taking huge time for sending an email. Please provide some suggestions for troubleshooting. Thanks, Preethi

a!forEach( items: pv!id, expression: a!save( rule!Test_getDossierByDossierId( dossierId: fv!item, pagingInfo: a!pagingInfo(1, - 1) ), pv!id ).data)

Hi Team, I would like to understand the refresh rate for a readonly grid. What all options are available to refrehs the data based on action completion or loading data etc

Hi Everyone, is it possible to stop this dialogue box, if yes , How can we stop this dialogue box when we click on save option?

Consider there are three steps in a process which run parallel and each of the task is assigned to three users, now you need to design the process in such way that if any of the user completes a particular task then other two tasks has to be cancelled, what is your design approach in Appian

Hi All, I'm new to appian plugin development. I need some kind of road map where to start and how to develop my knowledge. I have basic understanding in java. What is the basic requirement that is needed for a plugin development.  Thanks!

Hi, I have a Web API which has around 5830 characters. Since Web API has restriction to use only 4000 characters. So am planning to write codes in Expression Rule and call in web API. If i call Http!request in Expression Rule its throwing error. Can someone help me with example how to call expression rule in Web API.

Hi, I am getting huge amount of data and needs to write it in database. Its taking so much time  Have used  a!writeTodataStoreEntity(dataStoreEntity:cons!APM_DSE_VALUES, valueToStore: local!data) In local!data  am calling rule Can someone help me how to convert it in forEach loop or in batches. Please help with code

Hi All, I have one query related to time zone conversion. I have start and end date with EDT time zone, and i have to convert this date with given time zone like Mountain, Pacific, Eastern so on. Can any one help me with same. Thank you

Hi All, I ma using the start process smart service in parent process model with activity chaining enabled in both parent and child process. The node start process smart service is taking long to execute. Can anyone please suggest how to reduce the time taken by the start process service. Thank you!

Hi, I am trying build read only selectable grid. a!localVariables( local!businessModuleStatus: rule!CR_QE_getModuleStatusForBusiness( cif_int: ri!cif_int, moduleId_int: ri!moduleId_int ), a!boxLayout( label: index( local!businessModuleStatus, "workflowDesc_txt", "" ), style: "ACCENT", contents: { a!gridLayout( spacing: "DENSE", headerCells: { a!forEach( items: cons!CR_MODULE_STATUS_GRID_FIELDS_FOR_BUSINESS, expression: a!gridLayoutHeaderCell( label: fv!item, align: "LEFT" ) ) }, columnConfigs: { a!gridLayoutColumnConfig( width: "DISTRIBUTE", weight: 2 ), a!gridLayoutColumnConfig( width: "DISTRIBUTE", weight: 2 ), a!gridLayoutColumnConfig( width: "DISTRIBUTE", weight: 2 ), a!gridLayoutColumnConfig( width: "DISTRIBUTE", weight: 2 ), a!gridLayoutColumnConfig( width: "DISTRIBUTE", weight: 2 ), a!gridLayoutColumnConfig( width: "DISTRIBUTE", weight: 2 ) }, rows: { a!forEach( items: l