Discussion Categories

Hello, I am trying to add pv! data to a task report but it always comes out empty.  My data definition is: pv!record[W1182 Solicitud.idCategoria] formatting: number  It does not display any information. All information I request using tp! works fine.  Am I doing it wrong? or is it not possible to display rv! info in the report? Thank you

I am new to appian  I need read excel data along with header which is dynamic it will change for excel to excel some fileds are static and insert them into a staging table both header and data for that column . my staging table contains fileds like attribute1, reason1, score1 till 20 . I want to insert headers to attriubute field from 1st row and reason and score to data from second row I am trying with readexcelsheet/readexcelwithfiter/readexcelwithpaging functions but since its dynamic i am having confusion how to do the mapping  Imp : Number of header column and name of the header column will be dynamic Can anyone help me how to do or is there any other approaches there ?

Hi All, I have an interesting use case where the client wishes to open a 'Task' within a 'Case'. For Context, we have a design where our Case has a one-to-many relationship with Tasks. We have a 'Tasks' View on the Case record which has a selectable a!gridField where the end user can select a Task from the grid. This populates a Task screen below with data and record actions for the selected Task. The client would like to navigate to the Case record -> Tasks View via both the a!recordLink() and a!urlForRecord() with the Task already pre-selected in the UI. The client is not willing to have the link navigate to a Task Record as they find it confusing and do not want the User to leave the top level Case Record. Is there any workaround I can use or is linking to a Task Record directly the only option available? Many Thanks for your time, Zac

Like to check whether the Encryption Functions plug-in compatible with Appian Portal or not. However, I don't see any document for this. Also, as per the documentation, we can see this compatibility in the plug-in summary. However, not able to find this. Can anyone please guide me?

Hello there, I am wondering if its possible to get my public ID using an appian function. Please Help!

I have inserted a new value in a database . (Scenario here is I have used a parent process to capture the values and sub process to write into the database.) Then again I update that particular value (Scenario here is I used different process to get all the updated values and used the same sub process to write it to the database). But the updated values are not getting reflected in the variables tab .It is showing the values that I used while inserting  but in Process history tab the values are updated properly. I have mapped the input tabs properly. Can anyone please help me with this scenario.

I'm developing a preexisting app with many deeply nested interfaces that render as the contents of several cardLayout components.  The contents displayed are dictated by a set of specific combination of Rule Inputs and Local Variables that is difficult and time consuming to reverse-engineer.  Is there a way that I can get the Rule Inputs and Local Variables of a component that I'm currently looking at as a user so that I can input it into the component in the editor view?  That way I can get the component to render in the editor as I'd see it as a user then work from there.

HI team, To learn adding External data sources as Connected System. i installed PostgreSQL locally in my system and host as localhost but when i try to conenct with localhost through connected system . I couldn't able to connect.

