General

I'm facing an issue related to timestamp precision in an Oracle table that’s used with Appian. The table has two timestamp columns: one with zero precision (Datatype - TIMESTAMP(0)) one with six precision (Datatype - TIMESTAMP(6)) When I insert data into these columns without any triggers enabled, everything works as expected: the zero precision column doesn’t include milliseconds, and the six precision column includes milliseconds. However, when I add a trigger to the zero-precision column, I get an error saying the actual timestamp precision is 7, but received 11 even though the column is defined with zero precision and the trigger only defaults it to SYSTIMESTAMP if null. Why would the trigger suddenly cause exception , wanted to understand the logic better 

if( rule!APN_isBlank(singlePV: ri!date), "", /*left(text(ri!date, "mmm",3), ri!format))*/ left(text(ri!date,"mmm",3), ri!format)) Following is the error  Expression evaluation error at function 'text' [line 7]: Signature length (2) does not match parameter length (3)

Hi i have a process variable called request_data which is cdt type and in that there was one column called casettnotes which is a cdt casenotes cdt has currently 4 rows of data in that there was a column casenote which i need to update which is 4th row case note column data for this i dont have primary value it was null so i tried using other column which is issuetype like if issuetype is failed then update casenot for that issue type like that, all i want the casenote column which is 4th row column in casettnotes cdt need to be updated how to acheive this tried using many alforeach with update function but nothing working kindly suggest on this

Hey everyone, I need to use the Fill PDF plugin in my Appian project. I have to create PDF documents where users of my application can add items, such as their name. I've built an interface that includes a 'paragraphField' containing the text of my PDF. I've used this interface as a form for my Fill PDF plugin. Can anyone help me better understand how the Fill PDF plugin works? I couldn't find any documentation.

Within the Appian interface, the date field typically accepts dates separated by a forward slash ("/"). However, in our use case, there are scenarios where we need to support dates separated by a hyphen ("-") or a pipe ("|"). To accommodate this requirement, I’ve written the following piece of code a!localVariables( local!onlyNumbers: cleanwith("1.22.1957", "1234567890"), local!length: len(local!onlyNumbers), if(local!length = 8, concat(left(local!onlyNumbers, 2), "/", mid(local!onlyNumbers, 3, 2), "/", right(local!onlyNumbers, 4)), if(local!length = 7, concat("0", left(local!onlyNumbers, 1), "/", mid(local!onlyNumbers, 2, 2), "/", right(local!onlyNumbers, 4)), null ) )) It seems that the Appian interface is not executing the logic as expected, and the error still persists.

I suddenly find when I use Dependents to check the dependents. I can not see any process model in the dependents tree. I also check the other env, they can see it normally. I want to konw why it occurs, is it wrong setting or a bug of Appian. How to fix it. 

I am planning for ACD300 certification so anyone kindly share valid suggestion

I'm getting this error in my application  I call the interface with the upload field in the forms and at one of the primary buttons i call the function a!submitUploadedFiles().    "at function a!buttonWidget". I cant understand what can i do for this to work. Already checked the version of the buttons and forms. It's all up to date. Can some help me ? 

Hi all,  i'm encountering trouble with my Admin Profile in a Cloud enviroment. Whenever i try to open properties of a node in Process Modeling or in Modifying a Process, i do not see all the related tabs but only the languages tabs.  Here is a screen:  This problem is present only in production enviroment of a single cloud system. In test, dev and production of other client i dont have this problem.  I've checked my profile in Admin Console and try to find difference with other admin profile that works perfect, but i dont seem to find any.  Tryed even to change browser and cancel cookies and chronology but without any success?  Does anyone encountered and knows something about this problem?  tks for reading 'regards

I have a form where we are showing multiple sections which is collapsable. I made couple of sections as collapsed initially thinking that contents would not load until user expand the section. But its not the case, contents are still evaluating even if section is collapsed by default.  I need certain data to be collapsed to improve the initail loading screen and need to do validation on clicking submit even for collapsed one. Section layout is perfectly doing the validation but its loading the contents in the background. Any suggestions or thoughts?

Hi together,I have a "map" value in a process. I realized that an IsNull/emptycheck rule I used in a gateway down the line, was failing of evaluating that there was (in my understanding) an empty valuecast( 'type!{http://www.appian.com/ae/types/2009}Boolean', length(a!flatten(ri!value)) = 0 )Even the new rules a!isNullOrEmpty ..... are not recognizing this properly. Does anybody experienced this as well? (not difficult to solve, but it was pretty unexpected) Kind regards, Richard

Hi,  I want to remove the null value keys from the list of the map below. Please let me know how to achieve that:{a!map(ABC: 6.7, EFG: 15.44, HIJ: 470.888, KLM: "9.8989984", OPQ: null), a!map(ABC: 8.4, EFG: 15.43, HIJ: 470.656, KLM: "9.2342", OPQ: null), a!map(ABC: 7.2, EFG: 15.42, HIJ: 470.554, KLM: "9.234234", OPQ: null), a!map(ABC: 5.6, EFG: 15.42, HIJ: 470.234, KLM: "9.63242", OPQ: null), a!map(ABC: "", EFG: 15.42, HIJ: 470.665, KLM: "9.54343", OPQ: null)} Regards, Sowvik

