Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Lookup query on a vtiger database
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Lookup query on a vtiger database
#40418
Lookup query on a vtiger database 11 Years, 7 Months ago Karma: 0
Hi,

can you tell me if I can use AriData to search my vtiger database. It is on the same hosting as my Joomla website. Basically I just want users to be able to search (using a a few fields: Company name, address etc.) from my database and be able to filter the search i.e. by location and one other category, then be presented with a list of results to view.

Is this possible with AriData?

Thanks in advance
The administrator has disabled public write access.
 
#40430
Re:Lookup query on a vtiger database 11 Years, 7 Months ago Karma: 760
Hello,

Sorry, but the extension doesn't support the described abilities.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#40458
Re:Lookup query on a vtiger database 11 Years, 7 Months ago Karma: 0
Hi,

I already bought the module (but not wasted as can use it in the future too). I was looking at the demo, and all I need is a table like in the example but with more filter boxes above. Is this not possible?

Secondly, how do I display the data as have set up the connection but not sure what I put in the sql bit of the of the module.n Can you provide an example sql for the one you have produced in the demo?
The administrator has disabled public write access.
 
#40459
Re:Lookup query on a vtiger database 11 Years, 7 Months ago Karma: 760
"ARI Data Table" widget supports ability to use only textbox for searching. It doesn't provide ability to use additional filters.

The extension shows data from a database based on "SELECT" SQL query. For example you can use the following SQL query:

Code:


SELECT
 id,
 title
FROM
 #__content



Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 1