Skip to main content
June 23, 2023
Question

Expected result not obtained after querying a record type

  • June 23, 2023
  • 6 replies
  • 0 views

I am building a POC for leave management systems. Tables: Employee( holds employee details), Leave balance(holds leave balance and the leave type), Leave table( shows the type of leave and its maximum limit), and leave history(holds leave history of employees) 

I am trying to check the leave balance for the employee with filter - logged in user and leave type . leave type is Integer. I get results of every leave type which is not my expectation. please help me fix this issue. I want only the leave balance for a particular type. 

query

o

output:

    6 replies

    mathieud0001
    June 23, 2023

    You'll have to do an aggregation with the SUM function on the leaveBalance field.

    [View:https://docs.appian.com/suite/help/23.2/fnc_scripting_a_aggregationfields.html]

    June 23, 2023

    okay,Will try

    harshitb6843
    June 23, 2023

    Can you try adding this field that you are adding a filter on, in the relatedRecordData configuration and see if it works?

    June 23, 2023

    I tried relayedRecordData, didn't work

    June 25, 2023

    this issue has been resolved .