Discussion Categories

By Using a!recordsChatField() we can get the One Particular Identifier data and its Related Data. But If i wanted to get data for Multiple Identifies. Example : I am having employee and Education Details and Address Details and Certification Details. Now i want to get the Details employees who are L2 Certified and Who Qualification is MCA ? Is There any way to do this by using or Records Chart Field or any Chatbot. Please let me know is there any way to do this. Thanks, Praneeth.

I have a record type called : Global Case  the fields for this record type are : caseId : Number (Integer) , caseTypeId : Number (Integer) Now this record is related to another recordType called : Global Case Type  the fields for this record type are :  caseTypeId : Number (Integer), caseTypeName : Text My database looks something like this :  Global Case :  CaseId CaseTypeId 1 1 Global CaseType CaseTypeId CaseTypeName 1 Dummy Case Type Requirement : I want to display on an UI the case and its caseType in a grid  Approach :  I did a query record type and queried all the cases and then used the relationship to display value. (Code : )  a!localVariables( local!case: a!queryRecordType( recordType: recordType!GCMF Case, filters: a!queryFilter( field: recordType!Global Case.fields.caseId, operator: "=", value: 1 ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1 ) ).da

I want to add chatbot in the application, where chatbot will interact with the application's data.  What are the steps I need to follow ??

Some how some Process models are deployed but not published. Now i need to open a ticket but want to give the list of unpublished Process model at once. Can some one please suggest how to get the list without checking one by one as we have 50+ Process models.

hi I tried to connect postgresql datasource from appian community environment using connected system but cannot connect.Is something missing in the settings?

When I import a full application from dev to test environment, how do I make sure that my process models will be published to the latest version? Is there any special line that I have to add to the properties file so that all my process models will be published to the latest version? or is this done by default on every import? 

I have a record action, once I perform the record action, it'll trigger a process, there is an api call in this process, I want to display the api response right after the action completed. Currently I'll need to refresh after the action complete, I tried to chain the process but not working. I'm not sure if it is because the it takes too long for api to respond

I'm looking for a component that can help me display a result on a "spectrum" of risk from low to high. For example, the risk spectrum is 0-100 where 0-33 = LOW, 34-66 MODERATE, and 67-100 HIGH If the underlying data results in 45, I want to be able to display that on a dashboard that indicates that that is a MODERATE result - would love for it to be displayed/overlaid atop the spectrum for context but can't seem to find a good, common, pattern for this. Thanks!

Hi team, I have a text to display as "Completed with Justification" and it should display as a link and on hovering over on the link, the comments saved in justification field should display.  Can someone help me how to achieve this. I tried as below but it didnt work. a!richTextDisplayField( value: a!richTextItem( text: "PLL Completed with Justification", link: a!safeLink( label: "PLL Completed with Justification", uri: ri!RGRACSLBL_LabelChangeCountry['recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{7ac1eaa1-1093-44b1-a996-7f1610dcc510}justificationForClosure'] ), style: "STRONG", size: "STANDARD" ) ),

In-order to display data over a World map which is an add-on/ plug-in system is accepting the data in : local!test:a!map( 1:{ latitude: "18.1096", longitude: "-77.2975", tooltip: { content: "Jamaica" } }, 2:{ latitude: "35.9078", longitude: "127.7669", tooltip: { content: "Korea (South)" } } ), But while using forEach loop we are getting data from system in below expression and format a!forEach( items: local!getMatchedIntells, expression: a!localVariables( local!id: fv!index, local!name: "", local!lat: "", local!long: "", local!finalDt: a!map( latitude: local!lat, longitude: local!long, tooltip: { content: local!name } ), local!finalDt ) [{'1': {latitude: 23.424076, longitude: 53.847818, tooltip: {content: "United Arab Emirates"}}}, {'2': {latitude: 33.93911, longitude: 67.709953, tooltip: {content: "Afghanistan"}}}, {'3': {latitude: 41.153332, longitude: 20.168331, tooltip: {content: "Albania"

I would need to run two wherecontains within this dictionary array, for example to get a country with a POPULATION greater than 1,000,000 and an AREA greater than 150. how can I proceed with two wherecontains? thanks

I have built a interface for recordtype A to show summary, recordtype A has several recordtype B,C,D...related to it, but I found when I am viewing summary for related record B, it only shows 10 items, even though it actually has 20 items. I changed the grid's pagesize to 20 and can still see only 10 items. Is there a limit when we pass rv!record and the related records only has 10 rows at max?

I have used pickerfielusers in which the group filter is mentioned as "All Groups".  "All Groups" has sub groups inside it called Group A, B , etc. The security of All Groups is "Group Admin" where no member of sub groups are available. Now, as only a member of Group A, when I access the picker, the picker shows me suggestions from only Group A and not the other group members.  All the groups here are "Public", "Closed" and "Low". Is it security of this "All Groups" blocking them from seeing each other?

hi everyone, I get an error that i don't understand when i am trying to save or publish my process , it is throwing an error of type "The process Model contains a node without a name in the site primary language :HEBREW ERROR " for each node that i created on the modeler. nowa few days ago i went in the admin console to see the optional languages that we can choose , and i choose hebrew back then. BUT I DESELECTED  the language and save the changes. SO why is it throwing this error ?  i dont understand why it is blocking me to save the process that i built ?? what i need to do ?   Thank 

How to convert text to UTF-8? Do we have any function or plugin for this?

Convert current time to milliseconds. Ex. 1719220373569 (5:13 pm in China) Any idea, how we can achieve this in Appian? Any function or plugins?

Please tell me how to use "Create PDF". I would like to overwrite data on an existing PDF and create a new PDF. Therefore, I implemented the following processing. ・Copy Template PDF: Create a copy version of the base PDF and store it in "pv!copyTemplate" ・Edit PDF Name: Change the name of "pv!copyTemplate" ・Create PDF: Each parameter is set as below.Create New Document: falseExisting Document: pv!copyTemplatePause On Error: falseContents: (describe the contents as an expression) No values ​​are set for any parameters not listed above. This is the PDF to copy from.I have confirmed that the content is retained even after the "Edit PDF Name" process is completed. However, when the "Create PDF" process is finished and you check the contents of the same file, it looks like the following.The value set in the parameter "Contents" is listed, but the PDF that was supposed to be set in "Existing Document" is not reflected.

I am building a POC for leave management systems. Tables: Employee( holds employee details), Leave balance(holds leave balance and the leave type), Leave table( shows the type of leave and its maximum limit), and leave history(holds leave history of employees)  I am trying to check the leave balance for the employee with filter - logged in user and leave type . leave type is Integer. I get results of every leave type which is not my expectation. please help me fix this issue. I want only the leave balance for a particular type.  query o output:

I found multiple points raised on community regarding how to build workflows in Appian, almost at all place it's mentioned to prefer task based workflows. But i went through Appian success guides and feel both approach are well documented and in some places it's highlighted to build record centric design over task design. Wanted to know why record centric design should not be preferred in first place over task based workflow? Record Centric Applications or Task-based Applications (Modular Design with Sub-processes) are both documented approach of building the applications                    Information Source : https://community.appian.com/success/w/article/3048/how-to-create-memory-efficient-models Under Appian "Best Practices: Appian User Stories", Appian has highlighted issue with Process centric design          &ensp

Hi I have to create a document with dynamic grids, Is there a way to generate document with dynamic grids using any of smart services/Plugins available in Appian? Thanks R Gopala Krishna Raju

Hi guys, I have an integration in which we are sharing the user tasks in other system with a hyperlink in the ID, like this: I have the requirement of give them the way of open directly the UI which display the task (TASK FORM) once the link is clicked. In other frameworks sometimes we can use query parameters to customize the content being displayed, but I'm not sure how can we implement this, since appian use an encrypted value or generic value for task forms: Someone can guide me or knows how to open a task form directly? in this case from outside? NOTE: The users will be using SSO (OpenID) to login into our application. Thanks in advance.

Hi all, We are trying to find if there is a way to generate an Excel, using a!exportDataStoreEntityToExcel() or other functionality, and start the download automatically without the need to access the interface after a while to download the Excel manually thought a link. We want to generate the excel and then download it in one click. Has anyone tried this before or know how it can be achieved? Thanks in advance.

Hi Team,Is it possible to open a EML file from interface. I'm having requirement for sending reply email to the original email ,so my idea is to open the original email's eml file and send reply from that. Because I want to maintain the reply emails in the original thread. Is it possible or any work around to achieve this?Thanks.

I just want to understand what Appian Senior Developers can do so that I can have a better understanding of this role.

Hi Community, I using Import CSV to Database smart service to load data into a database staging table. and I am getting the below error. Can anyone please help?