General

When a query is performed the response is a dataset which contains a dictionary. The issue is that the dictionary does not have the proper type casting for the attributes (they are just any types). This means that anytime a comparison has to be done, or a wherecontains is used we must first convert the result of the dataset into a proper data type.  Side note, can we just make wherecontains perform basic type casting.

Can anyone explain why and(null)  is true

I would like to call one record with parameters from within a parent record list.Example: Assume that there are two record lists: one of all companies and of all products of these companies. Is it possible to create a link for each line of the company record list which beams me to the (same) record list of all products, just each time with a different active filter, so that you only see the products of the corresponding company?The only idea I have is to create something in the 1st record under "Views", which is then displayed when clicking a record element, namely an interface that contains a grid as one can give the record element to the interface as a parameter. Is there an easier than that? Somethin like a parameterised call to a record list?

is ther any google service that will use to do comparing the signatures tht comes from the digital documents 

Hi I am trying to filter the record type that should filter either phone or email are not blank AND effectivedatefuturechange = today(). The code below doesnt seem to work Code below: a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter(field: 'recordType!{d3a01eaf-0c5f-4152-adeb-5b84d2b93c49}Address Change Participant Update Extract.fields.{929ea42f-0313-4410-8b8f-2049b30883bc}phonenumber', operator: "not null"), a!queryFilter(field: 'recordType!{d3a01eaf-0c5f-4152-adeb-5b84d2b93c49}Address Change Participant Update Extract.fields.{c8a513f8-9294-4156-9e62-a68d1204107f}emailaddress', operator: "not null"), } ) a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter(field: 'recordType!{d3a01eaf-0c5f-4152-adeb-5b84d2b93c49}Address Change Participant Update Extract.fields.{f4749c47-5f0a-4b1b-ab9a-0cd2a6045e2b}effectivedateforfturechange', operator: "=", value: today()), } ) Any help is appreciated Thanks

We are using smart service Export SQL to Excel in Appian to generate Excel report. All columns are retrieved as expected but only date columns are transformed into Text fields and applied filters in Excel are Text not Date related. If columns are taken directly from database it works fine but presented formatting is Excel is "MM/DD/YY HH:MM:SS" but our requirements are that all date fields have to be presented as "DD.MM.YYYY HH:MM:SS" . Using TO_CHAR or TO_TIMESTAMP functions didn't work again exported date columns are formatter as a text. Columns which are part from the CDT are Date and Time format as well. Do you have any idea how we can convert date fields to the mentioned format without losing date format after export to Excel? There is a similar topic but without any answers:  Appian Community. Thank you!

I want to make this Form. It is not allowed to move to the next steps unless the person fills in the required fields. But I can't activate the "required" feature, even though I added it in HTML. Therefore, I want you to help me and add or activate a required feature to Exact field in that form. But I don't want all the fields, I just want them when I put the word required. And when I add new fields, I want them to work as well. I also want to increase the width of the form to 90% of the total area, while also increasing the size of the progress bar.here is my full (HTML, CSS and JS):  https://jsfiddle.net/Maroz/s19q3gnf/3/

Hi,  I want to disable document link from read only grid if document is not exists or deleted from document folder.I am using following code to show and download document from read only grid. a!gridColumn( label: "File Name", value: a!linkField( links: a!documentDownloadLink( label: index(fv!row, "myFileName", {}), document: index(fv!row, "appianDocId", {}) ) ) ) Please Suggest me any solution for this.

Team, I am having a requirement to generate an excel document from data available as list of CDT (Storing data to DB not allowed). Need suggestions on this.

Hi ,     I am having a drop down with 4 choice values A,B,C,D. Based upon the value selected for Eg; D, a  section will appear below. My requirement is when the drop down value selected is D, then below section should be refreshed i.e. set the section fields to null if the drop down value selected is either D to A or A to D or B to D or C to D , then below section should be refreshed i.e. set the section fields to null. if the drop down value selected is either B to A or A to C or B to C, then below section should not be refreshed. so for this requirement i want to save the previous selected value of dropdown to compare with the latest selected value in order to do the refresh. please provide your suggestions or any other idea to do this requirement. Thanks in advance Pradeep.B

