I have a database table that contains group records. The fields are Id, Name, T

I have a database table that contains group records. The fields are Id, Name, Type, Category, Status, etc. I am trying to retrieve the name for a given Id.

Let me draw an example:

Id          Name           Type          Category          Status
1          OMG Cookies          Project          Food          Active
2          Dream Home          Project          Home          Active

I have created a query rule that returns the entire record. The input is the record id. So in the above given record id 1 it would return
1 OMG Cookies Project Food Active but all I really want is the name OMG Cookies.

I have thought of a couple of workarounds to get the name only but I was hoping there is an easy way for me to do this without doing a lot of unnecessary stuff.

Any help would be appreciated. ...

OriginalPostID-96242

OriginalPostID-96242