Discussion Categories

I have an expression rule will return 2 types of record type - Case - Error depends on if there is any error occur during the expression rule process so when I get the result from the expression rule, I do need to know what type is the returned value, how can I achieve that? I tried to use typeof(), but it does not work. I am wondering if I need to use type!, but I do not know how to write a valid reference using type!

Hello everyone, I’m experiencing an issue after changing the structure of a record in our development environment. Since we don’t have direct access to the database where the records are stored, we had to send the scripts to the client’s database admin to execute and reflect the changes in test environment. Now, the fields are the same in both the DEV and TEST environments. However, at first, the record in TEST failed to synchronize, showing an error related to the record. After manually re-syncing, the synchronization succeeded. The specific error message is in the execution of a process model, in the Write Records node: Unable to insert to source because the sequence PARTICIPACIONES_SQ is not valid, does not exist, or is not accessible. The Write Records node is actually trying to save the "Relacion Socio" record, which has a one-to-many relationship with "Participaciones" (the record that also underwent structural changes and is now synchroniz

Hi everyone,i am unable to call the process variable name in the report,it's showing error in the report if i call the process variablecan any one help me with it ,i have attached the image below,

I've got a requirement that needs a expandable readonly grid, I saw Expand/Collapse Rows in a Tree Grid - Appian 24.2 in other post but this is a gridLayout which seems can't be paged But I want the grid to be paged and expandable, the collapsed rows should be just same to the main row that can be selected and has recordactions in every row How can I implement this

Hi, I created Record type but, I need to create record fields manually so for that Create From Scratch option should be enabled but I don't see such option here so could you please help me to resolve this query? FYI

  I have an Interface with Cancel and Submit button. This interface also has Rule Inputs defined for Cancel and Submit. I also had defined a process model for this Interface. I have kept the process model screenshot as well to this. When I am testing the Process Model, program always goes to "Import Excel to Database node", this happens even when I hit Cancel button the Interface. I feel the button clicks are not sending/capturing the correct values onto process model. Can you please let me what am I doing wrong here?

Record sync is failing due to this error : Unmapped record fields. 1 record field is not mapped to a source field. Update that field before saving the record type. I checked the correspoding table all the fields are in record type are properly mapped in data model but still the error is not resolved, is there anyway to fix this issue Thanks in advance

Hello there! Here is my use-case: I have a large record type (80'000 rows), which users want to be able to filter and export to Excel. It works pretty good, but my platform admin is kind of obsessed by the health of the platform. He is afraid that many user export the whole set of data at the same time, putting the server CPU into heavy load. So it is required to limit the number of records a user can export. Did anyone ever have something similar to do? I know the limit is set to 100'000, but can we decrease the same in some Appian administration setting? I see no property in the gridField to do so, e.g. to set "showExportButton" to false if the size of the dataset exceeds a given value. Is there any? I think it would be possible to obtain something with something like a readOnlyGrid or so, but I would like to avoid it for the pain of handling filters (and pagination?). Please help!

My project exists as three environments hosted on three separate URLs with three separate app names (dev, test and production respectively).  I want to make changes to my interfaces that only render in certain environments (mainly dev) so that they don't interfere with the client's UI experience.  I was wondering if there was some sort of metadata or variable that I could use to identify them for conditional logic.  I know pp! variables do something similar for processes.  Also, using string fragments from the unique parts of the URLs might work too, but I wasn't sure what methods are the current gold standard.

I am trying to build a custom export to excel icon which should download all the filtered records to excel. I can see a smart service i.e. write data store entity to excel but that is not useful in my case since i am using record type not cdt, hence no datastore exist in my case. Please let me know do we have any possibility to achieve this or not? I think just like data store entity there should be some feature related to record type as well but i cannot see that plugin.

I have a scenario where I need to extract the read-only grid data into excel. For example, I have a read-only grid with 5 columns. For the grid data, I have applied the "multiple drop down" field for the 3 columns and I'm filtering the data. Say, I have 1000 data in my read-only grid, out of which I have now filtered only 500 row data. Now my grid displays 500 data. How to extract these 500 row data alone into excel. I don't use record type, (so ruling out the default export to excel option available in record type). I want the dynamically filtered 500 rows into an excel. Please suggest how I can achieve this? Thanks in advance!

Hi, We are configuring SAML login in our client cloud environment and we have seen in the documentation that Appian allows encryption for the SAML assertion "Appian supports signed, encrypted SAML assertions up to the AES-256 standard" but the information in the documentation is very limited.The question we have is if we configure encryption with AES-256 in the IDP (Azure AD), how is the decryption key stored in Appian? Do we have to provide the key to Appian to store it internally or register it in the credential store? Thanks in advance

Hi, we have configured SAML login in our environment and we need to store the SAML Bearer assertion in order to get new tokens for the users while the assertion is valid. The issue we are facing is that users can have more than one session active in Appian at the same time, and for each session we need to store the assertion related to the session UUID so we can differentiate them. I am able to retrieve the user active sessions using the plug-in User Session Checker or the login-audit log to store the session UUID with the assertion, but I need a way to get the specific user session at the moment (current session) so I can filter my query with this value and get the correct assertion.  I tried looking for any function or plug-in that will allow this but found none, so if anyone knows a way it could be accomplish will be really helpful. Thanks in advance  

Hi How to use MNI and activity chaining effectively.In process model i got this message . I worry about performance.Thanks

Hi all, i have a related action that simply update a value in a record. Everytime i click on the action a loading page appears, like this one in link: see attachment/resized-image/__size/640x480/__key/communityserver-discussions-components-files/13/pastedimage1732014098437v1.png I want to not show it, i want to be able to see my site after the action.  Any suggestions? Thanks in advice

Team, I have Appian environment managed hosted in AWS. My Appian instance in talking to underlying on-prem data layer via VPN tunneling. Now, I can see extreme delay in production in few scenarios (Around 17 seconds). But when i am looking at performance logs, Appian expression rules & UI are not taking much time to handle request & execute. Can anyone help me on how can i check potential network lag or DB processing lag from Appian logs????? I have check rdms performance logs and they are not taking even a seconds to execute. Thanks, Dippoman

I have a requirement to convert date to text in this format yyyy-MM-dd.  First i used this function  datetext(local!date,"yyyy-MM-dd). but it didnt work for all users time zone. so i handled timezone by adding GMT function ie  datetext(gmt(local!date,usertimezone(loggedinuser()),"yyyy-MM-dd) This time it worked for all time zone.  But when i try to execute in the script task in process model, date is coming as -1 day. I also verified override with user time zone setting in PM is already checked.  Could you someone explain why it is not working. I am attaching snapshot 1. Admin console  2. my timezone setting  3. expression rule . I am getting expected result in expression rule  with different time zone. 4. PM timezone setting  5. result in PM script task when above expression rule is executed. Anyway, i was able to find out simplest function ie text (local!date,"yyyy-MM-dd).

I am working on an interview application and one of the features is to edit previous questions. I was tasked with having the header display the current question and answer given when you click on the question's ID. My problem is I'm not sure how to create this type of header. Any help with the code would be great! I know it needs to be done in the views and header section of the record type but I'm not sure exactly what to put. Any help is appreciated!

I am creating a cardlayout button that uses an a!startProcess link (which is shown below). On the initial grid page, I have a cardlayout button that when selected initiates a Create/Update Process model that users can update or create records for. The process model takes in a dynamic input for what type of file to create, and what location the file is associated with. The main issue is that once the user either cancels the form, updates a record, or creates a record, the form does not refresh to the initial page with the cardLayout and grid view of all the current records within the database. The data is added to the database and shows in the grid view when the user manually refreshes the page. However, the task does not exit out of the form to enter/update/cancel data. I also double checked the create(update)/cancel buttons and both have submit as true. I am not sure why the process doesn't close and refresh the initial page the process was initiated from.I should also add that th

The US Department of Labor (DOL) has an application called "GPMS" that is built using Appian. The application's url is cmp.dol.gov/.../. My company builds a related web application. There's duplication between the GPMS (Appian) application and our web application. For example, the GPMS application has "case" records and so does our application. We want to make it easy for a user to navigate from a case in our application to the corresponding case in the GPMS (Appian) application. The users have entered the GPMS (Appian) "case IDs" (8 digit numbers) into our system. Is there a way to construct a link using only the numeric case ID that would open the corresponding case record in Appian? For example, let's say there's a case with ID "123456789" in GPMS (Appian). The current url to the page in GPMS is something like the following: cmp.dol.gov/.../{...long encrypted parameter...}/view/summary There's no way for

I am using Record List on one interface. I have two questions here: 1. Can we color the Record List Header that has column names? 2. Can we freeze the Record List header when I am scrolling the bar down?

Hi, can anyone help on my query. recently my personal instance got upgraded and when i trying to create table using Cloud Database but i am unable to see Cloud DB from 6 Dots of Menu in right side next to setting option. And, also not able to create new CDT, DS(Data Store) objects in current Appian designer. is there any specific restriction there for Appian 24.3 version of my personal cloud instance. this is stopping to me getting Hands on exp on Appian Codeing. SYSTEM INFORMATION Appian Version 24.3 Regards, Kishore N

Hi I have to extract all user details into excel manually from one specific group it has nearly 6.5k users as the data is huge the data is truncated and cant copy all the user details and post to Excel below is the logic using to get users from group can you confirm is there any way we can get all this user details in batch wise like 1-900 later 901-1800 like that getdistinctusers(     topeople(       togroup(        123456       )     )   )

Hi, I have a process model where a rule is processed in a script task running parallel to a user input task. At the second AND gate, there are two possible scenarios: First API Call Path Reaches the AND Gate First: The API path reaches the AND gate before the user submits the task. This scenario works as expected, triggering the next chained User Input Task (UIT) in the process. User Submits the Task First: The user submits the task before the API path reaches the AND gate. In this case, the next UIT is not triggered as expected.the API call is not an actual API call but an expression rule with dummy data in output

Hi All, I am getting this error in integration, which is get and sending huge data , because of this the PM is failing as it is returning null value in the PM. The output is too large to display, so the value has been truncated. Switch to the Raw or Expression options to see the entire value any pointer will be helpful on this  Thanks, Pooja