General

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

Currently we have a site that has several pages at the top in the Header bar. However, one user is unable to see these pages unless they are in incognito mode indicating this is not a permissions issue on Appian's end but a chrome setting that must be hiding these tabs.  We tried opening the site in both chrome and edge and both fail to load the site pages. The whole Navigation bar shows up for that user including the Logo, we are just unable to see the site pages at the top. I am Creating a post to see if anyone knows of this issue and a potential fix?  Thank-you so much for your time. 

When we execute the API Endpoint to load the data in DB, we get Generic Error Message " 500 There was an error writing to the data store"  Is there a way to capture the Actual Error message and Return it as a message instead of the above? Example:  Details: javax.persistence.PersistenceException: org.hibernate.PropertyValueException: not-null property references a null or transient value Following is the code :onError: a!httpResponse(statusCode: 500,headers: {a!httpHeader(name: "Content-Type", value: "application/json")},body: a!toJson({error: "There was an error writing to the data store"}))

How to convert Unicode characters to emojis. Our process saves the emojis to Cloud DB as "utf8mb4_general_ci". I want to show them as emojis on the richTextFieldWithTables

Currently getting expression evaluation errors in a rule and without resolving the problem currently (no time to at this moment and no issue to client), I am wanting to reduce the number of alerts I receive a day. Like if it errors 10 times in a day, I don't want 10 emails, but one email with all the errors that occurred that day maybe? 

Hi, using local variable, i am calling expression rule, which gives category codes as output, now i neeed to convert this local!updatecategorycodes into array form to use contains() function. can anyone please help me local!updateCategoryCodes:index( rule!CNAM_qeGetUpdateCategoryCodes(), "CATEGORY_CODE", "" ),

I have a requirement to filter negative values from readonly  grid and It needs to get configured from expression rule but Im not able to filter the negative values. I tried using "<" as operator for that particular field but still not filtering out. please help me achieve this

All nodes and sub-processes are completed but this process instance somehow got cancelled, can anyone advise what could be the cause?

Hi team ,recently I have created a new account to learn Appian again, its a free version, in this I  am not  able CDT, DSE objects and also not able  to create them. Also not able to access the MySQL Database.

lets say im passing the id as 1 to 1000 range for example , as there is no document with that id it will show error right 

H, Does anyone know if there is multi-factor authentication via SMS to access an Appian site? Or are there only SAML authentications?

I need a custom record field, of which the value is the result of query, can we do any query in custom record field

We use a smart service called "Append Text to File" from the "Text File Utilities" plug-in. It seems to have stopped working since the latest release a few days ago. Are there any alternatives?

Hi Everyone, I have Appian with version 21.3 connecting to MS SQL DB FCI, i want to migrate the DB FCI to Always-on setup is that supported by Appian to work with MS SQL Always-on

Hi  I have a requirement where in I am creating a word document from a template using the DOCX From Dynamic Template smart service And then convert this word doc to a pdf doc using the PDF from DOCX smart service The thing is the first smart service works, i.e. I am able to successfully generate the word doc. But then when I feed this word doc to the next smartservice to convert to pdf I am getting this error: org.apache.xmlbeans.impl.values.XmlValueNotSupportedException: Could not get a Java numeric type from a Schema string type Can anyone help me with this ?

I have a write data node in process, input is: output is: Process detail showing pv!originalRecords has value, but the result of update() somehow not saved to pv!updatedRecords Can anyone advise what could be the cause?

For a list of integers, I need to check the desired value by calling a service. I would like to stop calling the service, only I get the desired output. Any suggestions, please. 

Need to enable certain dates to be selectable based on the logged in user. So the dates to be enabled and disabled for each user and it should be dynamic based on certain business rules. Is it possible to achieve this in Appian?

SELECT * FROM TABLE_A A JOIN TABLE_B B ON A.ID=B.A_ID WHERE B.ROLE IN ('ROLE1','ROLE2') and B.IS_ACTIVE=1 The relationship between A and B is one-to-many, two conditions should be matched in one row I tried to do { queryfilter(Conditon1), queryfilter(Condition2) } But it returned record A with two record B that match one of the conditions each

Hello: We desiged a case with an Intake form but the requirements changed  and the user does not want/need to perform  the Intake .  We deleted the generated form , but that produced an error at the auto-generated page: CMGT_CB_CreateCase_FormSelector But the application stop to work . As a workarround we included this line manually --> equals: "ae1509bc-9463-4120-b2b2-ec428c17decc", then: #"ae1509bc-9463-4120-b2b2-ec428c17decc"( data: ri!data ), This interface has a warning at the top:  -> DO NOT MANUALLY MODIFY THIS INTERFACE. In other hand , when we create the case , we have a blank aditional step after the submit ( related to the page that it does not exist yet).  What steps shoudl we do to avoid the inclusion of this sail code into the autogenerated page and clean al the the intake form. 

Hello, I have an interface which uses a record grid to display a document repository. My documents are stored in SharePoint but the record data contains the SharePoint File IDs, file names and other metadata (the documents are not stored on Appian as there will be hundreds of thousands of documents to store).From this Interface, I want to give the user the ability to view and download documents. In order to do this, I have gone down the route of using an a!startProcess when clicking on a button.  In this process, I am running a loop which iterates through the selected documents, brings the document back from SharePoint, and zips the document together. In the onSuccess parameter of the a!startProcess smart service, I pass the zipped document back to the interface. from there, the user can use a downloadDocument link to download the zip file. The issue I am facing is that in order for the zipped document to be brought back, I must activity chain my process, and when downloading

Hi All,  I wanted to ask if there's a way to determine the peak and average number of user logins during a specific time period. This information is needed to help scale the infrastructure in an on-premise environment. Thanks in advance

Hello folks, I am generating PDF file on click of button. The issue is the text output in the PDF converted a hyphen to a number symbol.  For eg: "year-end" to "year#end" This will only happen if I copy and paste text along with hyphen. Can someone suggest?

I have a group, group type is business group, now I no longer need this group. How can I deprecate/remove it. It has been deployed to higher env like prod. I need to remove it from all env

Hi, I need to have a document upload form like this package import form, and have a validate button like inspect button, but I need to disable the import button before the document is validated successfully. I need to validate the document's content and format, so it's not just a validation for the size and type How can I do?