Data Fabric

Hi, I'm looking a reliable way to deal with concurrent DB access. So I have few questions. First, I would need to use many sequences (like Oracle) for a same table. So I've created a "counter" table to handle this :Table counter(sequence_name, sequence_value) ex: "sequence1" -> 10 "sequence2" -> 12 "sequence3" -> 56 Now I have a "contract" table in which I need to store one of the counters value in a field : Table contract(id, sequence_number, name)  How would you do, to ensure these operations are atomic ? seq = SELECT sequence_value FROM counter.sequence_value WHERE sequence_name = "sequence1" UPDATE contract SET sequence_number=seq WHERE id=100 UPDATE counter SET sequence_value=seq+1 WHERE sequence_name = "sequence1" Goal : If two different users update two different contracts at the same time, each contract must store a correct and different seq number. I was thinking about doing that such of code in a whole PL/SQL (stored proc) using such a

Hii All can anybady help me i want to cancel my application form until unless review by HR and Keep updating status in related action whether HR has seen or not? this is summary view of candidate details and this is my cancel candidate details process

Hello, I put you in context. I have a related data model and there are student and grade entities. These entities are related by a record. The problem I have is that I want to create a new grade through a related action and automatically assign it to the student. I can't do this because in the related actions list you cannot pass the id of the student to which the created grade will belong as a parameter. Any ideas to pass the student id to a related action? number is the student id

Hi, all I'm relatively new to Appian and I need a bit of help. I have an interface that displays a read only grid.. I use a record action which runs in a dialog box. Once the record action is run, the grid refreshes and displays the data that has been entered. I have a "Submit" button which I would like to hide whilst the read only grid has no data to display. Any advice would be helpful. Thanks Stephen

I have created a simple table in the same database as aavehicle and I created a data model for the table along with CREATE and UPDATE record actions.  When I add a new record using the CREATE record action and associated UI, the data does not appear in the record List until after I run a Data Sync.  When I UPDATE a record using the UPDATE record action and associated UI, the changes are reflected immediately in the record List.  I have scrolled through all pages of the list and confirmed the new record does not appear.  If I query the database BEFORE running the Data Sync, the new record is in the database.  Any ideas why this may be happening?

Hi Readers, I have created a record as below, and there are 9 users using the application, and there are 3 groups  For supposeusers are: u1, u2, u3, u4, u5, u6, u7, u8, u9Groups: All users, Administrators, App1Users, App2Users  All users group is a parent group. Users in App1Users group are: u1, u2, u3, u4, Users in App2Users group are: u5, u6, u7Users in Administrators group are: u8 and u9  Use case: When users u8 or u9 login They should  be able to see all the records entered by all members who are using the application.When users u5 or u6 or u7 login and see the records they should be able to see only the records which are entered by their group membersWhen users u1 or u2 or u3 or u4 login and see the records they should be able to see only the records which are entered by their group members What i tried: I have used loggedinuser() function it helped me see the records entered only by the logged in user only; i failed to write an exception in the filt

I am trying to pass the value of a process variable into my expression, and the expression is also used in the process model. Please, see attached image: The rule - drxxxxStoredProcedureDirDepAggregatedPaymentForDate looks like this: executestoredprocedure(  datasourceName: "jdbc/ABC",  procedureName: "dbo.procCtePaent",  inputs: {    {      name: "date_param",      value: ""    }  }).result[1]

Our store procedure on DB returns me list of Dictionary and it has over 50 columns. Before I return this to user in gridfield how to get subset of columns from that List of Dictionary? In other words i need new list of Dictionary with  just a few columns. for example  extract columns {"Amount", "id"). I'm using version 20.1

We have a requirement where we need to show toggle button or checkbox in user filters section of record type list view. I tried but could see only dropdown and date range options while adding user filters. so can anyone help me to resolve this issue. any lead would be appreciated... Thanks in advance !!!!!!!!!!!!!!!!!!!!!!!!!!!

