Ttdfjt

Why debootstrap can only run as root?

You look catfish vs You look like a catfish?

Applying a function to a nested list

Short story about people living in a different time streams

Map one pandas column using two dictionaries

Did we get closer to another plane than we were supposed to, or was the pilot just protecting our delicate sensibilities?

What does air vanishing on contact sound like?

Does higher resolution in an image imply more bits per pixel?

If Melisandre foresaw another character closing blue eyes, why did she follow Stannis?

Visa for volunteering in England

Disabling Resource Governor in SQL Server

Binary Numbers Magic Trick

If 1. e4 c6 is considered as a sound defense for black, why is 1. c3 so rare?

Why was Germany not as successful as other Europeans in establishing overseas colonies?

Any examples of headwear for races with animal ears?

Pressure to defend the relevance of one's area of mathematics

What word means "to make something obsolete"?

Is lying to get "gardening leave" fraud?

Is balancing necessary on a full-wheel change?

How can I close a gap between my fence and my neighbor's that's on his side of the property line?

How to reply this mail from potential PhD professor?

Why do computer-science majors learn calculus?

Survey Confirmation - Emphasize the question or the answer?

Transfer over $10k

Magento order grid: is it a new or an existing customer?

Add new field to administration orders gridCreate New Order for New CustomerMagento add Customer Email to adminhtml order grid (Mage 1.8)Magento create new order based on anonymous checkout clientMagento send new order mail when order is created but not paidProgrammatically create new orders from multiple existing ordersHow can I add the Company Name to the Billing Address information in a new order email?Magento Direct SQL New vs Existing CustomersCopy an order to create a new orderMagento new order email going to customer but no copy sent to me

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

Magento order grid: is it a new or an existing customer?

Question: Is there a way to mark or colour the order in the order grid based on the question: is it a new or an existing customer? - or how would I go about doing this

Preferably I would not only like to validate by account used - but rather by: has an order been placed before using the email address

magento-1.9 php orders order-grid

share|improve this question

edited Dec 23 '16 at 9:40

Rakesh Jesadiya

30.5k1577126

asked Jul 7 '16 at 7:15

SNHSNH

95111

add a comment | 

1

Magento order grid: is it a new or an existing customer?

Question: Is there a way to mark or colour the order in the order grid based on the question: is it a new or an existing customer? - or how would I go about doing this

Preferably I would not only like to validate by account used - but rather by: has an order been placed before using the email address

magento-1.9 php orders order-grid

share|improve this question

edited Dec 23 '16 at 9:40

Rakesh Jesadiya

30.5k1577126

asked Jul 7 '16 at 7:15

SNHSNH

95111

add a comment | 

Magento order grid: is it a new or an existing customer?

Question: Is there a way to mark or colour the order in the order grid based on the question: is it a new or an existing customer? - or how would I go about doing this

Preferably I would not only like to validate by account used - but rather by: has an order been placed before using the email address

magento-1.9 php orders order-grid

share|improve this question

edited Dec 23 '16 at 9:40

Rakesh Jesadiya

30.5k1577126

asked Jul 7 '16 at 7:15

SNHSNH

95111

Magento order grid: is it a new or an existing customer?

share|improve this question

edited Dec 23 '16 at 9:40

Rakesh Jesadiya

30.5k1577126

asked Jul 7 '16 at 7:15

SNHSNH

95111

share|improve this question

edited Dec 23 '16 at 9:40

Rakesh Jesadiya

30.5k1577126

asked Jul 7 '16 at 7:15

SNHSNH

95111

edited Dec 23 '16 at 9:40

Rakesh Jesadiya

30.5k1577126

edited Dec 23 '16 at 9:40

Rakesh Jesadiya

30.5k1577126

asked Jul 7 '16 at 7:15

SNHSNH

95111

asked Jul 7 '16 at 7:15

SNHSNH

95111

1 Answer
1

active

oldest

votes

0

This could be done by joining with the same orders table and executing a count and group by.

The logic would be similar to


SELECT * FROM CALLER WHERE USERNAME IN
(
SELECT USERNAME FROM CALLER
GROUP BY USERNAME
HAVING COUNT(*)>1
)


share|improve this answer

answered Apr 26 at 13:14

SNHSNH

95111

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f124615%2fmagento-order-grid-is-it-a-new-or-an-existing-customer%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

This could be done by joining with the same orders table and executing a count and group by.

The logic would be similar to


SELECT * FROM CALLER WHERE USERNAME IN
(
SELECT USERNAME FROM CALLER
GROUP BY USERNAME
HAVING COUNT(*)>1
)


share|improve this answer

answered Apr 26 at 13:14

SNHSNH

95111

add a comment | 

0

This could be done by joining with the same orders table and executing a count and group by.

The logic would be similar to


SELECT * FROM CALLER WHERE USERNAME IN
(
SELECT USERNAME FROM CALLER
GROUP BY USERNAME
HAVING COUNT(*)>1
)


share|improve this answer

answered Apr 26 at 13:14

SNHSNH

95111

add a comment | 

This could be done by joining with the same orders table and executing a count and group by.

The logic would be similar to


SELECT * FROM CALLER WHERE USERNAME IN
(
SELECT USERNAME FROM CALLER
GROUP BY USERNAME
HAVING COUNT(*)>1
)


share|improve this answer

answered Apr 26 at 13:14

SNHSNH

95111

share|improve this answer

answered Apr 26 at 13:14

SNHSNH

95111

answered Apr 26 at 13:14

SNHSNH

95111

answered Apr 26 at 13:14

SNHSNH

95111