Discussion Categories

I have a readonly grid with a record as a source. This record Lets say "Main Record" is having a relation ship with other record - "Related Record". Grid has fields from both records. When Applying filters I want to avoid getting records from "Related Record" which are not active. Lets take below sample data of "Related Record". Relationship is one to Many. ID_MainRecord Division Is Active 1 Sports 0 1 Study 1 I have applied filter as  a!queryFilter( field:Main Record.Related Record.Division Operator: = Value: "Sports" ), a!queryFilter( field:Main Record.Related Record.isActive Operator: = Value: true ) Still I am getting one record in Grid I am expecting no records at all. And the record I am getting is having "Study" in division grid field. How can I get it work.  Some how how the first filter is not working as "Sports is there in the relationship field I guess. Thanks in advance for your atten

Hi All, I have my expression rule as below and I'm trying to get 100 records in 1 batch to pass to the process model. Now I need to fetch the 1st row from this rule output into a process model - perform some action and then loop back to fetch the second row - perform some action, loop back third record to fetch 3rd row and so on until I reach my 100th record. Please advise what expression do I need to write here to fetch the rows and loop back? Rule:a!localVariables(local!getData: a!queryEntity_22r2( entity: cons!SAC_ENTITY_CLIENTCASES, fetchTotalCount: true, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { ), a!queryFilter( field: "docsSent", operator: "is null" ) } ), selection: a!querySelection( columns: { a!queryColumn(field: "caseId"),a!queryColumn(field: "caseStatus"), a!queryColumn(field: "clientName"), a!queryColumn(field: "folderId") } ), pagingInfo: if( rule!APN_i

