Find & Reserve query

[Ashish Jaiswal]

Hi Team,

We are creating Self Service Catalog tile using Find and Reserve and we need to hide "Environment" and "Table Name" as shown below highlighted. Is it possible?



Regards,

[Keith Puzey]

Hi

     I'm afraid you cant hide the Environment drop down and "Table Name" .  A workaround for the table name might be to rename the table by creating an alias in the data model.

------------------------------
Regards

Keith Puzey
Client Services Consultant | Enterprise Software Division
Broadcom
------------------------------

[Ashish Jaiswal]

Hi Keith,

Thank you for the response. We have one more query on F&R.

Is it possible to apply SQL filters to pick only few values for a particular column?
For eg - If one column say "Cardtype" having values as VISA,MASTER,AMEX but to tester we only need to show value as VISA.

Regards

[Scott Schmitz]

Ashish, if you wish to limit records according to filters, then you should base the Find & Reserve model off of Database Views (available in 4.9.1).   

[Ashish Jaiswal]

Hi Scott,

Thank you for your response.

We are using version 4.9.1. How can we base the Find & Reserve model off of Database Views. Can you please assist?

Regards,

[Billy Keefer]

Ashish, create your view with the necessary where clauses etc  and then discover it (model it) as if it was a table.