Discussion Categories

I am trying to understand when the appian save data type should be used, reading the documentation I do not see a clear example of use. Can someone tell me if they use it and when? This is the associated documentation https://docs.appian.com/suite/help/24.4/using_interfaces_in_appian.html#creating-reusable-custom-components docs.appian.com/.../Appian_Data_Types.html

Hi Team, I am trying to setup the RPA , and the agent icon colour appears GRAY and in the logs I am getting "java.net.UnknownHostException" Can anyone please suggest. Thanks

i have this query to run in database table to export some data,but its throwing an error like this: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 0, 25' at line 45 below is the query: SELECT DISTINCT ITS_MATTER_NUMBER, REQUEST_DATE, REQUEST_TYPE, REQUEST_STATUS, CUSTODIAN_NAME, CUSTODIAN_WWID, JNJ_MATTER_NAME, JNJ_MATTER_NUMBER, COLLECTION_VENDOR, RECEIVER FROM ( SELECT DISTINCT ITS_MATTER_NO AS ITS_MATTER_NUMBER, TO_CHAR(CREATE_DATE,'MM/DD/YYYY') AS REQUEST_DATE, REQUEST_TYPE, CFA_DM_ED_REQUEST_HDR.STATUS AS REQUEST_STATUS, CUSTODIAN_NAME, CUSTODIAN_WWID, JNJ_MATTER_NAME, JNJ_MATTER_NO AS JNJ_MATTER_NUMBER, CFA_DM_ED_COLL_VENDOR.COMPANY AS COLLECTION_VENDOR, CFA_DM_ED_PROD_RECEIVER.COMPANY AS RECEIVER FROM CFA_DM_ED_REQUEST_HDR LEFT OUTER JOIN CFA_DM_ED_PROD_RECEIVER ON CFA_DM_ED_REQUEST_HDR.REQUEST_ID = CFA_DM_ED_PROD_RECEIVER.REQUEST_ID_FK LEFT OUTER JOIN CFA_DM_ED_COL

I have requirement to show a specific page of a document in the document viewer component. Is there a way in Appian to achieve this?

Appian Community Team, I have a Site which 5 Interfaces in it. Please see below screenshot for reference. If I want to add KPI, where should I add it? Is it to all individual interfaces or should that be added onto the Site Page? If its on the Site page, can you guide me here please. I am new to Appian and I am open for suggestions here. Regards, Mahesh

I would like to know if it is possible to add a plugin to the Appian Community Edition.If it is, could you please guide me on how to import a plugin into the Appian Community Edition environment?

Appian Community Team, On the Appian Home Page, I see Reports in the Menu. Can you please fill me in with details on what that is for? How I can have some of my Site Reports appear under Home Page Reports Section? I am new to Appian, I have developed a Report in Interface using PieChartField, can I have that Interface appear under Home Page Reports Section? I have provided screenshot for what I am referring to on the Home Page. Regards, Mahesh

I have 3 records having one to many relationship  Timesheet(ID,IS_ACTIVE), Audit(ID,TIMESHEET_ID,IS_ACTIVE) and Comments(ID,AUDIT_ID,TIMESHEET_ID). When I tried to use single write records smart service, I am not able to populate value for TIMESHEET_ID column value in "Comments" table. Is it expected or do we have any other way to handle this?

Hi All,Please help me setup process model to update the value of few fields of table through pm: 1. I have to update the value of is Read by clicking on envelope icon from false to true and vice versa and update read on as well  2. similarly by clicking on star icon I want to update value of is archive from false to true and vice versa  3. similarly by clicking on cross icon I want to update the value of is delete from false to true and vice versa and update deletedon and deleted by as wellPlease help me achieve  this, Thanks

I conducted a test where I copied a tab character from Notepad and pasted it into an Appian text field. Appian recognizes the tab character as a special character rather than treating it as empty spaces. How can I configure or validate this so that Appian treats tab characters as empty spaces? Any insight would be appreciated.

While looking into the Dependents and precedents we found out that the issue was due to USER record type which is available by default in all environments. Has anyone faced similar scenario and how to work around it to successfully deploy the application from DEV to TEST ? FYI: 1. we have updated the instance version to latest release and also updated the User Record Type to latest version. 2. The missing precedent is the User record type fin the SS.

I have got a input string like "[key1:value1,key2:value2]", how to get the value by key?

I am currently working on integrating Appian with an external system by exposing Appian RecordType data through a Web API. However, I am running into an issue because the Community Edition does not provide access to the Admin Console, and without access, I cannot generate an API key needed for authenticating my API requests.Is there any way to achieve this ?

I'm having an issue where the browser data loss popup shows up when I click on a a!safelink from a form. The link is configured to open a mailto window in a new tab, so no data loss should be occurring. I'm wondering if there is a way to disable this popup somehow, my assumption is no, but I wanted to check here and see if anyone had any suggestions.

