Forum Discussion

AndreaF's avatar
AndreaF
Contributor III
2 years ago

Use of XFBR in the SQL query of a Bound List parameter

Hi, I have a Bound List parameter with Command type SQL. 1. I have first tried to use an XFBR rule within the string of the Like condition. This works fine. 2. I have then tried to use the XFBR...
Dashboards
  • JackLacava's avatar
    JackLacava
    2 years ago

    I know I am being "that guy", but I don't think stretching XFBR hacks is the right strategy here... Once you start messing with structural query conditions, spreading your logic between the adapter and XFBRs is harder to maintain, and you hit these unknown walls determined by internal OS behaviour.

    IMHO, at that point it is cleaner to jump in the world of Dashboard DataSets. You get full control of your query, in code, and all the related logic is in one place. There are a couple of blog posts that describe them in decent detail: one about basic structure, and two about using SQL in it. The initial investment in learning the technique will likely pay off multiple times going forward.

JackLacava's avatar
JackLacava
Honored Contributor
2 years ago

I know I am being "that guy", but I don't think stretching XFBR hacks is the right strategy here... Once you start messing with structural query conditions, spreading your logic between the adapter and XFBRs is harder to maintain, and you hit these unknown walls determined by internal OS behaviour.

IMHO, at that point it is cleaner to jump in the world of Dashboard DataSets. You get full control of your query, in code, and all the related logic is in one place. There are a couple of blog posts that describe them in decent detail: one about basic structure, and two about using SQL in it. The initial investment in learning the technique will likely pay off multiple times going forward.