• Replies 1 reply
  • Subscribers 336 subscribers
  • Views 53 views
  • Users 0 members are here
Related

T_KEYWORD - distinct values in dropdown list

Lee-Anne Inglis (Past Member)
$organization

Hi 

I've created a new Special Activity - performance criteria via T_KEYWORD, which looks at the data in the perf column in the relevant table.  Ideally I want this to be a dropdown list but I can't work out how to pull out distinct values instead of it listing very single entry in the table.  I know the SQL coding but how do I detail this in T_KEYWORD?  I would be grateful for any help.

Very many thanks

Lee-Anne

Parents
  • $organization

    Hi! If I understand your question correctly, you can use the Ref Where column in T_KEYWORD to identify the values you want from your special activity table or view. Type in "id in(x,y,z)" under Ref Where, and instead of x, y and z, use the identity values of your entries in the special activity table.

Reply
  • $organization

    Hi! If I understand your question correctly, you can use the Ref Where column in T_KEYWORD to identify the values you want from your special activity table or view. Type in "id in(x,y,z)" under Ref Where, and instead of x, y and z, use the identity values of your entries in the special activity table.

Children
No Data