General

Hi, I am very excited to announce the release of my book "Low-Code Application Development with Appian". It will be available at the end of April and I can't wait to get your feedback. Meet me at Appian World Miami on Tuesday afternoon in the Community Hub to discuss all things Appian, low-code, and business process automation. I have a few discount codes I'd like to share with the you. Find the book at Amazon: https://www.amazon.com/dp-B09SZ5V53W/dp/B09SZ5V53W Happy low-coding, Stefan.

Hi All, before two days ago, Appian server crashed and we were not able to access it, how can I know what is the problem? Thanks.

How might I get the number of seconds between NOW() and a date in the database? I checked various other resources like this But was not fully satisfied with whether what I was doing is correct or not. Can someone Guide me? Much appreciated.

I'm trying to export SQL data to excel, but I'm facing an issue.  An error occurred in executing an Activity Class. can somebody assist with where information I'm going wrong Much obliged!!

Does anyone know there are any vulnerability reports of appian？We want to use Appian, but our company's security team want to have this report to prove the security of Appian.

Hi can someone suggest me with the UI design for the below grid  so the first row contract number- if the user change that number based on that number below grid data has to be populated how can i achieve this? where can i configure remove button for this grid so that this complete grid will be removed but will be having multiple grids one after the other with different data based on the contract number  if not this can suggest for how can we removed that contract no data

a!localVariables( local!oldCdt: rule!ITS_GetPQRRequestByPqrRequestId(pqrRequestId: 71), local!newCdt: rule!ITS_GetPQRRequestByPqrRequestId(pqrRequestId: 80), local!fields: split( stripwith( tostring( 'type!{urn:com:appian:types:ITS}ITS_PQR_REQUEST_DETAILS'() ), "[= " ), "," ), tostring( a!flatten( a!forEach( items: local!fields, expression: { if( exact( if( isnull(local!oldCdt[fv!item]), "", local!oldCdt[fv!item] ), if( isnull(local!newCdt[fv!item]), "", local!newCdt[fv!item] ) ), {}, fv!item & ": " & local!newCdt[fv!item] ) } ) ) ) ),

Hey, Guys where I can find the SQL database for my Practice Test?

Hi, I wanna check type file. How to check type file? Thanks,

I'm getting 5 field values from CDT Aand  other 5 field values from another CDT BI need to save both 10 field values from (CDT A and CDT B) in CDT C. How can I Configure this Process model?

a!queryFilter( field: "completiondate", operator: "between", value: {today() - weekday(today(), 2) + 1, today()} ) }, ignoreFiltersWithEmptyValues: true ), Need clarification For value : ( 4 th line ) 

is there any way to find group Name by UUID? (tried get contentdetailsbyUUID) nothing worked...

Hi  my requirements is i have 2 grids one after the other when i add a row in the first grid i have to get one row automatically in the 2nd grid [second grid will be user input grid] can anyone help me on this 

I have a requirement to get the top 3 documents list which are larger in size in a KC. I was a able to get the complete list with getfileslargerthansize() but doesn't know how to get top 3 documents onlly. Can anyone please help. Thanks in Advance

Hello I have a requirement to read a .txt file contents in Appian. We are getting this file via SFTP and this file has some Chinese characters. I tried using readlinesfromtextfile function which is part of Text File Function plugin. This works well for all data except the data/ text in Chinese. My sample data is 肖恩 and when I read it in Appian using readlinesfromtextfile I get ?? in place of these Chinese characters. I have enabled Chinese language from admin console. Anyone has any idea about this or any other way to read Chinese text from .txt file?   

I have created a report from an Interface.  I want to use that report as the Email Body.  Is this possible?

Hi All, I have one xml file  <xs:employees>  <xs:employee xs:employeeId="EMP001" >     <employeeData>      some fields  </employeeData> </xs:employee> </xs:employee> I am able to read fields for employeeData . Facing issue to read employeeId.  Any suggestion would be appreciated.

I have requirement to get the no of documents created last day/yesterday in KC. We have a function to get the number of documents present in KC :  knowledgecenter(ri!folderId,"numberOfDocuments") Can anyone please how to approach. Thanks in advance

 Hello all, I want to create a column chart like the image below, any suggestions? Does stacking is possible for this chart? How can I have two counts in each column and qt1 should contains 4 columns   Stacking should be like this, but I want charts like the previous one...Qt1 should have 4 columns

Hi, I want to extract text from a pdf page by page, paragraph wise, which includes different headings and related contents. Then I want to store them in DB which includes two columns one is heading column and other is content column. I used getpdftext function initially, then extract function to extract the desire contents, but did not get the expected result as the heading words are also present inside contents.Anybody please help me out?

Hi, Need your suggestion. I need to prepare a report with All Knowledge centre in the environment with their size. I'm currently doing manually by selecting each KC and copying the size from properties. Is there a content function to list all these details. Thanks in Advance

Hello, I need to click on a card that has a safe link, no label. I've tried: click on button, click on card, click on link. Does anyone know any possible solution?

Hello, I need to store a text in a variable. The text is inside a paragraph which is inside some columns and which is inside a card. The text and card have no label. Thanks in advance.

In My Practice Application, I have an accounts table that contains the details of the account holder like the name, balance, etc. Here, I am writing a stored procedure to transfer an amount from one account to another account           in the Transfer Amount stored procedure, 2 steps need to be included in a transaction,                              1)  subtracting amount from the sender account.                             2) Adding amount to the receiver account 

Hello community, that is the error- An error occurred while trying to write to the entity "LMS_Approval_Details" [id=df9f2bb8-8169-4985-987e-21a22f970163@4662, type=LMS_Approval_Details (id=3874)] (data store: LMS Data Store). Details: org.hibernate.PropertyValueException: not-null property references a null or transient value: LMSApprovalDetailsDT7163.customerId Data: TypedValue[it=3874,v={<null>,<null>,,,Approve,,,}] Thanks in advance