Expression Rule Body: a!localVariables(  local!formatDetails: {{format: "#.#", columnorder: 9, name: "ABC"}, {format: "#.##", columnorder: 11, name: "EFG"}, {format: "#.###", columnorder: 9, name: "HIJ"}, {format: "#.#", columnorder: 11, name: "KLM"}},  local!data: {a!map(ABC: "6.78998", EFG: "15.44443", HIJ: "470.8888", KLM: "9.8989984"), a!map(ABC: "8.44544", EFG: "15.4323", HIJ: "470.656565", KLM: "9.2342"), a!map(ABC: "7.232323", EFG: "15.4234234", HIJ: "470.55445", KLM: "9.234234"), a!map(ABC: "5.64545", EFG: "15.4234234", HIJ: "470.2342", KLM: "9.63242"), a!map(ABC: "453.345345", EFG: "15.4234234", HIJ: "470.665434", KLM: "9.54343")},  a!forEach(    items: local!formatDetails,&nbs

We did cleaning up of process model version for around 800+ process models in our environment. But we didnt see any reduction in memory utlization % or disk used %. Can anyone tell where versions are stored and how they affect memory utilization??

Has anyone figured out a way to export a DMN file from the Decision Table in Appian? We want Appian to be the source of the rules, but we need the DMN model so we can execute the logic on another offline system which must get the same results as if it were run on Appian. Appian claims it uses DMN, but doesn't actually supply the DMN model...which seems odd. Thanks.

I am planning to take Certification ACD200. Is there any prerequisite before taking ACD200?  Can I take the exam directly or should I need to pass ACD100 before ACD200? 

Is it possible in Appian to have sound on click? like on cards, charts, gauge etc.

Hi team We've just set up an application that uses the Send E-Mail Smart Service. Our Health Check Report has this to say: "SAL Approve Installation (0002edb5-ade8-8000-43ed-7f0000014e7a) Node: ""Send To user"" references a smart service that is no longer recommended for use (Send E-Mail). Please remap this node in the process model to use the latest version." I can find nothing in Appian documentation saying Send E-Mail is no longer recommended for use I can find no details in Appian documentation of any Smart Service that might replace this I can't seem to find a thread in this Community that addresses this issue Can anyone assist me to resolve this?Thanks and blessings Stephen

Trying to move the logic from query entity connecting to VW to Proc with input parameter and was able to create a Procedure on Maria DB . Challenge is trying to recreate includes operator logic for an column on proc using LIKE operator but not able to achieve it 100% currently got to an extend as below , there are multiple input paramter on WHERE clause and one below AND ( input_parameter IS NULL OR input_parameter = '' OR REPLACE (LOWER(COLUMN_NAME),' ' , '')  LIKE REPLACE (LOWER(input_parameter),' ' , '') ) additional checks made From Appian while passing the input parameter have also converted the input parameter to lower case and have appended %% before and after the string Input parameter definition have set charset as per the column definition. Still issue is value with alphanumeric value ending with number fails Ex: %abc1234_def4%. No result (actual record exists), but %abc1234_def% gives results 

hmacsha256bytehashbase64key - We are using this funciton in appian onpremise and now we are deploying to cloud . In cloud this function is not supporting .Is there any alternative function to use instead of hmacsha256bytehashbase64key ?Thanks

Hi, I am trying to generate excel document by using the a!exportDataStoreEntityToCsv(). Below is my code snippet: load( local!exportDocId, local!errorMessage, { if( isnull(local!exportDocId), a!linkField( labelPosition: "COLLAPSED", links:a!dynamicLink( Label: "Export Inactive Users Details to Excel", saveinto:{ a!exportDataStoreEntityToCsv( entity: cons!VW_EPMT_EWR, selection: a!querySelection( columns:{ a!queryColumn( field: "ewr_number" ), a!queryColumn( field: "name" ), a!queryColumn( field: "active" ) } ), documentName: "EWR Grid Record Data", saveInFolder: cons!EWR_FOLDER, onSuccess: a!save( local!exportDocId, fv!newDocument ), onError: a!save( local!errorMessage, "Error in Exporting File" ) ) } ) ), {} ), if( not(isnull(local!exportDocId)), a!linkField( links:a!documentDownloadLink( Label:"Download Excel File", document: local!exportDocId ) ), a!textField( value:local!errorMessage, readonly:true ) )

I am running some processing in parallel that includes api calls.The result with then populate an interface attended by a user. I have tried both a!forEach and MNI but for both the performance is not as expected. By looking at the performance tab in the expression rule, it is clear that the items in the array are running sequentially and not in parallel, as the total time for the expression rule is the sum of every iteration. As a test I tried to put only a GET api call in the foreach loop and the result is the same. This is not what I was expecting, is there anything that can be done to enforce the threads to run in parallel to optimize the performance?

The description tooltip is not visible when hovering on the Record action icon. Although I was aware it was there, now unable to see this tooltip on icon.

I'm currently in the process of scheduling my first Appian certification exam. During registration, I was redirected to the Registration | ProctorU platform, which requires me to select an institution. However, I couldn't find my company's name listed, and this field is marked as mandatory. Could you please advise on how to proceed?

Hi, I want to show the following hierarchy image in my interface.  How can I achieve this?  Please provide the coding.