Hi Everyone, I would like to add the rich text for the headers of the a!gridlayout. Can you suggest some approaches on how to achieve this? attaching the snip.

in dropdown i have to show default values then it has only single value if dropdown has multiple choices i can show then value will be null ex: here detail has many values this i have to show as it is no change in this  this dropdown has single option so need to show that by default 

When I upload my files, they disappear!!! [View:/cfs-file/__key/communityserver-discussions-components-files/62/Uploaded-Files-Disappear.mp4:320:240] Here is the code: a!fileUploadField( label: "Please upload any pictures, brochures or other documents describing the Project", labelPosition: "ABOVE", target: cons!PMSO_ApplicationDocuments, value: ri!volunteerDocuments, saveInto: ri!volunteerDocuments, showWhen: if( a!isNullOrEmpty( local!applicationDocSubmissionSuccessful ), true, not( local!applicationDocSubmissionSuccessful ) ), validations: {} ), I checked to make sure th

Hi Team, I have a requirement , where I need to find the time difference between two date times. I am facing one issue, I have to find the difference in EST timing, day start should be at 8 am and day ending will be on 8pm. when I am using callworkminutesplugin() function, it is not giving proper result as when it was converting time to EST it is giving diffirennt result in expression. Please help in getting the minutes difference in 2 date times.the above time is returning fn!datetime(2025, 1, 7, 10, 21, 35, 230) in expression. Why is this so?[mention:b8ea18cfbb2e4f6d841cf3c1d4d7420b:e9ed411860ed4f2ba0265705b8793d05]  [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05]  [mention:2df2892a4df7486f9775b4d2f0e405fd:e9ed411860ed4f2ba0265705b8793d05]  [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05]  [mention:dea33493db6342c9a73dc108d45120c0:e9ed411860ed4f2ba0265705b8793d05]  @mathieud0001

Hi All, I have a paragraph field (* Required field) in an interface. When I input Enters or Spaces or Tabs only and no other characters it is consider as a value and not firing the validation error. For user it looks like empty values and validation didn't fired. Need a validation so that Enters or Spaces or Tabs only are not considered as va[lues. a!paragraphField( ..... validations: ??? ...... )

This is the code i wrote my requirement is to im fetching the data's from DB  lets say i have 11 data in total , i need it in a dynamic column in gridField like (no of col can be : 2,4,6) local!data : DB datas, local!noOfCol : (3,4,5) -> any number (const), so based on the col number the total number of data have to be grouped and run in the loop in a gridField using GridColumn i need to run the loop  the data should be look like this in the ICON wise.it is done in Columns layoutexpample local!a : { {1,2,3,4} ,{5,6,7,8},{9,0}}, output in gridColumn in Left to Right1 2 3 4 5 6 7 8 9 0 null nullCode a!localVariables( local!data: rule!LH_QRC_getLookupDetailsByFilters(categoryList: "ICON"), local!noOfCol: 4, local!groupedData: a!forEach( items: enumerate( ceiling(count(local!data) / local!noOfCol) ), expression: index( local!data, enumerate(4) + (((fv!index - 1) * 4) + 1), null ) ), a!gridField( data: local!groupedData, columns: a!forEach( items:

1) Which log file is used to view users' activity like password Chage, user type change, reactivate/deactive, username change? 2) Which log file to view the process failure in detail? 3) Log file to view the user login audit? 4) Log file to give details about slow queries?

i have 2 drop down. 2nd drop down is dependent on 1st value  so i have to show default value in second one once the user select value in first dropdown when i has only one option in second dropdown   this value i have to default once the value is deleted in first dropdown

Process HQ is a new workspace where business users can gain unprecedented visibility into their enterprise data and processes. Combining the latest technologies in data fabric, process mining, machine learning, and generative AI, Process HQ gives users the power to explore data and identify timely insights they can use to optimize their business.  Developers and data stewards should explore our Set Up Process HQ learning path, where you’ll learn to: Ensure the data used in Process HQ meets the requirements and follows best practices for data acquisition, enrichment, and security. Follow the guided experience of adding and configuring a process in Process HQ. Analysts, executives, and other business users should explore our Analyze Processes and Data learning path, where you’ll learn to: Explore data sets across the enterprise, build custom reports and dashboards, and obtain answers to common business questions using AI Copilot. Learn the value of strategically usi

Hi , I have one scenario that where  if the value is not 0 and the values should not round off and it should accept up to 9 decimals like 3.612232423.   Minimum Rate: 3.5 Maximum Rate: 4   input value is of number(dec) format i mean CDT has this data type, how can we achieve this if user enters any values apart from the scenario mentioned above should not except.   Thanks in advance.

In 2nd Db, values are not getting updated ,it is throwing error as rank inputs . only values are getting updated in 1st DB , 2nd table has foreign key relation with 1st table