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
Discussion posts and replies are publicly visible
Hello kavitar0003,
Can you please explain what type of values you are trying to compare?
If would try to use the compare operator "=". But I assume your case is more challenging that this. Do you mind sharing some details?
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.
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
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?
i used the exact function
in recordtype1 having 3 records and recordtype2 having 10 records
if the record is not found it gives the error
I tried but not solved
Do you mind sharing some details? What do you want to achieve?
So what is the relation between these two records. and what is the purpose of comparing. Just asking to help. When you are comparing a record value with another record value, you might be having some criteria. please help us with your scenario so that someone can help you.
What did you try exactly?