General

a!localVariables( local!seg, loca!nombre, local!apellidopat, local!apellidomat, local!buc: 00000121 local!buc: 00000187, a!textField( label: "BUC/NÚMERO DE CUENTA/NÚMERO DE TARJETA", labelPosition: "JUSTIFIED", instructions: "", placeholder: "Ingresa los datos a buscar", value: ri!busqueda, saveInto: {ri!busqueda, if(local!contador <= 17,{ a!save(local!seg,rule!PE6A(local!buc).result.body.partyRec.partyInfo.serviceLevelDesc), a!save(local!nombre,rule!PE6A(local!buc).result.body.partyRec.partyInfo.personPartyInfo.personName.givenName), a!save(local!apellidopat,rule!PE6A(local!buc).result.body.partyRec.partyInfo.personPartyInfo.personName.paternalName), a!save(local!apellidomat,rule!PE6A(local!buc).result.body.partyRec.partyInfo.personPartyInfo.personName.maternalName) /* realiza la busqueda por numero de Tarjeta */ }, if(local!contador < 12, { a!save(local!seg, rule!PE6A(local!buc2).result.body.partyRec.partyInfo.serviceLev

Hi Community, I followed the Appian quick start installation guide, and ran all commands:  <APPIAN_HOME>\services\bin\start.bat -p <password> -s all <APPIAN_HOME>\data-server\bin\start.bat <APPIAN_HOME>\search-server\bin\start.bat <APPIAN_HOME>\tomcat\apache-tomcat\bin\start-appserver.bat Everything ran successfully, but when I went to my browser and navigated to http://<FQDN>:8080/suite/design/users, it wasn't connecting, tried different browsers same result. I replaced the FQDN with what I entered in conf.suite.SERVER_AND_PORT= and it is un-commented so is conf.suite.SCHEME=. I'm not sure what else could have went wrong. If anyone have resolved a similar issue your input would be most welcome. Thanks, Eric

Hi, I am facing an issue while importing applications into different environments due to nested CDTs. Getting error "An error occurred while creating datatype [uuid={urn:com:appian:types:ADMIN}ADMIN_DF_PI_createConfig]: The XSD could not be imported because it references a missing type: {urn:com:appian:types: Q1}ADMIN_DF_PI_resource. No types have been imported. (APNX-1-4049-001) (APNX-1-4071-007)" here ADMIN_DF_PI_createConfig is parent CDT, and ADMIN_DF_PI_resource is child CDT, both are existing in the same application Due to this remaining CDTs also not imported "The datatype [{urn:com:appian:types:ADMIN}ADMIN_CRE_siteDetails] could not be transported. Cause: The data type [{urn:com:appian:types:ADMIN}ADMIN_CRE_siteDetails] could not be imported because another data type failed to import. In order to ensure consistency, unless all data types inside and outside the package successfully import, no data types are created or updated. (APNX-1-4071-019) (APNX-1-4071

Hi  I want to record my own voice and play it via button or link. is that possible?

    How to remove values in this grid?

Hi , My requirements are i need to get the above images based on the no of listing id's i have. I also need to get  the address  and price and all details should be dynamic also . Can anyone please help me out here .  Below i have attached my  code  a!localVariables( local!houses:rule!SHA_qe_getDocuments( entityId: index(ri!Document,"entityId",null) ), local!address:rule!SHA_qe_toGetPropertyAddressDetails( listingId: ri!listing.listingId ), local!listingData:rule!SHA_LISTING_EXPRUL(listingId:ri!listing.listingId), local!numCols: 3, local!selectedCard, local!selectedInterface, { a!columnsLayout( columns: a!forEach( items: enumerate(local!numCols)+1 , expression: a!localVariables( local!colIndex: fv!index, a!columnLayout( contents: { a!forEach( items: local!houses, expression: a!cardLayout(

Hello,  I am thinking how I can achieve something like this with seal only,  a!localVariables( local!data: if( isnull(local!a1), updatedictionary(), /* Second Condition */ if(isnull(local!b1), ), ), null ), local!data ) basically if condition for null value, if it is null exit, if it is not null do action and that check next value, problem is that in the if there are condition, true(), false()) where it does not allows a action with another if inside the result part.  Any idea which is the best approach ?

Hi Friends, Logically how to change the date field mm/dd/yyyy to dd/mm/yyyy. Tried many way but to me not getting correct answer. Please share your ideas.

Hi All, We have a requirement of closing the current tab in a browser when user clicks on link/button in Appian. For Instance, in a browser I have multiple tabs opened and among that one of the tab is Appian. I have a screen built in Appian and when user clicks on that particular link/button the current tab should be closed. Any thoughts would be helpful in this area. Thanks In Advance!!

Hi ,We are generating report using HTML and converting it into PDF. We are using HTML to PDF smart service for conversion.Now we need to show/hide few section in the  report based on some conditions. We used style="display: none" in html. but this is not supported by HTML to PDF smart service.P.S: We already tried using PDF from HTML smart service, but due to some design issues we started using HTML to PDF smart service.Is there any other possibility to hide/show some sections in report which is supported by HTML to PDF smart service?Thanks in Advance.

Hi Team, We have a requirement to place a signature in PDF. We created two ways of solutions. Please find the below details, 1.Signature Component and PDF Utilities plugin. 2.Docusign integration As per my organization suggestion, Docusign needs to purchase a license. But here we want a solutions for R&D purpose. Hence we are not able to purchase any third party license. We used signature component and PDF utilities(Image to PDF) to merge the signature into PDF. Question: But we need to send X and Y coordinates to place a signature in right place in PDF. Is there any way of solution can User picks X and Y coordinates in Appian else share your suggestion too. Thanks, Pradeep Sridharan

Is there a way to restart the course. I am not able to see the activities again. Only course vedio can be restarted.

Hello, is there a way to optimize the reading of excel file with Excel Tools Plug-in. In general the reading time it takes to long, for example to read 70 cells it takes about 5 minutes, for something like that :  a!localVariables( local!data: 'type!{urn:com:appian:types:BTR}BTR_D1_B'( /* 18 */ c18_1: excelreadcellsbynumber(excelDoc: ri!document, sheetNumbers: {6}, columnNumbers: {4}, rowNumbers: {39}), c18_2: excelreadcellsbynumber(excelDoc: ri!document, sheetNumbers: {6}, columnNumbers: {10}, rowNumbers: {39}), c18_3: excelreadcellsbynumber(excelDoc: ri!document, sheetNumbers: {6}, columnNumbers: {12}, rowNumbers: {39}), c18_4: excelreadcellsbynumber(excelDoc: ri!document, sheetNumbers: {6}, columnNumbers: {14}, rowNumbers: {39}), c18_5: tointeger(excelreadcellsbynumber(excelDoc: ri!document, sheetNumbers: {6}, columnNumbers: {17}, rowNumbers: {39})), c18_6: excelreadcellsbynumber(excelDoc: ri!document, sheetNumbers: {6}, columnNumbers: {20}, rowNum

Hi all, Recently been facing issues with the Email Smart Service. Often, it will fail to send an email if there are multiple attachments (PDFs). Has anyone faced issues with it before where it says "failed to process attachments" although the documents are available? It's causing me a major headache, so I'm thankful for all kinds of input. Thanks in advance, Matthias 

I have created a CDT and it has passed a verification too. But when I try to insert that in the Data Store it throws below error: The data source schema does not match the type mappings: Missing column: a_id in "table_name" (APNX-2-4056-000) Please help

I have this local variable local!variable: {2017,2018,2019,2020} local!variable2: a!forEach( items: local!variable, expression: if(fv!item

Hi I have this code written local!productgroup: a!queryEntity( entity: cons!MPPCONSCDT_megaMasterFile, query: a!query( /*selection: a!querySelection(*/ /*columns: {*/ /*a!queryColumn(*/ /*field: "productline",*/ /*alias: "productline",*/ /* */ /*)*/ /*}*/ /*),*/ aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn( field: "EOMYear", alias: "EOMYear", isGrouping: true() ) } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 ) ), fetchTotalCount: true ).data, I returns below result Is there any way I can remove the null one?

Hello  how to convert this text string: "2022-11-12 00:00:00"(Text) to text string in format "dd/MM/yyyy" ? Thank you!. 

Hi All, I required to generate JSON in the below format for the data that needs to be sent to another system thru integration: Req format:  "[{\"ods_service_affected\":\"testetset\",\"ods_outage_start_datetime\":\"2021-11-30 13:00:00\",\"ods_outage_end_datetime\":\"2021-12-01 22:18:45\",\"ods_utage_duration_requested\":\"02 01:00:00\",\"ods_effect_on_site\":\"off\"},{\"ods_service_affected\":\"1213546\",\"ods_outage_start_datetime\":\"2021-12-01 13:00:00\",\"ods_outage_end_datetime\":\"2021-12-02 22:19:09\",\"ods_utage_duration_requested\":\"01 05:00:00\",\"ods_effect_on_site\":\"lor\"}]" As you can see there are escape characters that were added to the JSON. I tried adding those escape characters however I noticed an additional double quote is getting added to the string. It looks like by default double quotes are added to the values by JSON Below is my code: """ods_service_affected""": """" & fv!item.serviceAffected

I am using user filter in recordtype . Type of filter is daterange. Filter is done by expression rule not by selecting field of record data. I want  start date and end date from daterange picker . How will i get both date? or how can i find data whose date is between this date range.

Dear all, I am facing an issue while I try to run the appian status.sh script  as root user despite the ownership is root. I am getting the following error: ERROR: JAVA_HOME is not set and no 'java' command could be found in your PATH. Please set the JAVA_HOME variable in your environment to match thelocation of your Java installation. Any idea of how I can run it as root? Thanks beforehand. Kind regards,

Hi All,  I have a condition where I want to show a user profile photo if it is there otherwise show initials.  For Image , I am using a!Image and for Initials I am using a!stampField.  Can i use these two together so that if user profile is not present than I can show Initials. Thanks In Advance, Saurabh

Hi,  I have a table where username and password is stored , now in an interface i want to access password based on the username, can it be possible to access data from dB using a constant in the interface?

Hi ,       Is there an Appian function to retrieve Severs' primary locale ? I am looking for something like userlocale() , but specific to server not user. I know this can be be achieved in plugin/java. But I am looking Appian function. Ideally , I am looking for a function which can return highlighted settings in admin console as shown in the screenshot The usecase is a process model scheduled to run as batch which is developed by a single country but runs in different countries with its own servers. I am looking to dynamically disable or enable this PM , by setting up an expression or condition in the start timer.

This feature request involves navigation controls upon Site Action completion.  Currently, as with all Appian Actions, when one is completed the user is returned to the area they initiated the action from. This makes sense in a number of situations, however, not always with Site Actions in my experience.  In most situations I've encountered, a user is expected to submit 1 action at a time.  Typically we will have a few Site Pages, maybe a Home Page interface with general process details/contacts, a Record with some reporting capabilities, and a Action to submit a request.  Currently when the action is completed, the default behavior is to return the user to the same action's start form, essentially now a blank interface for the same process they have already submitted.  This causes end user confusion and creates extra development when we want to show a user a confirmation screen and allow custom navigation.  Best case, an extra click and an orphane