Skip to main content
August 31, 2023
Question

How to query a custom record field

  • August 31, 2023
  • 2 replies
  • 0 views

Hi! I was trying to use a query to obtain a value from a database. Concretely, I want to return the value of a custom record field, with some conditions/filters (the Purchase Order ID should be equal to the one used in the process, and the Status of the Invoice should be accepted). All of this are conditions based in the same record type.

I had to use the custom record field (total invoice price, Record 1) to obtain the sum of the price of each invoice line (Record 2). 

As I said,  I have not only source fields in my records, but also custom record fields.

The problem here is that I can´t refer to the custom record field (pointed in red in the last picture) via query, because that fields are not shown in the database (cloud console). And the querys directly point to the database. 

So, what would you recommend me in order to get the value of the custom record field? Is it possible to add the custom record field to the database, in order to make it possible to query it?

Thanks a lot

    2 replies

    stefanhelzle0001
    Brainy
    August 31, 2023

    It is the whole purpose of custom record fields that they do not exist in the DB. And you can easily query them using a!queryRecordType. Did you not try that?

    abhayd3663
    August 31, 2023

    The custom fields are derived from the other fields by applying some calculations that's why they do not need to be stored in the DB.