Hello there, I am using a!pickerfieldrecord function under search filters to return data. I am applying this on integer field where user can apply multiple filter like 123456,5746875,59867578695,948647 etc at a time. I want to apply a condition while searching that, user should enter 9 digits or atleast 9 digits in order for the search to work. How can i achieve that, i dont want to apply queryfilter as that is not helping the requirement. Added sample code, please suggest if that can be customized!! a!localVariables( local!number:{}, local!isLoanNoValid: if( len(local!number) < 9, true, false ), a!columnLayout( contents:{ a!pickerFieldRecords( label: "Number", labelPosition: "COLLAPSED", maxSelections: 10, /*placeholder: "Please enter 9 digits inorder to start search",*/ recordType:cons!PAA_record_type, value: local!number, validations: if(isnull(local!number), null, if(local!isLoanNoValid,"Please spr

I am using a process model to export data from the database to a spreadsheet. I am not using the export in the record type, just to be clear. When selecting the fields using the a!querySelection -&gt; a!queryColumn, this immediately pulls the data and exports to a new spreadsheet, with no way of adding code to process it. If I have a CDT that has, for example, twenty fields, and one of those fields contains an employee ID. How can I, or is it even possible, to use an expression rule that takes an ID parameter, and outputs the actual employee name? There doesn&#39;t seem to be a path forward on this. I&#39;ve looked through the process model, all the different query types, etc., but no way to pull the data, then process that data, before outputting to the spreadsheet. Just to make sure this is clear, I already have the expression rule to process the data, I just have nowhere to do it and if there is a way to do it, I have not found it. Any help will be greatly appreciated.&nbsp; Thanks.

Hi Guys,&nbsp; As the user&#39;s language can be set as English (US) and English (UK), and this will make the date format different when using the function now(): US format :&nbsp; &nbsp;14/2022 6:36 AM GMT+00:00(Date and Time with Timezone)UK format:&nbsp; &nbsp; 14/03/2022 06:36 GMT+00:00(Date and Time with Timezone) and this will cause these two format&#39;s date save into DB (based on my current PM design) which will cause my following work flow (such as micro service retrives the date from DB) goes wrong when using these data. I tried to transfer the date by using such method: { todate(datetext(todate(now()), "DD/MM/YYYY")) }but it returns a unexpected value: Date out of range (73032022)(Date with Timezone) So I&#39;m wondering if there is any method can resolve this issue, thanks

Hi, I have RecordType based grid (the recordType is called &quot;CJT_R_Vehicles&quot;). The&nbsp;multiple grid selection is saved into a &quot;selectedVehicles&quot; local variable. Then I need the selectedVehicles to be passed to an&nbsp;ER. - What is the RI&nbsp;Type you would select in the ER to store the selection lines ? &nbsp; &nbsp;CJT_R_Vehicles &nbsp; &nbsp;CJT_R_Vehicles (array) &nbsp; &nbsp;RecordType&nbsp; &nbsp;RecordType (array) - In the ER, how you would manipulate the RI (vehicle lines) ?Let&#39;s say I need to index some fields, how would you do ? I&#39;m just curious because with this kind of type, we can not manipulate&nbsp;them with string fieldnames,&nbsp;without to be exposed to this error :CJT_R_Vehicles must be indexed by its corresponding record type fields

Hey all,&nbsp; I replaces an user input task in my interface, and now the task is not showing on the Record tab. the old task had this figure&nbsp; And the new one did not, how can I link the task to the record tab ? To the related actions more specifically. Kind Regards,&nbsp; Victoria

hey all,&nbsp; There is one bug that I need to have fixed: Whenever someone opens a request the form does not open anymore in the record tab. Instead the user has to navigate to the tab &ldquo;tasks&rdquo;, refresh the window, and only then the form appears. Why is this happening? Instead of opening directly the form here directly :&nbsp; I have to go to the task tab to see the form itself. Kind Regards,&nbsp; Victoria

If I&#39;ve queried up some data, is there an easy way to filter that into smaller subsets without making new queries? For example if wanted a grid of &#39;all users&#39;, then I wanted second grid of all people with the first name &#39;John&#39; and then a third grid of all the people with the last name &#39;Smith&#39;, is there a way to filter the data for the other 2 grids using the first grid&#39;s data? Or am I stuck making 3 different queries to the database? Would it be possible somehow to create local variables containing all three using a single query?&nbsp;

Hi, I am having few issues with running my application. Some of the field entries are not getting updated in my table where as most of the other entries are working fine.&nbsp; What could be the reason?&nbsp; My request approval Interface.&nbsp; Comment is a required field.&nbsp; In my summary view, approval comment entry is not updated. Its blank.&nbsp; No errors in Process model&nbsp; Please advise what should be done to troubleshoot this problem?&nbsp;

I have a Field CDT which has a fieldTypeId column defined as a nested FieldType CDT. The Field&nbsp;CDT is mapped to a field db table which has a field_type_id field, defined as INT4.&nbsp; I created a Field record type, based on the field db table. The fieldTypeId column is recognized as a Number in record type Data Model configuration. When I try to create a record list action (CREATE) using available related action wizard, the Field record type does not recognize the&nbsp;available&nbsp;Field&nbsp;CDT as a compatible CDT and wants to create a new Field1 CDT, which has a fieldTypeId column defined as a number and not as a nested&nbsp;FieldType&nbsp;CDT. As all appian tutorials and documentation recommend using nested CDTs as a type on a CDT which has 1:1 and N:1 relationships (related columns), how to tell the record type related action wizard to use already defined CDTs with nested CDT columns? Am I missing something or this is a normal behavior? Should I let the wizard create new C

Problem:&nbsp; An error occurred in executing an Activity Class. Details:&nbsp; An error occurred while trying to write to the entity &quot;AX_Maintenance&quot; [id=2ec391d4-a462-4e0e-92e4-b01ad2475087@3690, type=AX_Maintenance (id=3836)] (data store: AX Data Store). Details: org.hibernate.PropertyValueException: not-null property references a null or transient value: AXMaintenanceDT4830.vehicleid Data: TypedValue[it=3836,v={&lt;null&gt;,&lt;null&gt;,2021-11-25,0,o,Scheduled,&lt;null&gt;,&lt;null&gt;,&lt;null&gt;,&lt;null&gt;,&lt;null&gt;,srinivas.talasu@tcs.com,,,,2021-11-26,srinivas.talasu@tcs.com,2021-11-26,&lt;null&gt;}] Recommended Action:&nbsp; Examine the activity class to correct the error and then resume. I am getting this error when I add details and storing it in data store. Can anyone help me to identify activity class

I have&nbsp;a grid that&nbsp;has been populated by a map in a local variable and I would like to export that data to an excel file. The data isn&#39;t in a record, so I can&#39;t set&nbsp;showExportButton to true. It isn&#39;t in a datastore entity, so I can&#39;t use&nbsp;exportDataStoreEntityToExcel, and it isn&#39;t a process report so&nbsp;exportProcessReportToExcel is out. Is there any other way to export this grid&#39;s data (or I suppose just the local variable itself)?&nbsp;

Hello, I am trying to create one editable grid interface which fetches data from appian cloud database (employee) and populate the grid. This grid have should allow to update and delete options. I created the record action for update and delete button click but they are not working. Please share me some sample code.

Hi, I&#39;m surprised to have to ask this question, but could you tell me how to access the value of a CDT field giving a&nbsp;number please ? I would need to use this kind of code : local!value: field(local!vehicle, 1) /* where &quot;1&quot; is the first field of the row */ a!localVariables( local!vehicle: rule!CJT2_GetVehiclesWithFilters( id: 1 ).data[1], /* Here I just display some data with fieldname */ property(local!vehicle, "id") & " - " & property(local!vehicle, "model") /* Now I would need to do the same thing, without using the fieldname, so I need a function that can do that I just tried to use the "property" function as an example but maybe is there any other function like "field" or other ? */ property(local!vehicle, 1) & " - " & property(local!vehicle, 2) field(local!vehicle, 1) & " - " & field(local!vehicle, 2) ) Regards

Hi all, A question about the difference in layout on record lists. We have a Sites page based on a Record List. In this Record we have multiple Record List Actions. However, having one action differs a lot to having more than one. Screenshot #1 - With one action Screenshot #2 - With two actions Is it possible to have two blue icons like in screenshot #1 next to eachother and above the filters while keeping the type Record List on the Sites page. Thanks in advance. Ranno

dear all, I have a record that it used to work.&nbsp; Now appears the following error.&nbsp; &nbsp;How Can it be solved ? Could be this related ?

So I&#39;ve got an API integration that returns data in a single string field and I&#39;d like to extract sections of the data to put into&nbsp;separate CDT fields. So the string that&#39;s returned will look something like this:&nbsp;&quot;Advil 20 MG/ML Oral Suspension&quot;. I&#39;d like to retrieve the data before the number, then everything after including the number. I&#39;ve posted what I have so far below. What I&#39;m wondering is how do I get the index of the first character that&#39;s a number? If I get that, then I can figure out the rest. Thanks! a!forEach( items: rule!NLH_GetPrescriptionDrugs(searchTerm: ri!search).result.body.drugGroup.conceptGroup.conceptProperties, expression: a!forEach( items: fv!item, expression: 'type!{urn:com:appian:types:NLH}NLH_Prescription'( rxcui: fv!item.rxcui, medication: fv!item.synonym ) ) )