Category Archives: Uncategorized

How to Add Custom table in Views Query Alter tutorial

Hint book for programmers

Issue: How to Add Custom Table in View Query Alter.

Solution:
We can add our custom table in view query with the help of hook_views_query_alter .

I have table name Custom Table name “custom_node” and I want add this table in my views Query to make the Condition result for View.

Code Example:
function hook_views_query_alter(&$view, &$query){
if($view->name == “view_machine_name”) {
$join = new views_join();
$join->table = ‘custom_node’;
$join->field = ‘custom_id’;
$join->left_table = ‘node’;
$join->left_field = ‘nid’;
$join->type = ‘inner’;

$query->add_relationship(‘custom_node’, $join, ‘node’);

$query->where[1][‘conditions’][] = array(
‘field’ => ‘custom_node.custom_nid’,
‘value’ => array(‘7’), // Make your condition with the help of Where Clause
‘operator’ => ‘in’
);

}

}

View original post

Advertisements

Phone bars and CRM

Sugar corner

CTIeCRMAmong the essential tools to get the full control of the Contact Center, the Phone Bar is the application, also known as agent, installed in the operator terminal that allows to effectively manage inbound & outbound calls. Moreover, the Phone Bar exploits the potentiality arising by CTI (Computer Telephony Integration), the increasingly integration between the phone, the pc and the CRM application. In the following

View original post 1,025 more words

Don’t Let These Email Marketing Myths Ruin Your CTR

Maulik Shah's Blog

Are you running an email campaign? Chances are you have certain email marketing myths or better say prejudice that may jeopardize your CTR! We have built a list of email marketing myths that reduces the Click-Through Rate (CTR). Reduction in CTR will result in unexpected outcomes of email marketing campaign. Enterprises conducting email marketing campaigns should ensure they are doing it right rather annoying their customers. Being it the most interesting part of the online marketing strategy, it has to be commendably intuitive with the business flavor!

Your business requires a marketing strategy that adds impetus to the business performance. Email template design is important for businesses seeking huge customer range. It has to fulfill the business goals and objectives.

Get Rid of These Email Marketing Myths that Reduces CTR

1.Email Campaign Should Target only Millennials

A study says email opening rate among millennials is very less (they prefer text…

View original post 589 more words

Second taste of glory for 2 Slick

Chad '2 Slick' Sugden

ChadGloryNewark’s Chad ‘2 Slick’ Sugden will be back on the road to glory on Friday 3 April, when he takes on Atakan Arslan on the card of GLORY 20.

The Suggy’s Gym fighter had his first taste of GLORY in March 2013, defeating Sam Wilson when the promotion came to the Excel Arena in London. Now he will be heading to Dubai for a 77kg Superfight against his Turkish opponent.

“This is a really exciting opportunity for me,” said Chad. “Not only do I get to visit Dubai for the first time but I’ll be going there to take part in one of the GLORY shows, which are renowned for promoting match ups between some of the world’s top fighters.

“Training in the run up to early April is going well and I’m looking forward to shaking up the Welterweight division with my unique skills. My opponent for this one…

View original post 155 more words

Chivalry: Medieval Warfare gets console release dates

Geekly Gaming

chivalrylogojpg-d7e637_960w

Activision and Torn Banner Studios revealed the console release dates for Chivalry: Medieval Warfare alongside new screenshots today.

The game is coming to PS3 on December 2 and Xbox 360 on December 3 for $15 USD. Chivalry: Medieval Warfare will launch with over sixty weapon options, customizable gear, and twelve-player online support for a variety of game modes, including Free-for-All and Team Deathmatch.

Enjoy the gallery below!

View original post