Hi,  We have text which has Apostrophe in it for  eg: Name with Apostrophe in it (Katie O'Mahony) . Since it is a XML field, We cant use it directly in XML field. Escape characters also not parsed in created document. Can you please help us in getting document generated with apostrophe in the text field.  And also let us know which escape tag needs to be used for Apostrophe insertion. Sample XML :<followerlist abc='xxx' name='Katie O'Mahony' /> We have tried replacing with escape characters like '    $#34

Provide suggestions to connect Appian with Sonic s3 bucket to upload/download documents without using plugin. 

How long the appian JDBC keeps the database connection alive? and How long it will be cached ?  Is the caching happens for every Data source defined in tomcatresource.xml file?

Is there any to find the size of the data that is returned by a query?? The default size limit is 1MB, but we want to understand how much rows we can pull from database without reaching this limit.

Hi there, I have a scenario where i need to change the display name of a record field value. Is it possible to do that while configuring 'Reporting Record Types' ? ex. my record filed has the value 'SME' but i need to display it as 'Subject Matter Expert' (there is no related table to fetch the expanded value) on the frontend while we display the report. Is it doable in EUR? Thanks in Advance!

Hi, I have a read-only grid that displays real-time data, populated through a local variable from an API. Users have requested an "Export to Excel" button. Is it possible to enable this functionality without storing the data in a database table?

Hii, In my case i have to edit the multiple Dropdown field value: My value is Record type. Eg: [ "Product 1,Product 2"] Choice value  is Array. Eg: ["Product 1","Product 2","Product 3"] the value from my record type is like  :  "Product 1,Product 2". So, value is not matching with choice value. How to resolve this, I tried converting the value to list of text using split but still it is not working.

Hello,  I'm trying to figure out how to integrate an external web site with Appian. I have a JAVA war file that contains JavaScript files. The war was produced by another organization, and I expect to have occasional updates. I have the war hosted and running on its own server. What I would like to do is push a button on an Appian form that launches the web page created in the war. The user then selects different options in the popup and hits submit. The external web site produces an XML string and sends it back to Appian. Appian then displays the processed XML on the form. Later, when the Appian form is completed and submitted, Appian saves the XML to the DB. I've tried using Web Content Field. It displays the button and launches the external web page. I have no idea how to send the XML back to Appian. Web Content Fields don't retrieve data as far as I can tell. I also thought about setting up an Appian Web API for the external site to call and send the data

Is it advisable to do the following on a task script node? It hasn't given me any problems so far. Suppose I have two variables pv!variable1 and pv!variable 2 In my first custom output I have 1+1 saved in my pv!variable1and in my second output I have pv!variable1 + 5 saved in my pv!variable2 . When using the two variables in my outputs, could there be a problem that it does not finish saving or executing correctly?, assuming that it could be a more complex rule, or a query in my first output. My specific question is whether these outputs are executed in sequence, always waiting for the first one for the second to begin.Is there any certainty about the order of execution of the inputs and outputs of a script task?

I want to publish all process models using a single user. Is there an efficient way to publish all of them at once, rather than publishing each one individually?

Hello! I'm getting this error while setting up my integration. I have a couple of integrations in my application that allows users to archive and download documents from a SharePoint and they both use the same connected system that I have in this one. The one I'm showing is for my own testing purposes. I'm using this integration to see if I can retrieve any folder metadata but I keep getting this error. The connected system says it's connected and I'm using Entra ID. My question is am I doing something wrong here or does it look like I have everything set up correctly? Trying to find out if there's something missing on the Appian side of things or if there's something missing on the Azure side.

for a particular record type object getting following error message : Expression evaluation error [evaluation ID = HGT9M] : Could not find driver for MariaDB.since we are using mysql but getting error on MariaDB

Hi, I am using bigint for storing codes, account numbers(as they can go upto 15-20 digits) in SQL. I need to use them in Appian. Is there a way to map tis data?

Hi All,              I'm trying to send email using Appian after submission of a process to either users or functional mailbox based upon the requirement conditions. When email sent to users it is received by the users correctly, whereas when email sent to functional mailbox address there is no error in the send email node but email didn't get received by the functional mailbox. So, request your suggestion on what's the reason for this behavior and how to fix it? Note: i have used toemailaddress function in the To address field of email node configuration. Thanks in Advance, Pradeep.B

Hello, I just started creating the SPX Launch Tracker app and when attempting to create the HTTP Connected System, I enter the name as instructed in the Step 2 of the Build a Low-Code App course, but it the error comes up saying "Name Already Exists". I am unsure when or how the name already exists even the app creation has just started. The SPX Connected System Image is not also coming up.  Any advice is appreciated

HI All , I have ModifiedDt stored in MSSQL Server with DateTime format , when i query the same Date in Appian it shows a slight difference in millisecond . I am guessing Appian round's off this value ? Is this correct ? Does anybody else observed this issue ? Examples below - Database Appian

can we make one user filter dependent on other. For example if we select category user filter then only corresponding sub category values should be shown in sub category user filter.