New to Appian

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:

My site is not working and it shows this below message. what should I do for reactivate my site. Message:---------- My Community Edition Site:- "When your environment is available, you will receive an email with your credentials. Return here to check on your request status."

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:

When creating a new record with a user field, I want the field the field to initially be set to the current logged in user.  I need to be able to clear that field and select a different user if applicable.  In all of the functional variations I've tried, I can set a default value, but it will not allow me to change the selection.  If I click the X to clear the selection, it just repopulates with the logged-in user.  I've tried variations of the following: a!pickerFieldUsers( label: "User", labelPosition: "ABOVE", maxSelections: 1, value: if ( isnull(ri!record['recordType!{...}BWTA Event.fields.{...}user']), loggedInUser(), ri!record['recordType!{...}BWTA Event.fields.{...}user'] ), saveInto: ri!record['recordType!{...}BWTA Event.fields.{...}user'], required: true, validations: {} ), I've reviewed many discussion threads, but either my available options do not match or they do not pertain to the create action.   I review

Hi All for the attached code it is showing the error attached. The attached code will saved into "Country " variable  Of type textCould you please help merule!ISR_er_displayCountryNameById( countryId: index( rule!ISR_qry_GetAddressInfo( type: cons!ISR_REF_CODE_ADDRESS_TYPE_PRIMARY_RESEARCHER, typeId: index( rule!ISR_qry_GetPersonDetailsbyStudyRequestId( studyRequestId: pv!studyRequest.studyRequestId, ).data, "studyPnId", null ) ).data, "countryId", {} ) )

In the expression rule, we can see 3 output values (Formated, Raw, Expression). When I am processing a text with white spaces it is show the text without extra spaces. When I check the same in Raw I can see that extra space. I want to get exact text which I am getting instead of formatted one. Raw output : 

I would like to know how to create a new Lower environments like Dev, Test or UAT from Appian PROD environment?

Hello, How can I remove the 'X' close button of the dialog. When creating a record action, the dialog doesn't has a 'X' close button.  The dialog made by record action has 'X' close button by default. Is there a way that I can remove this? When I close the screen, I want to make sure that a specific function is executed in the process. for thatIt seems to be necessary to close the screen only through the close or cancel button, not the 'x' button. Thank you.

Hi Team, How can identify the users that have created the accounts recently or per month on Appian.