Foundation

Hi, I am getting date and time in date field from data base. I am able to convert it to time using datetime().  I am using a!exportDataStoreEntityToCsv() to download the csv file but the issue is am not getting expected output. but when i place the cursor on that cell in csv file then am able to see the correct time.  My requirement is that time should be displayed correctly without putting the cursor on that cell. Can someone help. Thanks. 

Hi Everyone,  I need help on the below issue :  We have a dependency between two screens, so  in the first screen we enter an XYZ fields and save it and depending on the Role what we select in the second screen we get the XYZ fields of first screen what we entered and then save it. The problem here is , after saving it, when we navigate to the first screen, XYZ fields values are not displaying. It will display after refreshing it or if we wait for few secs. Kindly let me know is there any way we can display without refreshing  or reloading the page.

Hi all, Has anyone created a line chart having the Time on Y-Axis and Date on X-Axis? We're looking to visualise data for  the time of day that requests enter the queue for an application to identify peak periods. Below is a sample interface we're playing with, essentially we want to change the "# cases" on the Y-axis to "time of day". Any information or examples will be much appreciated! Thank you. a!localVariables( local!requests: a!dataSubset( data: { { created_on: datetime( 2019, 1, 10, 5, 7, 10, 0 ), id_count: 65, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 11, 5, 7, 10, 0 ), id_count: 66, time: time( 5, 7, 10, 0

Let's say I have the following query where the data is being filter based on siteIds local!estimations: rule!EEP_QE_getEstimations( statusId: cons!EEP_VAL_STATUS_ACTIVE, columns: {"site_id_fk", "status_id_fk", "estimation_business_id", "id_pk"}, siteIds: local!selectedSite ).data Now, I'm saving local!selectedSite using a dropdown menu a!dropdownField( label: "Site", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: local!sites.name, choiceValues: local!sites.site_id, value: local!selectedSite, saveInto: local!selectedSite, searchDisplay: "AUTO" ) the value of local!selectedSite is null at the start so everything is queried, as expected. If I select a value from the dropdown the data is filtered accordingly. But when I select a value and then I select the placeholder, the query does not return any values.

I have a need to add a confirmation link for the email recipient to be able to click to confirm information in the email. Has anyone done something like this?

Hi, I have a process that displays a form. The latter contains an upload component and a donwload link. The upload mecanism works fine as I can see the "document_id" saved in my rule Input. Could you tell me why when the user is in modification mode of the form (not readonly) the click on the download link throws this error please?     {"error":"APNX-1-0000-000","message":"Invalid Content ID","title":"An error has occured"} If I save the form, leaving the process terminating, writing the data in DB, and then re-open the form (from the same process), the download button works fine. When I am in modification of the form in the Designer, when testing the link, I can see the error is systematic, but if I launch a testing Expression rule to examine the document ID, I can verify that the document in file system Appian is fine :     todocument(51755) => gives me the co

how to edit groups in group picker which are stored in database as groupids with a related action from a form

There are two datatypes in Appian: dateTime and date. How can we take only time as input?

Hello,  I would like how to formulate string which can be foreached after with only working dates between two dates.  Lets say if I have  start date: 2021-02-15 19:11:43 end date: 2021-02-22 19:11:43 In this case the result have to be {2021-02-15, 2021-02-16, 2021-02-17, 2021-02-18, 2021-02-19, 2021-02-22} Any ideas how this can be achieved ?

Hi Appian Experts, I have a requirement where i want to launch external system directly from related action without user interaction/extra click on UI. External system should launch soon as i click on related action.  Creating UI task with giving safe link will not work here as user interaction  not required, also, webContentField component will not work here because launch URL is not safe url(it's http url) . Any quick help will be highly appreciated.

Hello,  I have an interface with a grid which has a column called actual time which is an editable field and multiple entries can be added. Suppose i enter 3 rows and there are 3 values for actual time say 5, 10,15 and if i edit the first value ie 5, a text box should be displayed where a comment can be added.  So if any of the row values is edited, the text box is displayed.  TIA!!

.

All of the sudden a client appears be getting this error when trying to start processes.  "The Process Model cannot be started. There is no published version". This happened in a test environment. upon inspection of the process model it seems like the PM was missing the latest versions as if someone came in and deleted them and now there were only a few old unpublished versions. A quick solution was to save and published the PMs in the dev environment and deploying them again. However, I don't know what might have caused this problem? Has anyone run into this problem and found the cause for it? Some pointers would be helpful to ensure that this doesn't happen again. Is there a log registry I can look that would information about this issue?

Hi All, Could someone please help on Stored Procedure used in Appian? My main question is why do we need Stored Procedure in Appian? What is the main purpose behind using this? In What scenario it can be preferred over views? Thanks Faisal

Hello, I would like to know whether Cucumber/Fitnesse testing only refers to "on premise Appian Installations" or are they usable as well for "Appian cloud installations". Do we need an specific set-up (eclipse IDE, local servers, etc...) to set up the environments?. Sorry but it's not clear to me reading Cucumber and Fitnesse sections on the playbook. Thank you!

Is there a way to add client's custom disclaimer text as a footer which will be visible on every site page?

Hi Everyone,  I need help on the below issue :  We have a dependency between two screens, so  in the first screen we enter an XYZ fields and save it and depending on the Role what we select in the second screen we get the XYZ fields of first screen what we entered and then save it. The problem here is , after saving it, when we navigate to the first screen, XYZ fields values are not displaying. It will display after refreshing it or if we wait for few secs. Kindly let me know is there any way we can display without refreshing the page.

Hi all, We have a Site based application with a main home page that displays information about processes. When a process flow ends, then the main home page is displayed. The process is modifying some values that should be displayed in the main home page. However, when the process ends the main home page is displayed with the old values. Only when we refresh the browser the page displays the new values. The home page is reading the values from the database. We have verified that the variables are declared inside a a!localVariables() block. We have also tried to use a!refreshVariable() with no luck. Does anyone have any idea to automatically load the new values?

Hi Team, I was not aware about the archive task thing, I lost many tasks . I need those task back or see them. Any way to do that?

Is there a way to Fix multiple process instances of a process model ?

I am working on a process model and it needs to stop at a certain time (For example 2PM CST) However, I don't see any option to do it. I've tried working on the advance options but it seems like that doesn't satisfy it as well. This was the condition that I put in Advance Options now() < local(fn!todate(today()), timezoneid()) + 30/24 Any suggestion is welcome.

local!a:toInteger(20),document(local!a,"id") works, but when Replcaed local!a with ri!Table_Name.docId getting error, How to fix? a!linkField( label: "Link", labelPosition: "ABOVE", links: { a!documentDownloadLink( label: "Document Link", document:document(6802,"id") -->replced 6802 with ri!Table_Name.docId gets an error ) } )

Hi All,        I am getting the below mentioned error in Grid field when i try to submit the form. Expression evaluation error [evaluation ID = N63DMP1Y] in rule 'A' (called by rules 'B' > 'C') at function a!gridField [line 62]: key. Request to provide reason for this error occurrence. Thanks in Advance Pradeep.B

Hello, I have the following list of strings coming from a query:  List of Text String - 4 items"user1"(Text)"user2"(Text)"user2; user3"(Text)"user4"(Text) How  I can sort that so the final result will be list of strings of only unique values:  Result:"user1"(Text)"user2"(Text)"user3"(Text)"user4"(Text)

Expression evaluation error [evaluation ID = DD2TAAGA] in rule ‘ibs_referencetableibsrefrfld' (called by rule ‘ibs_referencetables') at function a!dropdownField [line 312]: A dropdown component [label=“FLD_ID”] has an invalid value for “value”. All selected values must be present in the choiceValues array, but value was 56 and choiceValues was 1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12; 13; 14; 15; 16; 17; 18; 19; 20; 21; 22; 23; 24; 25; 26; 27; 28; 29; 30; 31; 32; 33; 34; 35; 36; 37; 38; 39; 40; 41; 42; 43; 44; 45; 46; 47; 48; 49; 50; 51; 52; 53; 54; 55; 56.