Condition Builder as variable in catalog item

[anshu205samriya]

 

Hi All,

As part of our requirement, we want to build condition builder as variable in catalog item. User will select the required table name on catalog item form first, then subsequent filter options should be made available to the user. 

We have 'type' available as 'conditions' for dictionary fields but the same is not available on catalog item variable type.

If anyone has worked on the similar requirement, please share your input.

Thanks!

[Sagar Pagar]

Hello Anshu,

What is the business requirement where business user needs to select the table on catalog form.

Would you please explain a bit.

Thanks,

Sagar Pagar

[anshu205samriya]

Hi Sagar,

As per our requirement : user can select table name and then can provide appropriate filters (as it works when user creates a report).After submission of request, based on the table name and filters provided -> fetch the records from given table name and  perform the business logic in back-end.

Thanks!

[chrisperry]

Hi there,

I just posted a new article which outlines in detail how to accomplish what you're asking for: Replicate Conditions field type for Service Portal variables

If this answer is helpful please mark correct and helpful!

Regards,

Christopher Perry