I’m sure that this has been addressed elsewhere but my searches haven’t turned up exactly what I’m looking for.
In an application’s selector properties, using manually entered sql, I’d like to be able to refer to the current value of a drop down - not the drop down’s display value but it’s value.
In my case sys_title is determined using a drop down and I’m thinking something like this might work:
select categoryid from rx_development_lookups.dbo.category where parentid = :"PSXPARAM/sys_title"
Am I correct or would this refer to sys_title’s current display string and not it’s current value?
Any feedback is appreciated. Thanks!