Hello,
I'm hoping to figure out if it's possible to circumvent using T_KWCODED_VALUES as the ref_tbl in T_KEYWORD when creating a new criterion.
For some background, a donor helped us compile a small database that cross references our donors with other organizations in our region. I've created a local table to house that information, specifically the customer_no, program_name, org, amount, and created_dt. I've already created criterion that allow for use of the amount and created_dt, but am curious to find out the best way to use the org field as a filter. Since it is a character string, I was wondering if I could reference back to the same org field in the custom table so that each of the organizations is available in a dropdown rather than having to type the names in and risk a misspelling.
I appreciate any advice.
Best,
Tony ;})
Sure, you can use anything. I often use reference tables or views of things like keywords or performance codes, etc.
Thanks, Gawain for the confirmation. I had thought so, but wasn't sure if the detail and ref tables could be the same. I just tested it and it works, but another concern that I didn't mention in my initial posting was duplication of the dropdown choices.
Since the information compiled is of program listings from other organizations, the same organization will pop up in the table multiple times as many of our donors have also supported that organization. I don't believe the Ref_Desccol or Ref_Idcol fields recognize select distinct. So that's creating a small problem. Any ideas there?
I think it does support it, but I don't remember. What I do in those cases is create custom Views in SQL so that I get a pulldown with values formatted the way that I want: not sure if you are comfortable building those or not.
I wasn't until I just looked up how to do it. For this specific application, basically creating a view to act as a reference table, it was super easy and tested out perfectly. I also used the new view to create an output set parameter to filter on organization as well.
Thanks for your help! That was great and I learned some new helpful skills.
Hooray, and well done!