New to Appian

Hi, I have a quite few files in a shared network path and I will get the files based on some intervals. I would like to pick the each and every file based on certain code which will be there in the file name and send as an attachment in to the email. Is this possible using Appian. Any quick advises please. Thanks in advance.

Hi Team Can we trigger a process model from 9 AM and 9 PM. Usually, we add timers to trigger at that particular time.

Hi All, There is any idea or any operation through which we can rename folder name in google  drive. In my project i have a requirement where i need to create a process model which will Re-name the folder.  Because in Google drive we have operation like-  Upload File Create Folder Create Google Doc List Folder Contents Query Drive Copy File Download File Manage File Location Find File There is no any option for modifying folder name  please suggest.

Hi, In the System Logs we can able to see the different csv files and where these csv files will be stored and how much time the system will take to create those files ? Appreciate your help!!

How can I use SUPPORT and APPMARKET for my Appian problems. what type of problems discussed here

i have an error . How I solved it. error:- Expression evaluation error at function 'cdtdifference' : one or both CDT passed are null

Q1.. how i add plugin ? Q2. when I add plugin It is in Appian Designer not come in my personal application.  How I bring it in my appian application plugins added here in Appian Designer:---- It is not in my application:--- How should I bring them in my application so that I can use it.......

Hi All, , I am using the export dse to excel smart service. One column in db having decimal values but when exported to template it Removes the decimal part. Although I have formatted the column to number decimal in the template but it is not working. Can anyone please suggest some solution. Many Thanks!

HI all,  We have recently added new columns to the existing view ,and in the data type of that view we have added new columns through xsd. Then in the data store also we can see that the entity are mapped.But coming to the record type where we used that view .it is throwing the error that source is not available,even we have checked to select the view again we are not able to see that view in the record type. Could you please help us?

Hi Everyone, I am retrieving column data from db using a!queryselection but need to truncate the values for some columns. Can anyone please help me out, how to achieve this? Many Thanks!

Hi Everyone, I need to extract first four digits and last four digits from the given string. Like string is "sgdh567895dgh6787" then first four digits would be 5678 and last four are 6787.  Can anyone please help me out? Many Thanks!

Hi, The slow query the threshold default value is 3 seconds. So to increase that limit we need to update the custom.properties file in Appian. where the file Physically exists? In Appian Doc's they mentioned path as <APPIAN_HOME>/conf/ I didn't found the file anywhere! 

I created a test user , he is part of LMS Engineers group  When I ran this query, it shows true. I am trying to hide a page or component based on this result. Any help is appreciated a!isUserMemberOfGroup( username: "LMSTestUser", groups: {"LMS Managing Director","LMS Managers"}, matchAllGroups:true )

Hi am getting this error in site am not getting what's the issue

Hi, I would like to setup a timer to a process model which should trigger only on a particular day like Friday and at the same time, I would like to set up to trigger the process model after from a specific date.(example, Aug/10). Can someone advise and let me know if this is possible.

Hi, Can someone tell me whether Appian's system logs have any dependency over the performance of Appian - will it slow down the process, will transferring or clearing the logs impact on the performance of Appian ?

Hi Team, how to change the value of "abc@gmail.com" to "xyz@gmail.com"? Thank you

https://api.spacexdata.com/v4 is not working . Can you please provide another link which I can use for testing.

Appian's Rich Text component doesn't seem to render or handle extended ASCII char very well. In the above example we can see the same text rendered. Ideally we would like to display these text in a mono spaced manner. In addition to mono space issue; there also appears to be a vertical spacing issue. Is there a way to configure a rich text component so it complies with ASCII extended chars better?

Hi All, Please help me on this error a!localVariables( local!listOfAmendments: if({ index( index( rule!ISR_er_PopulateAmendmentsInExecuteMeetingDataSubset(meetingId: ri!meetingId), "data", {} ), "amdId", {} ) = index(rule!ISR_qry_GetISRAmendmentPrimaryReviewers( meetingId: ri!meetingId, primaryReviewer: ri!primaryReviewer, isActive: true ),"amdId",{}) },rule!ISR_er_PopulateAmendmentsInExecuteMeetingDataSubset(meetingId: ri!meetingId ),{}), /*(Amendment Number, Amendment Reason, Proposal Reference Number, */ /*Study Title, Primary Investigator, Medical Scientist/Proposal Champion (from GIL-134), */ /*Currency, Budget, Slides (Slide for the Amendment) (GIL-263))*/ local!tableAmendmentGridStart: " Amendments to be Reviewed: TA Ref # PI Country Study Category ", local!tableAmendmentGridEnd: " ", local!amendmentsGrid: a!forEach( items: local!listOfAmendments,

Hi Team, I'm facing a cascading problem when performing manual deployment. The processModel [id= uuid=...] was not imported because a required precedent is missing: content [uuid=_... location=Process Model Expressions (Rules)] cannot be found. (APNX-1-4070-001) (APNX-1-4071-006) The linkage is like, processmodel has a process start form interface and that interface calls other interface. All the precedents were added to the package, still facing this issue.

Hi All,  last part of Developer course is optional. I wonder how it may affect final exam?

Hi all , Can we update view by adding functionality of group_concat to a field .If yes, Can you please instruct me how to do? CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `ISR_v_MeetingProposals` AS SELECT `mjs`.`meetingId` AS `MeetingId`, `mjs`.`studyRequestId` AS `StudyRequestId`, `mjs`.`sortOrder` AS `SortOrder`, `sr`.`referenceNumber` AS `ReferenceNumber`, `sr`.`studyTitle` AS `StudyTitle`, (select group_concat(distinct `ta`.`name` separator ';') from `ISR_TherapeuticArea` `ta` where `ta`.`therapeuticAreaId` in (select `srt`.`taId` from `ISR_j_StudyRequest_TherapeuticArea` `srt` where `srt`.`studyRequestId` = `sr`.`studyRequestId`)) AS `TherapeuticArea`, `c`.`name` AS `countryName`, `c`.`code` AS `countryCode`, `cc`.`code` AS `currencyCode`, `ss`.`totalAmountRequested` AS `totalAmountRequested`, `ss`.`convertedTotalAmtRqsted` AS `convertedTotalAmtRqsted`, concat(`srp`.`firstName`,' ',`srp`.`lastName`) AS `PrimaryInvestigator`, `sr`.`medicalScientist` AS `medicalScient

Hi All, I am using  stored procedures for my grid.If I update the values in the task those updated values are not coming in the stored procedures still it is showing old values.How can I get updated values of task in store procedures

Receiving the following error on the Interface I am working on.: "Expression evaluation error: Syntax error. Details: Expression evaluation error at function a!columnsLayout parameter 1 [line 285]: Keyword and non-keyword arguments must not be mixed. Used in: columnlayout." Code mentioned is as follows: