Search for empty Product Custom Fields?

[dOctype]

Hello, we have in our WHMCS multiple custom fields for products.

How can we?:

 

1. Search for empty values of Product custom Fields (we created a custom field called CDN, so when we setup that domain/product on the CDN we put the new dns in that text field, but we don't know how to extract all products that haven't the CDN set up yet)

 

2. Search for two custom fields at once.

 

Please we have chosen WHMCS to manage our clients products but it's very difficult wihout a useful Search.

If WHMCS doesn't allow this kind of searchs, can you recommend me some Module/Addon ?

 

Thanks.

[sentq]

I think your request can be achieved by creating new Report, you will need to write the right SQL queries to collect these information together from database tables (2 or 3)

[brian!]

i'd go along with sentq on this... ultimately, you're looking at querying the database and if none of the built-in searches or reports can do it, you may need a custom one.

 

I suppose potentially you may be able to do (1) via clients -> products/services and then searching via the filter for specific products with specific empty custom field - though you wouldn't be able to modify the output (not easily anyway)... for (2), that's going to have to be a query to the database - either directly or within a report.

 

there is a Report Generator module addon, but i'm not sure if it can handle customfields - in any event, it's not cheap and, unless you were planning on regularly creating new reports, it would probably be easier to pay someone to write a custom report for you for this specific task - assuming you can't write one yourself.

 

you can invite developers to quote for a custom report by posting in the Service Offers & Requests forum.

[dOctype]

Thank you guys... I can't beleive WHMCS hasn't this features when we have 10000 updates a month.

I will create a custom report with PHP / MySQL to search by multiple custom fields at once and with empty values.

Thank you all