Hi I am trying something like this , I have editable grid for which data will be populated from local!data of type AB recordtype , I want to edit the row data and select them and save into another recordtype thorugh a rule input , I want to add new row also but when i try the rule input is getting updated but the grid row is not created and when i try to edit the pouplated data its not getting saved. I know im missing something I am a  beginner so can anyone guide me achive my requirement?  a!localVariables( local!datatype: a!queryRecordType( recordType: { 'recordType!{479ce76d-f462-432e-80f8-34a12cfb2725}RPM Candidate', }, fields: { 'recordType!{479ce76d-f462-432e-80f8-34a12cfb2725}RPM Candidate.fields.{6f148197-c427-48b6-a52c-0f8c403c81e2}id', }, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 100) ), a!sectionLayout( label: "", contents: { a!gridLayout( label: "Editable Grid",

Hi Team! I have a requirement and would like to know if anyone has faced a similar situation or has suggestions on how to approach it. Scenario:I have an interface where the user can dynamically add N sections. Each section has a unique ID (provided by the user) and a fixed set of fields (the same for all sections), but with different data. Example: The user adds 2 sections: ID 1 and ID 2. Each section contains the same fields (e.g., name, date, value), but with different values. At the end, I need to generate a dynamic PDF document that reflects exactly those sections and their data. Requirement:The generated document should include one section per user entry, with the corresponding data mapped correctly. If the user adds 5 sections, the document should have 5 blocks with the respective data. My question:What would be the best approach to generate this kind of dynamic document in Appian? Is it possible to do this using Document Generation? Do I ne

Hi All, I have a use case where I'm querying data from database table of 100 records set in paging Info. Now, Once I pass this data from my rule to process model, I need to extract the records one by one, perform some action on them and write to DB and then loop back again in the same process model to fetch the 2nd row data and repeat this in batches. My question is how do I fetch the data from a batch of 100 records and to get only one row and then 2nd row and so on without using an MNI? Please advise. 

= getdistinctusers(topeople(cons!IP_GRP_ALERTS)), a!queryRecordType( recordType: 'recordType!{3a27d5e6-31ce-4fe1-995f-821c7e573c8a}IP Add Details.fields.{7340349a-5cf6-4b92-a093-9d1d261d7be2}candidateMail', fields: 'recordType!{3a27d5e6-31ce-4fe1-995f-821c7e573c8a}IP Add Details.fields.{7340349a-5cf6-4b92-a093-9d1d261d7be2}candidateMail', filters: a!queryFilter( field: 'recordType!{3a27d5e6-31ce-4fe1-995f-821c7e573c8a}IP Add Details.fields.{7340349a-5cf6-4b92-a093-9d1d261d7be2}candidateMail', operator: "=", value: true ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500) ).data I am using the send email smart service and i used the "topeople" function to send the email to the group members first and then again i used the "user()" function to return a specific info from a field. Is this the correct way ?

What is the difference between process model with End Node and process model with End Node and Terminate Process?

We are trying to download documents from s3 inside the interfaces using getpresignedurlfors3 functions, we are able to download almost all other type of documents except we have identified that when we are trying to download pdf docs we are getting error- Failed to load PDF document.(PFA the screenshot).Fyi we are using chrome.Please advise what should be the fix for the issue..

Hello Team, Our Appian platform is on Cloud. Does anyone know how to download the Identity provider metadata file that has configured for SAML Authentication?  We want to update the saml end points for the certificate renewal. Thanks, Ramesh

Hi All, Since last week i am facing Appian slowness issue, for me all Appian environments are slow but working perfectly for other users. Tried opening in other browsers / Incognito mode cleared cache and other browsers settings but still facing same issue

Unable to see "create new data type (CDT) in community edition . Is it removed permanently .

  (Please ignore the text in the to field it was just somethings i was trying which is unrelated to the doubt i have asked below) So, as shown in the above image i am using a send email smart service. And in the to field, whenever i mention a specific user email its sending them the email without any issue, but when i choose a group its not. I don't get an email at all when i place a group in the to field. Can anyone help me what i'm supposed to do in such cases.Thanks and regards.

Hi, I have created a Robotic Task and I am able to save data from some attributes in variables of Robotic Task. I have created a process model and called "Execute Robotic Task" smart service to run this task. I want to get this output variables from my robotic task in my process model variables. How to do that?

Hi Everyone! I am facing an issue in microsoftDocumentEditorField(). Issue: The excel is loading for so long. It has two columns and two rows. Code:  microsoftDocumentEditorField( tokenInfo: generatemicrosoftdocumenteditortoken( viewMode: "View", document: 202370 )) Note: I tried using the Id/constant containing document for Document Parameter.

Has anyone successfully used the Mastercom connected system to support a full claim lifecycle?[mention:005befc4f9474f6c888fcbc1f908efa9:f7d226abd59f475c9d224a79e3f0ec07]I've noticed that the ability to create an update the initial claim needed to submit a chargeback isn't included. Wondering if anyone else has had the same issue and was able to get around it? Since Mastercom uses OAuth 1 I was hoping to be able to use this connected system to facilitate getting around Appian's lack of Oauth 1 capabilities.

Hello, We are receiving a response via an Appian Integration Object, but the Korean characters in the response appear to be garbled or broken. According to the API provider, the response is encoded in UTF-8, and Appian also uses UTF-8 as the default charset. However, the Korean text is not displaying correctly. Could you please advise what might be causing this issue and how we can resolve it? Thank you.

IN Date Range User Filter  I have to restrict user not to select any Future date in To Date 

I would like to suggest a feature that allows the reuse of a package across different environments such as DEV, TEST, and PROD. So, whenever I create a package named "MY PACKAGE" in DEV and deploy it to TEST, I would like to be able to select this package in TEST as well (as it is already imported), and then deploy it to PROD with a few clicks Currently, I have to recreate the same package in TEST, because there is no other option to deal with it. At least, I haven't found it yet. Does anyone have any hint on this? Thanks in advance.

How can we achieve a field level audit . Can someone suggest step by step .

This error popped up when i was trying some things in the interface, now i'm stuck with this error i don't know what this error means, can anyone help me understand about this error.

So as you can see in the above pic i have 2 different fields and for both the fields i have used multiple dropdown option and i have used the same functions for them. But unfortunately, the multiple dropdown is working only for the status field and not working for the commitment field. i.e, when i try to select more than one option in the multiple dropdown field, it shows an error. . . . . "Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!wizardLayout [line 3]: A multiple dropdown component [label="Commitment"] has an invalid value for "value". All selected values must be present in the choiceValues array, but value was Career Growth and Learning; Work-Life Balance and choiceValues was Career Growth and Learning; Work-Life Balance; Environment Sustainability." . . . . Can anyone help me out with where i did the mistake.

can anyone help me. i have checked the process variables those all are correct, i configured the setup, output node. but i don't know why this error is coming. 

Hi everyone, I am working on a task where I want to compare values in a read-only grid. The data in the field consists of text-type values, for example: k(100), k(101), SH(300). While applying filters in the read-only grid, I want data whose values are greater than 100. Here, we should check only the number in the text. is there any possibility to achieve this functionality

Removed

I need assistance resetting a user’s password in our Appian environment. Due to security restrictions, we do not have SMTP/email functionality available, so the standard “Forgot Password” workflow cannot be completed.  Current Behavior I navigate to the Administration Console → Users Locate the user record for John Doe Click “Reset Password” System prompts that a reset email has been sent No email is sent because SMTP is disabled