Foundation

Recently one of the dev updated the Excel tools plugin from 2.0.2 to new 2.2.13 version in Appian and this has lead to breakage of the Export CDT To Excel smart service. can anyone suggest what can be done to resolve this issue?Note:  We are on Cloud. We tried to use the new Export Data Store to Excel plugin however it does not support XLSM files. EDIT: Export Data Store to Excel also does not support alias with space in it. this makes it hard to generate excel files in user friendly manner. We use the generated files to upload to a system and it requires header to be in specific manner and does not accept with different headers.   Example:       Previously: First Name      Now: First_Name Thanks,Bhushan.

In creating new group, I have recently created an application with the new group name Acme All Users, but I deleted my entire application and wanted to start over. Now, when I create the same application name and same group name as Acme All Users, I see the error saying Name already exist. Where do I go to totally delete this group so I can start from scratch.

/* I am trying to extract cancelled status but having error. Can you please help me. Thank you*/ a!queryEntity( fetchTotalCount: true, entity: cons!CAS_DSE_VIEW_POLICY_RECORD, query: a!query( pagingInfo: if( rule!GBL_isBlank(ri!pagingInfo), a!pagingInfo( startIndex: 1, batchSize: 5 ), ri!pagingInfo ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { if( rule!GBL_isBlank(ri!policySearch.policyId), {}, a!queryFilter( field: "policyId", value: ri!policySearch.policyId, operator: "=" ) ), if( rule!GBL_isBlank(ri!policySearch.currency), {}, a!queryFilter( field: "projectCurrency", value: ri!policySearch.currency, operator: "=" ) ), if( rule!GBL_isBlank(ri!policySearch.carrierPolicyId), {},

Hi , If we have 2 rows of buttons which holds separate SAIL forms on each button click, i.e. calls different SAIL UIs with a choose function. And I want to submit the form and come back to the same selected button. Is there any way to do this ? Because once I click on a submit button configured in any of the SAIL UI, it is taking me back to the first selected button called SAIL, rather than staying on the same button SAIL UI. Is there any way I can stay on the same page the button was selected once I submit where submit is true ? For Example :-  Row 1 is having Tab 1, Tab 2, Tab 3 and so on If I select a tab from Row 1 then in Row 2 I see sub tabs ex- on selection of Tab 1 I will see Tab 1.1, Tab 1.2, Tab 1.3 and so on Now if I am on Tab 1.3 and want to submit my form, I expect Appian to stay on same tab i.e. 1.3. But it is going to the first sub tab i.e. 1.1 ​ Is this a normal behavior in Appian or some issue with implementation

Hi All, In one of my POC I am having requiremnt of converting a document(jpg,pdf) into base64 and storing the base64 in Database. I am using Base64 to Database Services to store the document, but instead of base64 string it is storing Appian ID itself. Below are the screenshots of smart service node and database design. Any comments on this would be appreciated. Thanks Table Structure (also I tried Varbinary, blob data type for base64)

We are having a requirement where we are getting values from an external application via a webAPI. In the web API we are casting the data into a CDT.The value we receive from the application would be something like.{"person" : {"name": "Shaun","age" : 27},"address" : {"addressLine" : "24-Wall Street","city":"London"}}.After this we are casting this into person and address CDT in appian and passing to the process model. If the person and address values is empty we would be receiving the data like {"person" : {},"address" :{}}.Now when I am casting this null Data inside CDT, this is getting casted and passed in process model like [name=null;age=null][addressLine=null;city=null]. I need to perform a null check in process model on these values which is getting failed.Also when I am checking the length of "person" or "address" its showing as 1 instead of 0.

The "Save Interface As Action"  option is not available to me in the Save Interface As dialog. Can anyone please help on why this behavior? Thanks in advance.

Hi, i'm trying in an editable data grid to "intercept" o simulate the "on data change" event. i want to return a rule input value to the parent interface that called the actual interface (with an a!save of the input passed) when data in the datagrid are changed but not saved. So if i remove a row, add a row or save data the events are present and all go right. The problem is that i cant do an "a!save" of the ri! paramenter when dataChange in the editable datagrid.

The only documentation I've seen does not have any examples for this object type. I managed to create one shown below but I don't know if this is correct. Some input/guidance would be appreciated. ## connected system credentials for API## Name: WM Maximo Passport Connection content._a-0000e671-0a5b-8000-9c01-011c48011c48_9065909.baseUrl=evelopment..com/.../content._a-0000e671-0a5b-8000-9c01-011c48011c48_9065909.authTypeOAuth Client Credentials Grantcontent._a-0000e671-0a5b-8000-9c01-011c48011c48_9065909.clientSecret=myClientSecretValuecontent._a-0000e671-0a5b-8000-9c01-011c48011c48_9065909.clientId=myCleintIdvaluecontent._a-0000e671-0a5b-8000-9c01-011c48011c48_9065909.tokenUrl=development.com/.../token

HI, I have the code below but only one file upload is allowed. How do I make it multiple upload? a!fileUploadField( label: "Attachments", labelPosition: "ABOVE", target: cons!Electronic_File_Checklist_Document_Folder, maxSelections: 5, value: ri!Electronic_File_Processing.attachment1, saveInto: ri!Electronic_File_Processing.attachment1, validations: {} ) Thanks in advance Neil

Hi I have table with fields of school1, school2,school3......school10 and value1,value2,value3,value4,value5.......value10 fields and remark1,remark2,remark3....remark10 so I need to display school1 to school10 fields data  under "schools" grid column as well as "values" fields and "remark" fields. as below format schools Values remark school1 value1 remark1 school2 value2 remark2 school3 value3 remark3 school4 value4 remark4 school5 value5 remark5 Can any one suggest. Regards, Devi.

Hi All,       As the OOB News Functionality in Appian (Feeds),      can we have the same functionality like news inside an Interface(Site Specific) Warm Regards Vineeth

I have a use case where the client would like to be able to select a value from a dropdown, and depending on the value be navigated to a new UI. I was previously navigating the user to a new UI using startprocesslink on a card layout.  Is there any way to use a startprocesslink on a dropdown field?  

Hello All,  Email notifications (process alerts and emails from send email node) are not working.This was working fine and users were receiving emails until last week. but they are not receving any  emails for the last two days. There was no change in custom.properties file alsoDid someone face a similar issue?

Hi , I want to add filter condition  from interface to expression rule(Query Entity). In existing scenario on interface i am using below code to display error message . Now same functionality i want to achieve at query entity filter condition. I want to filter my data at first level only instead to pop error message on interface. Can you help me to add below condition in query entity.  Filter Condition which need to be add on Query- count( rule!getValidationFilter( index( ri!masterDataSet, "nameID", {} ) ) ) >= 1 Basically i want to apply above rule in query entity . Master data should be filter out where count is greater then 1 or equal 1. QUery Entity- a!queryEntity_18r3( entity: cons!MASTER_TABLE, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { if( rule!APN_isBlank( ri!nameID ), {}, a!queryFilter( field: "nameID", operator: "=", value: ri!nameID ) ) } ), pagingInfo: local!pagingInfo ) ),

I'd like to create an expression rule that will set the branding for logo, logo alt text, and/or favicon to either a value specified by expression rule, or (if that is null) the default Appian graphics/alt-text.  Also...if the logo/favicon is saved as a document, is this how you display the correct image? todocument(<id as provided by expression rule>)  In essence, I want to write the Expression for the branding as something like these lines: a!defaultValue(todocument(rule!getBranding(attribute: "logoImage")), <Appian's logo's ID>) a!defaultValue(todocument(rule!getBranding(attribute: "logoAltText")), <Appian's default alt-text for the logo>) So, basically--if the rule!getBranding with its specified ri!attribute comes up empty, use the Appian defaults for each of logo image, logo alt-text, and favicon.

Hello dear APPIAN community,  I am pretty new to this platform, so I'm still figuring out the capacity of APPIAN and its limitations. But there is something that I would like to confirm before I invest more effort. Is it possible to integrate SHAREPOINT SPACES just like SHAREPOINT? If not, what would I need to do to  have a 3d viewer that the user can click and interact with on a APPIAN based app. All on the web application platform (and not mobile) of course. I would really appreciate if anyone could give me an answer or at least some directions as to how would I be able to achieve this. Thanks in advance. 

Hello ! currently by using a!documentViewerField() we would be able to view the document in Appian UI in read Only format. In Appian, is there any option to edit the document from UI and store it in KC ? Any suggestions please ?

Hi, I have few questions for my increase my understanding on Appian: 1. How to configure selection on dependent data ? 2. Different purpose for SaveInto Parameter of a Button. Thanks

I have created an editable grid with some values. The values are being fetched from the Database via data store. now I would like to update the changes(Addition, Deletion and Update) made in the grid to the DB. Could you please guide me on how to proceed? Thanks Faisal

I have 25 columns in editable grid i need to set weight of each column using columnConfiguration  it's not happening for more than 15 columns..Any specific reason or appian limitation?or any alternative solution?

I had an idea for how to make PM-generated Emails look on-brand, but I don't know if it's currently able to be implemented. Basically, storing the colors, logo, anything that can be defined with an Expression on the Site designer page in a database table.  Retrieve these branding attributes using an expression rule, and use them to display the Site appropriately. Also be able to access up-to-date branding using the same expression rule, which can be saved as a PV and thus influence an expression-based Send Email Smart Service. As I see it, storing Brand attributes in the database also allows for easy updates to a site's look, while making the transition seamless for any branded emails.  So my question is--can a site's properties/attributes be accessed using any native (or plugin) function?  I was also looking around to see if I can find the UUID of the site itself, but I can only seem to find the UUID for a Constant version of that Site.

We got a traditional task based process running in production. Currently the users don't know the assignee of a task. How do I write into a table as soon as  * the task assignee changed   * the task is accepted by someone in a group ? ( We can design a wait event in process, which will write into DB as soon as the task assignee is changed. But this is memory consuming approach as the event is always active. I'm looking for any better approaches) Thanks everyone

Hi,Could someone help me understand the concept and solve my below problem? I have a Two tables 1. VehicleTypesField Id   category1    Cars2    Buses3   Trains 2nd table SubVehicleTypes SubID Id SubCategory1         1     Sedan2         1     Suv3         2     Luxury4         2     Semi luxury5         3     Ac Trains6         3     Non Ac Trains Requirements:1. Drop Down 1 will have data from Table 12. Drop Down 2 will have data from Table 2 When I select category from DD1 the second DD2 should give Subcategory based on ID(Common in both Tables). ThanksFaisal

Hello All, I have a multiple dropdown that have values ex. "ACTIVE", "PENDING, "INACTIVE".  I need to display all the details with a status like ACTIVE and PENDING. However, I can't do it using a!queryFilter. Here's my line up code for filter. a!queryFilter( field: "status", operator: "includes", value: ri!statusSearch, applyWhen: not(isnull(ri!statusSearch)) )