Hi everyone, is the Associate Developer Practice Test representative of the actual exam? Will passing this Test guarantee you passing the real exam, or are there other materials of tips needed to pass the actual exam? Thanks in advance.

Hi All, Is there any possibility to showcase the Record Type VIEWS in Vertical order? Currently the VIEWS are in Horizontal order. Thanks in Advance.

Hi,  We are planning to migrate Appian to cloud from on premise. Could I please get some pointers on what needs to be changed in the code, what's not available in cloud but is available on-prem, and other important details?  Thank you!

Hi, We have requirement to send an escalation email notification to assignee's manager ( Organization AD) if user input task is not actioned within stipulated time. Can you pls suggest if this is possible in Appian to obtain someone's manager name dynamically ?

Hi all, We are having problems when a user enters special characters ($,<,> etc) in an interface. The data is stored in the DB and later on reloaded in the form incorrectly. I have checked in our Oracle DB that value for NLS_CHARACTERSET is WE8ISO8859P1 and the value for NLS_NCHAR_CHARACTERSET is AL16UTF16 Does that mean that our DB is not configured to handle special characters? Should we ask our DBA to change the configuration in order to support the special characters? Alternatively, is there any way to solve the problem from the code? I have seen in similar questions that a clean or substitute function could help. I think the best option is to write a funcion with multiple substitutes to store < instead of "<" and so on. Thanks a lot!

Hi Team, Getting an error while restarting the engine server. It says  'execution01 K engine process not running on port 5029 yet' Any help is appreciated.  Thanks, Anandita

Hello,  I have a use case where end users must be able to define "functions" that will be applied to values defined in the application.  I was wondering if it was possible for the end users to write an Appian function with SAIL format in a paragraphField and then "translate" the generated text into an actual function ? Is it possible maybe thanks to Appian Java API ?  Thank you in advance, Claire

Hi all, I need your assistance to solving the situation which is important for my project. I need to modify the logfiles which I know generated automatically. I just need to add some field in the perflog/web_api_details.csv file. How shall I do this?  Is there a way to manipulate log4jconfig.xml in Appian cloud environment to capture additional information in perflog/web_api_details .csv file. Please suggest. Thanks in Advance.

Can we pull news feeds comments from db? I do not have access to the table tp_feed_entry, is it the right table to look at ? Is their any other way to pull those?

Is it normal for taskid to change multiple time during a short process model?  I have a process that has  a UI node, followed by an XOR and an email node. I took samples of the TP!id at the start middle and finish and found it changed a whole 3 times for a simple accepting of the task to the end of the process. 

Hi - Is there any easy way to compare Appian DB Table schemas from different environments just like other Appian Objects we do Compare and Deploy? Some of the tables have custom properties which we updated from Backed through SQL scripts and was not possible from CDT. Before deploying I want to find out difference between two environments so that i can prepare script to deploy the changes. Thanks. 

Please can someone have a look and tell me  what I am doing wrong here ?

I would like to automatically regression-test an Appian App. The idea is to populate a dynamic, nested, conditional Appian UI with minimal to no changes on Appian side. Test cases have to be defined in AzureDevOps and using Selenium is considered an option. So far, I see two alternatives: I could image to define a REST-API for the corresponding form, if that is straight forward. By straight forward I mean that only a few lines of configuration on Appian side are allowed. The challenge is the current architecture of the interface with submit-buttons on a parent form and data to be entered in an interface nested inside the parent UI via rule-input. We tried to use Selenium (without any changes on Appian side), but the trouble is to identify the buttons or to populated the pull-down menus etc. since all elements have names which change between deployments of environments, as far as I can tell. Is there a way to inject an additional, constant, user-defined CSS-property to each an every el

Anyone willing to help with calling record data and using Record Action within gridLayout component. This I can implement using gridField, but I have to use editable gridLayout. Thank you in advance

Hi,    How we can change appian default message The task may have been deleted or completed by another assignee.  Getting this error when trying to open completed or submitted task by another assignee.Is there any possibilities to change this The task may have been deleted or completed by another assignee  to Custom text. Please find the below screenshot for more details.[mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05] [mention:6b9f80ff18f9420082d13ef2d5121d56:e9ed411860ed4f2ba0265705b8793d05] Thanks in advance