a!queryEntity( entity: cons!PF_ENTITY_VW_REQUEST, query: a!query( aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn(field: "RequestUserID", isGrouping: true), a!queryAggregationColumn( field: "RecordID", isGrouping: false, aggregationFunction: "COUNT" ) } ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter(field: "RecordID", operator: "not null"), if( isnull(ri!RequestUserId), {}, a!queryFilter( field: "RequestUserID", operator: "=", value: ri!RequestUserId ) ), if( isnull(ri!activeStatus), {}, a!queryFilter( field: "ActiveStatus", operator: "=", value: ri!activeStatus ) ), if( isnull(ri!RecordID), {}, a!queryFilter( field: "RecordID", operator: "=", value: ri!RecordID ) ) } ), pagingInfo: if( isnull(ri!pagingInfo), a!pagingInfo(startIndex: 1, batchSize: - 1), ri!pagingInfo ) ) )
Hi Appian team,
Please check above code return for rule expression, it returns two fields one is RequestUserID and other is recordID. I want to fetch Username from UserID which means I have to get one more field as output that is UserName which I should get from user ID. I know there is user() function in-Build, but i do not know where i can use it to fetch username from RequestUserID field.
Can anyone of you help me solve this issue?
Thanks
Sunu Sam
Discussion posts and replies are publicly visible
Hi there,
The user function works with the username. We can use the user function to get different properties of a user by passing the username and the property that we want to query. In the above problem, you mentioned that you want to extract the username using the user function. But that is the input we have to pass to that function.
Can you tell me what kind of data is this query returning? Is UserID an integer value or text value? Can you also attach the resultant data subset so I can take a look at the output?
Hi Harshit,
thank you for replying,
Yes UserID is text field.
Following is the result for the above code snippet added.
What is my requirement is i want one more field in the result that is UserName which i should fetch passing REquestUserID as input
Is REquestUserID the usernames of the Appian user accounts?
Hi Field is coming from queryENTITY that is view from DB table.
yes they appain user account as well but I need to get those from View table values
Okay. I have an approach where we can manipulate the results to have one extra field in the output - username, but I won't recommend that as this QE must have a CDT mapped in the DSE. So we should not change the structure of output. But if you are consuming this data in a grid, then you can use user() function in the dedicated column and query the firstName and lastName or email of this userID.
Help me understand how will you consume this data.
HI Harshit,
Thank you manipulating result is fine as far as i get the output,but am using it in the filter dropdown query which is used to filter the grid data. below is the code i use.
a!recordFilterList( name: "Requestor", options: a!forEach( items: rule!PF_getRequestorListByFilters1( pagingInfo: a!pagingInfo(1, - 1) ).data, expression: a!recordFilterListOption( id: fv!item.RecordID, name:fv!item.RequestUserID, filter: a!queryFilter( field: 'recordType!{f40a3d03-d822-4eed-91ba-6902fa36eab8}PF Request.fields.{RequestUserID}RequestUserID', operator: "=", value:fv!item.RequestUserID ) ) ))
the above code is used in record type-userfilter.
thanks
thanks for your help...finally its working i have written a rule to fetch username from user ID and called it where am using it.