Skip to main content
Brainy
Jun 23, 2023 2:45 PM UTC
Question

Expected result not obtained after querying a record type

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
    Genius
    Jun 23, 2023 3:27 PM UTC

    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]

    Brainy
    Jun 23, 2023 5:31 PM UTC

    okay,Will try

    harshitb6843
    Brainy
    Jun 23, 2023 3:51 PM UTC

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

    Brainy
    Jun 23, 2023 5:31 PM UTC

    I tried relayedRecordData, didn't work

    Brainy
    Jun 25, 2023 10:45 PM UTC

    this issue has been resolved .