Skip to main content
K
kavitar298810
July 3, 2023
Question

Is there any way to compare two record values of different record types to find the difference in a field?

  • July 3, 2023
  • 12 replies
  • 0 views

Is there any way to compare two record values of different record type to find the difference and provide the result matched and not matched record

12 replies

konduruc733182
konduruc733182
July 3, 2023

Hello kavitar5843,

Can you please explain what type of values you are trying to compare?

K
kavitar298810Author
July 3, 2023

i have two record type with same field name and I have a qty field where I want to match the value from both record type. is it same or not

and if the record is not found it gives the error

konduruc733182
konduruc733182
July 3, 2023

You can use "=" if its just integer value or if you have a varchar you can use exact(). But are these two fields of the same type? What do you mean by if the record is not found?

stefanhelzle0001
stefanhelzle0001
Brainy
July 3, 2023

If would try to use the compare operator "=". But I assume your case is more challenging that this. Do you mind sharing some details?

mathieud0001
mathieud0001
Brainy
July 3, 2023

It is not possible to do directly but I would suggest doing a custom record field that does the comparaison and having your query filter on that field.

K
kavitar298810Author
July 3, 2023

I tried but not solved

stefanhelzle0001
stefanhelzle0001
Brainy
July 3, 2023

Do you mind sharing some details? What do you want to achieve?

Terms & ConditionsAccessibility statement