Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Search.fnc.php performs wrong query #270

Closed
dzungdo opened this issue Oct 21, 2020 · 4 comments
Closed

Search.fnc.php performs wrong query #270

dzungdo opened this issue Oct 21, 2020 · 4 comments
Labels

Comments

@dzungdo
Copy link
Contributor

dzungdo commented Oct 21, 2020

Select: Menu > Users > Associate Students with Parents
This bring up a search page,
One of the preconfigured field is "Email Address" - this searches correctly.

I have a custom field named "Phone", with type of "Text"

When search, the result failed to find anything. Because Search is searching for "custEmail"

@francoisjacquet
Copy link
Owner

Hello @dzungdo

I was not able to reproduce the issue:
image

image

image

Please provide screenshots or a video which clearly shows the issue.

@dzungdo
Copy link
Contributor Author

dzungdo commented Oct 21, 2020

In my case, I can reproduce it every time.

  1. Select "Associate Students with Parents"
    image

image

image

image

I am using 7.2.2

@dzungdo
Copy link
Contributor Author

dzungdo commented Oct 22, 2020

Inspecting HTML codes on two different pages:

Associate Parents with Students
Student Email

<tr class="">
   <td><label for="custCUSTOM_200000015">Student Email</label></td>
   <td><input type="text" name="cust[CUSTOM_200000015]" id="custCUSTOM_200000015" size="24" maxlength="1000"></td>
</tr>

Student Mobile Number:

<tr class="">
   <td><label for="custCUSTOM_200000016">Student Mobile Number</label></td>
   <td><input type="text" name="cust[CUSTOM_200000016]" id="custCUSTOM_200000016" size="24" maxlength="1000"></td>
</tr>

Associate Students with Parents
User Email:

<tr class="">
   <td><label for="custEMAIL">Email Address</label></td>
   <td><input type="text" name="cust[EMAIL]" id="custEMAIL" size="24" maxlength="1000"></td>
</tr>

User Mobile Number: (This is a different custom field but same content)

<tr class="">
   <td><label for="custEMAIL">Mobile Number</label></td>
   <td><input type="text" name="cust[EMAIL]" id="custEMAIL" size="24" maxlength="1000"></td>
</tr>

Should cust[EMAIL] be something like cust[CUSTOM_200000001] ?

@francoisjacquet
Copy link
Owner

Hello @dzungdo

Thank you for the screenshots.
The issue is fixed. Please upgrade to v7.2.3

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants