search

hougaard / Simple-Object-Designer

Issue tracking for the Simple Object Designer for Business Central
7 stars 0 forks source link

Comparing fields with a flowfield #291

Closed mikeswartzentruber closed 10 months ago

mikeswartzentruber commented 10 months ago

How do we compare fields in a flowfield? Trying to return YES if one field is equal or larger than another field.

Here is what i have.

image

hougaard commented 10 months ago

What type is field 50733?

hougaard commented 10 months ago

But no, you cannot use another field in a flowfield that way. Only constants are allowed in a "filter"

mikeswartzentruber commented 10 months ago

Thanks Erik,

Field 50733 is a Flowfield returning a sum of field 83 of table 5406. (Decimal)

Any roadmap to bring a functionality like this in the future?

hougaard commented 10 months ago

FlowFields inside flowfields will never work. This is a Business Central limitation, nothing I can do about that :)

hougaard commented 10 months ago

But you might want to look into calculated fields instead...

mikeswartzentruber commented 10 months ago

Got it, i did create a calculated field with this, but i can't filter that field in any way.

What I'm using this for is on a list I want to filter out all lines that have flowfield field #1 greater than flowfield field #2. is there another approach to do this? If i could use a calculated field inside a flowfield would work as well, but i can't....

Thanks for your support!