Discussion Categories

Hi, To get a value from a memory CDT list (not a table) on a single field condition, I use Index(CDT, whereContains(value, CDT.field2)). In SQL : SELECT * FROM table WHERE field2 = value Is there any way to do the same thing with Appian fonctions when we need to make a lookup with an AND condition ? Ex : SELECT field1 FROM table WHERE field2 = value AND field3 = value  Otherwise, I would do it with a simple foreach(). (PS : My question, is "not" about how to query a table with multiple logical conditions of queryEntity [emoticon:bfea11b94cc048458ee2c01f963db38d] )

Hi, I want to extract text from a pdf page by page, paragraph wise, which includes different headings and related contents. Then I want to store them in DB which includes two columns one is heading column and other is content column. I used getpdftext function initially, then extract function to extract the desire contents, but did not get the expected result as the heading words are also present inside contents.Anybody please help me out?

I am not able to download the plugin from app market ( check below ) https://community.appian.com/b/appmarket/posts/log-reader Please let me know the issue and how to resolve it,

Hello All, Question 1: I have a a!startProcessLink() within the drilldown screens of my site. Once process triggered and actions gets completed successfully, it is landing me on HOME screen. Is there any way to land on same screen where I placed/clicked the a!startProcessLink? Question 2: Is there any alternate way to open an action in Dialogue box rather than using a!recordActionItem()? Thanks in Advance.

Hi, I'm trying to save multiple upload document ID to an Array Field but it turned out blank in the database. I checked the variables and they show value but nothing has been saved I was wondering if you have a solution for this? Thanks,

I had created the add new vehicle interface as the assignment for the appain developer part but in the add new vehicle form when i entered my values the values are getting disappear how could i resolve this can isuue ?

Hi Experts, I need help with the steps/method/way to identify whether plugins installed on the server uses javax.mail. Could anyone of you help please. Thanks in advance.

Hi there, I have database table, one field "matnr" configured as varchar, can be NULL, but when setting it to null or NULL in the process model, then writing to database (pic 1), the field value is not NULL, while kind like empty (pic 2) . I am trying to create a expression rule searching the information with this field "matnr" without value, set "matnr is null" is not working. what's the way to do this? why Appian condition "is null" in Query editor does not work for empty field as other languages? regards,Lin

startProcessLink() is not creating another instance (Sub Process Model), but it assigns tasks. My Requirement is, I have a Card/Button which has startProcessLink(), once clicked I started a Process Model which has Form1 with Submit button in it. Once Submit is clicked, that should create/open another Sub Process Model which has another Form2 in it. It navigates to Sub Process Model, but assign the form as a task and re-directing back to my original page (Action Completed). How can I navigate to another Sub Process which has another form.?

Hi, Need your suggestion. I need to prepare a report with All Knowledge centre in the environment with their size. I'm currently doing manually by selecting each KC and copying the size from properties. Is there a content function to list all these details. Thanks in Advance

Hello, I need to click on a card that has a safe link, no label. I've tried: click on button, click on card, click on link. Does anyone know any possible solution?

Hello, I need to store a text in a variable. The text is inside a paragraph which is inside some columns and which is inside a card. The text and card have no label. Thanks in advance.

  After Process It's showing only start and end nodes Before starting the process

In My Practice Application, I have an accounts table that contains the details of the account holder like the name, balance, etc. Here, I am writing a stored procedure to transfer an amount from one account to another account           in the Transfer Amount stored procedure, 2 steps need to be included in a transaction,                              1)  subtracting amount from the sender account.                             2) Adding amount to the receiver account 

Hello, I want to show a calendar with WORK DAY and NON-WORK DAY displayed separately (show holidays, weekends marked as non-working day) on the screen. How do you usually do this? Thank you.

I create an editable grid where i can see the data of my CDT "Client" (red square) and the relationship or related data from CDT "Vendor" (blue square). Now I want to select many rows to call a related or record  action to UPDATE the selected fields in the black square. (don't add more rows or delete, just UPDATE) The data of the editable grid table comes from a form from another interface. For example, in the image below, I select 3 rows, then for those 3 selected rows, then click a button or link to call a preconfigured related action to update the values in the black square. The idea of this is to use the select to call a related record or action for bulk actions instead of making changes row by row. Is it possible using a editable grid or a real only or is there another way to do the same?

Hi Team,  I have a use case where if someone clicks on a button then an email should be sent but that interface should remain intact. See the below process model, So the start node is configured to run the following form, When Someone clicks on search, a second interface loads below to it but at the same time I want to send an email and that is what I am trying to configure it in process model. So after clicking on search, it is showing below when I am just trying it with interface and not by running the process model Now the main problem is that, I have configured that Process Model to run using a site. But when I click on search button in site, email triggers but the partial interface like in the above image does not load. See the below site, Please help in this regard. Thanks in Advance

I am receiving the following error message while creating a record Action for a 'User' table..  Please let me know if there is any restriction to create a record action on a User Record Type.

Hi, we are facing issue with executing “Open Browser(Edge)” action stage in Appian RPA for “https://xxxxx.xxxxxxxx.local/Reports/Pages/Folder.aspx” URL. Getting below error while executing it. Kindly give your suggestion.

I am trying to replace findfoldersbyname() with findcontentbyattribute(), but can only get findcontentbyattribute() to return a List of Content, it returns something like [Content:56629].  Is there any way to return the folder itself instead of [Content:56629]?  findfoldersbyname() returns a folder object and I would like findcontentbyattribute() to do the same or somehow use what it returns ([Content:56629]) to return the folder itself.

We have a requirement to make Encrypted Text Fields resize/expandable. Is there anyway we can achieve that? Please suggest. Thanks in advance!

Hello community, that is the error- An error occurred while trying to write to the entity "LMS_Approval_Details" [id=df9f2bb8-8169-4985-987e-21a22f970163@4662, type=LMS_Approval_Details (id=3874)] (data store: LMS Data Store). Details: org.hibernate.PropertyValueException: not-null property references a null or transient value: LMSApprovalDetailsDT7163.customerId Data: TypedValue[it=3874,v={<null>,<null>,,,Approve,,,}] Thanks in advance

Is there a way to only get the modified fields in the UI then compare it to the database value?

Cucumber for Appian Framework  22.2.1, when running tests and an alert type window is opened by webdriver, error message "org.openqa.selenium.UnhandledAlertException: unexpected alert open: {Alert text : Are you sure you want to leave?}" is displayed on the test runner console and the test execution is stopped. Any idea why this is happening and something to work around?

Hello, I'm trying to run some tests and I get the same error on login and logout.  ERROR com.appiancorp.ps.automatedtest.exception.ExceptionBuilder - Logout link org.openqa.selenium.NoSuchElementException: Unable to locate element: //a[contains(@aria-label,'Open user options menu')] It doesn't seem to find the Logout Link.  I have tried with Chrome and Firefox. Firefox also tried with two versions where the last one was the updated version and the drivers too, and the exception is still there. Does anyone have an idea how I can fix it? Thanks.